MAXDOP and cost threshold work together to shape parallel plans; inspect current values, test a change, and watch real workload effects.
SQL SERVER – Reducing CXPACKET Wait Stats for High Transactional Database
Reducing CXPACKET wait stats on a high transactional database: what CXPACKET means, and when lowering the degree of parallelism really helps.
SQL SERVER – Visiting Alma Mater – Delivering Session on Database Performance and Career – Nirma Institute of Technology
I went back to my alma mater, Nirma Institute of Technology in Ahmedabad, to deliver a session on database performance and career. It felt wonderful.
SQL SERVER – Quickest Way to Identify Blocking Query and Resolution – Dirty Solution
A friend could not delete, truncate or drop a table at 11 PM because of open transactions. Here is my quick and dirty way to identify blocking query.
Finding the Nearest Location With a Spatial Index
A nearest location query in SQL Server needs TOP, STDistance in WHERE and ORDER BY, matching SRIDs, and a checked spatial plan.
SQL SERVER – Disabled Index and Index Levels and B-Tree
For T-SQL Tuesday I write about my mentor Vinod Kumar and his interesting question, which leads to a disabled index, its index levels and the B-Tree.
SQL SERVER – Soft Delete Conversation – Your Opinion Needed
My soft delete post got great replies on both sides. Here are short abstracts from readers like Karen Lopez and Tyler Clendenin, and your input is welcome.