Script: Find FillFactor of All Indexes in a Database
In our previous blog posts, we have seen how to find fragmented indexes in a database and how to defrag them by using rebuild/reorganize. While creating or rebuilding indexes, we can also provide an option [...]
Recorded Webinar: Intelligent Query Processing in SQL Server 2019
Hello Friends, Here is a popular webinar from our recordings: Intelligent Query Processing in SQL Server 2019 Intelligent Query Processing in SQL Server 2019 Speaker: Joe Sack (Principal Program Manager, Microsoft) Abstract: Microsoft [...]
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, based upon index fragmentation [...]
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 (Physical order of pages [...]
Script: 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 every table in the [...]
Faster INSERTs in Tempdb – Optimized/Minimal Tempdb Logging
Faster INSERTs in Tempdb – Optimized/Minimal Tempdb Logging In this blog post, we will see how SQL Server optimises Tempdb logging for faster CRUD operations. For the purpose of this tutorial, we will perform the [...]
