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
Stephen Tirone
SQLSaturday #250 Pittsburgh
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, the Schedule is Up!
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
SQLSaturday #171 Pittsburgh Prep Continues
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
ComputeReach
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
SQL Saturday #171 Pittsburgh!
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
How Good is Good Enough?
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
Using "Multiple Assignment Variables" for a Generic Compare Data Script
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
Caution with EXCEPT
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
Blogs
The PASS Summit on Tour in Dallas
By Steve Jones
The PASS Summit goes on tour this year, with a September stop in Dallas....
SQL Server Auto-settings: The Good, the Bad, and the Ugly
By Kevin3NF
Settings That Could Be Hurting Your Performance If you’ve ever created a new SQL...
Bad Request Error when Running PowerShell Command in Azure Devops
I needed to run a PowerShell cmdlet in an Azure Devops pipeline. The cmdlet...
Forums
How a Legacy Logic Choked SQL Server in a 30-Year-Old Factory
Comments posted to this topic are about the item How a Legacy Logic Choked...
Has the PK been used --
Comments posted to this topic are about the item Has the PK been used...
Has the PK been used --
Comments posted to this topic are about the item Has the PK been used...
Question of the Day
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