Browse by Tags

TSQL to obtain a list of current execution of Parallel Plans (MAXDOP)

Published 4 September 7 9:32 AM | SSQA.net

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...

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

Performance Tuning - will I loss the indexing when using derived table?

Published 21 August 7 3:19 AM | SSQA.net

This was the question asked by a Developer when we are investigating a performance loss issues on a database. To the point a derived table means a virtual table that's calculated on the fly from a select statement. By default using derived tables...

Filed under: sql server, performance, tuning, query, stored procedure, joins, indexed views