MAXDOP and Cost Threshold for Parallelism – an example for a parallel query
The most popular post on this blog ranked by hits is one about the CXACKET wait stat. There are no...
2012-06-18
2,398 reads
The most popular post on this blog ranked by hits is one about the CXACKET wait stat. There are no...
2012-06-18
2,398 reads
Tuesday’s (June 19th, 2012) PASS Data Architecture Virtual Chapter has Neil talks about database design that uses Constraints for Integrity...
2012-06-14
696 reads
I have 2 upcoming speaker opportunities in June and am very excited about presenting this material.
June 9th is in...
2012-05-26
760 reads
Baton Rouge’s annual tech event for the IT community is coming up August 4th on the beautiful campus of LSU....
2012-05-17
664 reads
Thursday’s (May 17th, 2012) PASS Data Architecture Virtual Chapter has Mike demonstrating some cool Table Partitioning scripts which I was...
2012-05-14
550 reads
I enjoyed a long weekend in Houston starting with Kalen Delaney’s Pre-con on Query Tuning. I have learned over the...
2012-04-27
1,636 reads
Thursday’s (May 17th, 2012) PASS Data Architecture Virtual Chapter has Mike demonstrating some cool Table Partitioning scripts which I was...
2012-04-18
556 reads
Wow, blessed to speaker at another SQL Saturday in Houston #107. The first task of this weekend is Friday. Kalen...
2012-04-09
726 reads
An important operator to understand in execution plans is a scan. A Scan can be good and bad, so understanding...
2012-04-02
4,304 reads
The Merge Join is a Physical Operation when joining 2 sets of data that are in the same order.
There...
2012-03-15
5,896 reads
By Brian Kelley
I am guilty as charged. The quote was in reference to how people argue...
By Steve Jones
Learn how to tie a bowline knot. Practice in the dark. With one hand....
By HeyMo0sh
As a DevOps practitioner, I’ve always focused on performance, scalability, and automation. But as...
Hi everyone I asked this earlier but the desired outcome is a bit different...
Hi, I have a SQL Server instance where users connect to via Windows Authentication,...
Comments posted to this topic are about the item Multiple Deployment Processes
I have a query from a former DBA that we run on SQL Server 2025 to check on database metadata. This query references sys.sysaltfiles. I want to refactor this code to be more modern. Which DMV should I reference instead?
See possible answers