T-SQL Tuesday #78 : Is a RID Lookup faster than a Key Lookup?
For T-SQL Tuesday #78, I take a look at whether RID Lookups are faster than Key Lookups, with a small battery of fairly simple duration tests.
Category: T-SQL Tuesday
T-SQL Tuesday #72 : Models Gone Wild!
For this T-SQL Tuesday, I treat some of the most memorable data modeling sins from over the years.
T-SQL Tuesday #69 : Always Encrypted Limitations
For this T-SQL Tuesday, I talk about a few of the limitations of Always Encrypted.
T-SQL Tuesday #68 : All Features With Defaults
I look at the tempting All Features With Defaults installation choice for this T-SQL Tuesday.
T-SQL Tuesday #67 : New Backup and Restore Extended Events
For T-SQL Tuesday #67, I describe a new way to track backup and restore operations using Extended Events in SQL Server 2016.
T-SQL Tuesday #66 : Babysitting a Slow Backup or Restore
For T-SQL Tuesday, I discuss undocumented trace flags that provide additional diagnostics to troubleshoot slow backup or restore operations.
T-SQL Tuesday #65 : Teach Something New
For T-SQL Tuesday< #65, I give a little detail on something I learned this week about altering a column from NOT NULL to NULL.
T-SQL Tuesday #64 : One Trigger or Many?
I follow up on a question from a triggers presentation at SQLBits, addressing the impact of trigger overhead for T-SQL Tuesday.
T-SQL Tuesday #58 : Giving out the sa password
For T-SQL Tuesday #58, I discuss a few of the reasons people give out the sa password, and what you should do in those cases instead.
T-SQL Tuesday #57 : A SQL _VARIANT Use Case (No Pun Intended)
I use a T-SQL Tuesday theme to demonstrate a use case for the SQL_VARIANT data type that you may not have considered: Conditional ORDER BY.
T-SQL Tuesday #56 : Assumptions
This month's T-SQL Tuesday is about assumptions in SQL Server.
T-SQL Tuesday #36 : Reflections on the PASS Summit and our community
Last week I attended the PASS Summit in Seattle. I blogged from both keynotes (Keynote #1 and Keynote #2), as well as the WIT Luncheon – which SQL Sentry sponsored. I had a fantastic...
T-SQL Tuesday #33 : Trick Shots : Schema Switch-A-Roo
I describe a way to use ALTER SCHEMA … TRANSFER to refresh data with minimal disruption.
T-SQL Tuesday #26 : Second Chances
This month's T-SQL Tuesday is being hosted by Dave Howard (@DaveH0ward), and the topic is "Second Chances." What he's letting us do is look back at all the previous T-SQL Tuesdays and pick a...
T-SQL Tuesday #25 : T-SQL Tips 'n' Tricks
This month's T-SQL Tuesday is being hosted by Allen White (@SQLRunr) and is about sharing your T-SQL tips and tricks. Since I know many people will share their T-SQL magic and wizardry, I thought...
T-SQL Tuesday #24 : Dude, where's the rest of my procedure?
This month's T-SQL Tuesday is being hosted by Brad Schulz (blog) and the topic is one that should attract a lot of submissions: Procedures and Functions. Last week, I talked about the case against...
T-SQL Tuesday #23 : Well, that's a kick in the JOIN…
This month's T-SQL Tuesday is a week early due to the upcoming PASS Summit. It is being hosted by Stuart Ainsworth (blog | @codegumbo) and the topic is a general one: JOINs. I had...
T-SQL Tuesday #21 : Crap Code
Yes, Adam is right: we've all written crap code (the topic of this month's T-SQL Tuesday Wednesday. Usually we have an excuse: tight deadline, short shelf life of the code, or didn't know any...
T-SQL Tuesday #20 : T-SQL Best Practices
T-SQL Tuesday, the invention of Adam Machanic (@AdamMachanic), is what he calls a recurring, revolving blog party. Each month, a new host picks a topic, invites bloggers of all levels to join in, and...
T-SQL Tuesday # 16 : This is not the aggregate you're looking for
This week, T-SQL Tuesday is being hosted by Jes Borland (blog | twitter), and the theme is "Aggregate Functions." When people think of aggregates, they tend to think of MAX(), SUM() and COUNT(). And...
T-SQL Tuesday #15 : Running T-SQL workloads remotely on multiple servers
This month's installment of T-SQL Tuesday is hosted by Pat Wright (blog | twitter). Pat says: "So the topic I have chosen for this month is Automation! It can be Automation with T-SQL or...