SSG Blog
Insights and news from the SQL Solutions Group.
Recent
Capture Index Maintenance Operations
One good database maintenance practice is to keep the indexes in good working order. This is typically done via index defragmentation routines. Some people perform
Adventures with NOLOCK
Some of the beauty of being a database professional is the opportunity to deal with our friend NOLOCK. For one reason or another this query directive
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 am on “vacation.” I have
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 notice that in order to
2014 Iron Man: Randy Knight
Randy Knight, MCM and founder & president of SSG, has been a frequent participant at SQL happenings, primarily SQLSaturday events. But what Randy did earlier
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 ‘max server memory’. In versions