a section on indexing and performance tuning.
In preparation for a SQL Saturday presentation I have created another report to add to the FREE SQL Server Health reports project. The Database Size Report has been added to the SQL Health Reports. The Database Size Report is …
Database Size report added to SQL Health Reports Read more »
The CPU utilization report has been added into the SQl Server Health Reports. Here is a preview of the report.
After creating and deploying the duplicate indexes report earlier today I discovered that although the report did exactly what it says, it didn’t do what I needed. The earlier duplicate indexes report only found indexes that were an exact match on the …
After yesterdays Long Running Queries Report, I have decided to add one more SQL Server Health report. A duplicate indexes report has been added to the Server Health reports. With this report you can track down time waste associated with duplicate indexes. Here …
A long running queries report has been added to the Server Health reports. With this report you can track down time consuming queries that may be causing excessive load on your server. Here is a sample of the new free …
I just submitted abstracts to SQL Saturday #114 in Vancouver and #108 in Redmond. The Redmond SQL Saturday appears to be the more popular of the two. Who knows if my session will get accepted, but I am giving it …
Over the last couple of weeks I have taken a couple of the common queries that I use to analyze the health of a SQL Server and built them out into a SQL Server 2008 SSRS report. I have decided …
Is it a good idea to run DBCC SHRINKDATABASE regularly? Download the sample file ShrinkSample. This article and samples apply to SQL Server 2005, 2008, and 2008R2. This really depends on a number of factors, but generally the answer is …
The question comes up when looking at an execution plan of whats the difference between an index seek and an index scan. What it really comes down to is speed, for tables with a large number of rows, and …
Just the same query that I posted months ago, but this time it is wrapped in a stored proc. I use this one often enough that it is easier to just call the stored proc. Download the FindOneTimeUseQueries source code. TSQL example: …