Browse by Tags

• clustered index
• declare
• information schema
• performance
• power shell
• scheduler
• sql server
• sqlos
• tsql

TSQL to get clustered index information in SQL Server 2005
10 March 08 01:00 AM | SQL Master | 3 Comments   

Recently within a supportal case with CSS we have been given the following TSQL to get information on indexes, where I have modified a bit to get 'Clustered' index information alone that was helpful to see which tables lack of clustered index alone. declare Read More...

Filed under: tsql, sql server, schema, dmv, information schema, declare, clustered index

List the wait resources and scheduler waits from OS
24 July 07 04:01 AM | SQL Master | 1 Comments   

Got the below script from PSS when we were dealing with a support case to identify the root cause for Scheduler errors during a performance loss & exception errors exercise: select scheduler_id, current_tasks_count, runnable_tasks_count, current_workers_count, Read More...

Filed under: performance, schema, dmv, sqlos, scheduler, power shell