Browsing Archive: July, 2012

Quick but useful Index Fragmentation

Posted by John Trumbul on Friday, July 13, 2012, In : SQL Scripts 
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 ...
 

Good News and Another Apology

Posted by John Trumbul on Wednesday, July 11, 2012,
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 ...
 
 

This free website was made using Yola.

No HTML skills required. Build your website in minutes.

Go to www.yola.com and sign up today!

Make a free website with Yola