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,895 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, 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
Comments posted to this topic are about the item How to Use sqlpackage to...
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