Can individual filegroups be restored separately?
In this recent answer to a question on dba.stackexchange.com regarding the benefits of read-only filegroups, I posited that one might want to restore individual filegroups to enable a piece-meal approach to disaster recovery that allows…
How can I automate statistics management?
Occasionally, it can be beneficial to turn off AUTO_CREATE_STATISTICS and AUTO_UPDATE_STATISTICS, and manage these items yourself. I’ve created the following stored procedure, which lives in master to allow it to be called from the context…
Can statistics be updated for objects in read-only filegroups?
DBA.StackExchange.com has an interesting question about the benefits of filegroups and setting filegroups to read-only which I recently answered. I made several assumptions about read-only filegroups that turned out to be incorrect, one of which…
Missing Index DMVs have a limited capacity. How can I work around that?
The system dynamic-management-views for tracking index suggestions are limited to displaying 500 indexes at most. In a busy system with either a lot of databases or a lot of tables, this can be substantially limiting….
Wait Stats over Time
Looking at Wait Stats over time while a specific piece of work is taking place can be a very helpful method for troubleshooting performance issues. SQL Server exposes wait stats so you can see what…
How do I store a number with leading zeros?
Many line-of-business applications want to store document numbers with leading zeros, such as an Invoice Number, or Cheque Number. The idea behind having the leading zeros is we’ve predefined the format for the document number…
