Sep 2025 Discount: Comprehensive Database Performance Health Check | Testimonials

Home

SQL SERVER – 2005 – Display Fragmentation Information of Data and Indexes of Database Table

Pinal Dave
SQL, SQL Performance, SQL Server, SQL Tips and Tricks
SQL DMV, SQL Index, SQL Scripts, SQL Server DBCC, SQL System Table
One of my friend involved with large business of medical transcript invited me for SQL Server improvement talk last weekend. I had great time talking with group of DBA and developers. One of the topic which was discussed was how to find out Fragmentation Information for any table in one…
Read More

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

SQLAuthority News – Best Articles on SQLAuthority.com

Pinal Dave
SQL, SQL Interview Questions and Answers, SQL Performance, SQL Server, SQL Tips and Tricks
Data Warehousing, Database, DBA, Software Development, SQL Backup and Restore, SQL Coding Standards, SQL Constraint and Keys, SQL Cursor, SQL DateTime, SQL Download, SQL Error Messages, SQL Function, SQL Humor, SQL Index, SQL Joins, SQL Scripts, SQL Server DBCC, SQL Server Security, SQL Stored Procedure, SQL Trigger, SQL Utility
SQL SERVER – Cursor to Kill All Process in Database SQL SERVER – Find Stored Procedure Related to Table in Database – Search in All Stored procedure SQL SERVER – Shrinking Truncate Log File – Log Full SQL SERVER – Simple Example of Cursor SQL SERVER – UDF – Function…
Read More