Search
Repost - originally posted 26-06-2012
- Sep 1, 2017
- 1 min
Hypothetical indexes
We had a query recently about a database that had a lot of objects starting with the name _dta_. We explained that these where hypothetic...
2 views0 comments
Repost - originally posted 07-06-2012
- Aug 24, 2017
- 2 min
How one small change caused the CPU to go crazy
Finding the cause of very high CPU usage on your SQL Server may not be as easy as running scripts against a few DMV's, looking at perfmon...
5 views0 comments
Repost - originally posted 1-06-2012
- Aug 22, 2017
- 1 min
Poor object naming
The following is an example of a poorly named table from a major backup software vendor. This caused failures with the regular maintenan...
3 views0 comments
Repost - originally posted 21-06-2012
- Aug 14, 2017
- 1 min
Full recovery = transaction log backups
A common occurrence in reviewing SQL Server implementations is finding very large databases that have log file sizes greater than the siz...
5 views0 comments
Repost - originally posted 29-05-2012
- Aug 13, 2017
- 1 min
Model database recovery setting
We see a lot of databases in full recovery that don't need to be. Why? Because the default for the model database (used as the template f...
5 views0 comments