Thursday, 23 July 2009
SQL List indexes in db with fragmentation > 30 %
1: SELECT
2: OBJECT_NAME(object_id) ObjectName, 3: index_id, 4: index_type_desc, 5: avg_fragmentation_in_percent6: FROM sys.dm_db_index_physical_stats
7: (DB_ID('AdventureWorks'),NULL, NULL, NULL, 'LIMITED')
8: WHERE
9: avg_fragmentation_in_percent > 3010: ORDER BY
11: OBJECT_NAME(object_id)Tuesday, 21 July 2009
ADO and MARS
Very good article of using MARS for asynchronous data access. There are also other nice posts in the same website
http://www.emoreau.com/Entries/Articles/2006/11/MARS-and-Asynchronous-ADONet.aspx
http://www.emoreau.com/Entries/Articles/2006/11/MARS-and-Asynchronous-ADONet.aspx
Monday, 20 July 2009
WEKA machine learning applications
TClass -- A supervised learning algorithm for multivariate time series:
http://www.cse.unsw.edu.au/~waleed/tclass/
Weka - Modified for Data Mining Course at WPI http://davis.wpi.edu/~xmdv/weka/
http://www.cse.unsw.edu.au/~waleed/tclass/
Weka - Modified for Data Mining Course at WPI http://davis.wpi.edu/~xmdv/weka/
Friday, 17 July 2009
Subscribe to:
Posts (Atom)