Problem Statement: Script to generate the scripts used to de-fragment indexes. Solution: Use this script to find the fragmented indexes and following script[…]
Read moreCategory: SQL Server
SQL Server Tuning – Find Fragmented Indexes
Problem Statement: Script to find fragmented Indexes. Solution: No need to explain how killing fragmented indexes could be.Use following script to[…]
Read moreSQL Server Tuning – Find Duplicate Stats
Problem Statement: Script to find the duplicate stats. Solution: SQL server allows to create duplicate statistics but having duplicate statistics are overkill[…]
Read moreSQL Server Tuning: Find IO wait or Virtual File Stats
Problem Statement: Script to get the virtual file waits for IO waits. Solution: Virtual File waits are useful in identifying the[…]
Read moreMSSQL Server: Find Bad Indexes
Problem Statement: Script to find the Bad indexes Solution: The indexes returned by the below query degrade the performance of the[…]
Read moreMSSQL Server: Find Missing Indexes
Problem Statement: Script to find the missing indexes using 3 different ways. Solution: 1) Find missing indexes using DMVs –Find top ten missing indexes using following DMV SELECT TOP 10 ( user_seeks ) * avg_total_user_cost * ( avg_user_impact * 0.01 ) AS […]
Read moreSQL Server 2005-TSQL Parsing
Following are the Steps used by Query Optimizer to Process a TSQL:
Read more
