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 moreAuthor: parmsingla
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 moreMSSSQL Server Tuning – Find Wait stats
Problem Statement: Script to get the SQL Server wait stats. You can find the significance of most common waits below it. Solution:[…]
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 more
