Blogs

/Blogs

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 [...]

By |July 6th, 2020|Categories: Scripts, SQL Server|Comments Off on Script: Find FillFactor of All Indexes in a Database

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 [...]

By |July 6th, 2020|Categories: Webinars|Comments Off on Recorded Webinar: Intelligent Query Processing in SQL Server 2019

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 [...]

By |July 3rd, 2020|Categories: Scripts, SQL Server|Comments Off on Script: How to Defragment All The Indexes In a Database

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 [...]

By |July 2nd, 2020|Categories: Scripts, SQL Server|Comments Off on Script: Find The Fragmented Indexes In A Database

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 [...]

By |July 2nd, 2020|Categories: Scripts, SQL Server|Comments Off on Script: Find Tables Without Clustered Index

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 [...]

By |July 2nd, 2020|Categories: SQL Server|Comments Off on Faster INSERTs in Tempdb – Optimized/Minimal Tempdb Logging