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,362 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,218 reads
Blogs
March 2025 SQL Challenge: Test Your Skills with Advanced SQL Scenarios
If you’re an experienced SQL user eager to sharpen your expertise with real-world challenges,...
SQL Saturday Atlanta BI Recap
By DataOnWheels
https://sqlsaturday.com/2025-03-08-sqlsaturday1102/#schedule SQL Saturday Atlanta BI is one of my favorite SQL Saturdays of the...
Mistakes IT Shops Without a DBA Make
By Kevin3NF
We get it. There’s no budget for a DBA on staff, or even a...
Forums
Dynamic T-SQL Script Parameterization Using Python
Comments posted to this topic are about the item Dynamic T-SQL Script Parameterization Using...
SQL 2017 server keeps locking up
I manage a two-node production SQL cluster running SQL Server 2017 CU31 on Windows...
Alternatiives to Junk Dimensions
Hello SSC, I am not sure if I posted this in the right spot,...
Question of the Day
Partial Backups II
What is a partial backup for a read-write database?
See possible answers