Script: How to Defragment All The Indexes In a Database
In our previous blog post, we got to know, how to find out all fragmented indexes in a database. Now we will see how to defrag indexes. According to Microsoft guidelines, …
Read MoreScripts
Script: Find The Fragmented Indexes In A Database
We do create indexes to improve the search performance of our queries. But over a period of time, because of DML operations (inserts/deletes/updates), the data will get spread across the disc …
Read MoreScript: Find Tables Without Clustered Index
Before we start fine tuning SQL Server, it is good to make sure all basic best practices are in place. One such best practice is to have a clustered index on …
Read More