Thanks for the Help with Deadlocks
It's time to start blogging again. And for my first post in a very long time, I mainly want to...
2015-05-08 (first published: 2015-05-02)
7,533 reads
It's time to start blogging again. And for my first post in a very long time, I mainly want to...
2015-05-08 (first published: 2015-05-02)
7,533 reads
SQLSaturday #250 Pittsburgh is in the books, and I'd like to sincerely thank the organizers, sponsors, volunteers, and speakers for...
2013-09-16
468 reads
SQL Saturday #171 Pittsburgh preparations continue, and the schedule has been posted for your review. If you're anywhere in the...
2012-09-18
743 reads
Hey, did I mention that Pittsburgh is having a SQLSaturday this year?
Pittsburgh, Pennsylvania. Photo:Herbert Spencer, used under Creative Commons...
2012-07-30
1,549 reads
Man it's tough to get in all that you want to do, isn't it? I've been trying to get my...
2012-07-21
699 reads
It's official, there's going to be a SQL Saturday in Pittsburgh this year!
The date is October 6th, and the...
2012-07-18
591 reads
I was running some tests on some purchased data this morning, and was getting a little perturbed because I was...
2011-06-16
597 reads
Comparing data between tables seems like a simple thing to do, but it can eat up a lot of a SQL Server professional's time. Stephen Tirone shows how multiple assignment variables can be used to make this task a little easier.
2010-01-26
5,985 reads
The EXCEPT operator, introduced in SQL Server 2005, can be handy in some situations where you are comparing data between two tables. New author Stephen Tirone brings us a potential issue to be aware of with this operator.
2010-01-18
14,637 reads
By Steve Jones
The PASS Summit goes on tour this year, with a September stop in Dallas....
By Kevin3NF
Settings That Could Be Hurting Your Performance If you’ve ever created a new SQL...
I needed to run a PowerShell cmdlet in an Azure Devops pipeline. The cmdlet...
Comments posted to this topic are about the item How a Legacy Logic Choked...
Comments posted to this topic are about the item Has the PK been used...
Comments posted to this topic are about the item Has the PK been used...
You're analyzing a query execution plan in SQL Server to determine whether the query optimizer chose to use a primary key index. Which Dynamic Management View (DMV) would you use to verify the usage of the primary key in the plan?
See possible answers