Under SQL 2008, how to
- check internal & external index fragment ? I use the script below but it seems that it takes a long time to run ..
- how to identify dead lock in SQL 2008 ? How do I know whether a dead lock occur in production environment ? Will the SQL server slow down the performance ?
- how can I identify a long running sql, procedure or jobs in SQL 2008 server ?