Since I happen to be using this right now, I figure i would throw it up. Table not performing the way you would like? Perhaps the index is fragmented to high hell. Usinf this in combination with a Reorganize and Rebuild script should help a great deal.

SELECT ps.database_id, ps.OBJECT_ID,
ps.index_id, b.name,
ps.avg_fragmentation_in_percent
FROM sys.dm_db_index_physical_stats (DB_ID(), NULL, NULL, NULL, NULL) AS ps
INNER JOIN sys.indexes AS b ON ps.OBJECT_ID = b.OBJECT_ID
AND ps.index_id = b.index...
Continue reading ...

Hello All, for the thousandth time I apologize for the lack of updates. However this time I actually have good reason. The company I currently work for now PlayStudios - www.PlayStudios.com is launching our game soon. I believe July 17th is the release date to be exact. More info to follow (for real this time).

In other news I have again been nominated for the Red Gate Exceptional DBA award. I know people can sign up and nominate themselves and if I had done that I would not announce it. Sinc...
Continue reading ...