Browse by Tags

• contribution
• deletes
• indexes
• insert
• locks
• parallelism
• query
• security
• statistics
• stats
• stored procedure
• tsql
• tuning

TSQL to findout blocking and locks on a SQL Server?
07 December 07 12:08 PM | SQL Master | 2 Comments   

Have you ever performed huge operations such as deleting records of a table and processing inserts on that table at the same time? This is a common task that every application will have to perform and you can avoid by fine tuning your queries (mostly Read More...

Filed under: tsql, sql server, performance, indexes, security, blocking, locks, deletes, insert

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