Welcome to WebmasterWorld Guest from 126.96.36.199
Forum Moderators: open
Is there a way I can test for long-running queries?Depending on which version of SQL you have, fire up Profiler.
How can I check index fragmentation levelsIn SSMS, right click on an index, select Properties, and go to Fragmentation. To look at all the indexes on a table, use DBCC SHOWCONTIG (although it's a bit more difficult to decipher):