July 2025 Discount: Comprehensive Database Performance Health Check | Testimonials

Home

SQL SERVER – Difference Between Index Rebuild and Index Reorganize Explained with T-SQL Script

Pinal Dave
SQL, SQL Performance, SQL Server, SQL Tips and Tricks
SQL Index, SQL Scripts
Index Rebuild : This process drops the existing Index and Recreates the index. USE AdventureWorks; GO ALTER INDEX ALL ON Production.Product REBUILD GO Index Reorganize : This process physically reorganizes the leaf nodes of the index. USE AdventureWorks; GO ALTER INDEX ALL ON Production.Product REORGANIZE GO Recommendation: Index should be…
Read More

SQL SERVER – T-SQL Script to Find Details About TempDB Information

Pinal Dave
SQL Tips and Tricks
SQL Scripts, SQL Server, SQL TempDB

Two days ago I wrote an article about SQL SERVER – TempDB Restrictions – Temp Database Restrictions. Since then I have received few emails asking details about Temp DB. I use following T-SQL Script to know details about my TempDB. This script is a pretty old script but it does work great most of the time. I strongly encourage all of you to use a script to check your TempDB Information.

Read More