Finding missing indexes in sql server 2005
the following scripts helps in finding top 5 missing indexes using the new feature of DMV available in SQl Server 2005
2007-07-19 (first published: 2006-10-23)
5,305 reads
Updating all the indexes/statistics of a database
The below command will rebuild all indexes on a database.We need to run the below command in the context of each database that is of interest.
2007-02-21 (first published: 2006-10-23)
1,202 reads
Blogs
Renaming Files by Padding Numbers with PowerShell
By Steve Jones
Some time ago I had downloaded all the SQL Saturday XML files. I’ve been...
When do Statistics get updated?
Statistics objects are important for allowing the SQL Server Optimizer to make good estimates...
Power BI: Making Date & Time Keys
By DataOnWheels
Saving the Day from Delay Part 2 Creating DateKey and TimeKey columns can be...
Forums
Date format - being overridden?
Hi all, Got a strange one here that I hope someone can help with....
Best way to understand Querying much better
What's the best way to get better at T-SQL Querying? Something like Read/do the...
Intermittent "nesting level exceeded" error
We're having a very peculiar problem with the "Maximum stored procedure, function, trigger, or...
Ask SSC