Browse by Tags

• contribution
• create
• parallelism
• performance
• script
• sql server
• statistics
• stats
• stored procedure
• tables
• tsql
• tuning

TSQL to obtain a list of current execution of Parallel Plans (MAXDOP)
04 September 07 07:32 AM | SQL Master | 2 Comments   

PARALLELISM is a close friend of DBA where you get to see it as a common occurence in the multi-processor server environment and during such performance issues you can also investigate whether a parallel plan is in use. For instance If a particular query Read More...

Filed under: sql server, performance, query, blocking, stored procedure, statistics, tuning, stats, parallelism, contribution

TSQL to generate blocking scenario for testing
27 July 07 12:44 AM | SQL Master | 1 Comments   

Most of the times you have observed to identify the blocking and how to resolve them. How about you need a script to generate a blocking scenario within your queries, this is to identify the blocker script is working or not. Also will help to test whether Read More...

Filed under: tsql, sql server, tables, query, script, create, blocking