Capture Index Maintenance Operations
One good database maintenance practice is to keep the indexes in good working order. This is typically done via index
January 21, 2015
Tag: #SQLLearning
Adventures with NOLOCK
Some of the beauty of being a database professional is the opportunity to deal with our friend NOLOCK. For one reason
January 6, 2015
Unplug Now! Is it Possible?
At this very moment, as I write this, I am visiting my daughter and my grand kids for Christmas. I
December 30, 2014
Automating DBCC Page
Way back in 2006, Paul Randal documented DBCC PAGE on his Microsoft blog at https://blogs.msdn.com/b/sqlserverstorageengine/archive/2006/06/10/625659.aspx. In his post, you will
December 23, 2014
2014 Iron Man: Randy Knight
Randy Knight, MCM and founder & president of SSG, has been a frequent participant at SQL happenings, primarily SQLSaturday events.
December 22, 2014
When is Max Memory in SQL Server not Max Memory?
When thinking about configuration parameters for SQL Server, one of the first ones to look at is the sp_configure option
December 15, 2014
T-SQL Tuesday #61– Giving Back!
The subject for this T-SQL Tuesday is Giving Back. I have been a taker in the SQL community for many years.
December 9, 2014
T-SQL Tuesday #61–Giving Back
The topic for this month’s T-SQL Tuesday (Giving Back to the SQL Server Community) is one that is near and
December 9, 2014
‘Twas the night before the upgrade…
‘Twas the night before the upgrade, when all through the place Not a backup was working, “there’s not enough disk
December 9, 2014
An Extended Events Trifecta
When working with Extended Events, there are times when a little more information is, well, helpful. You know you want
December 2, 2014