Tomorrow I'll be giving two workshops at the super-slick-brandedActivate Conference 2018 in Baton Rouge at the Louisiana Technology Park, a...

2018-02-21

291 reads

Classifying Data with SSMS 17.5

by Steve Jones

SQLServerCentral Blogs

I upgraded SSMS to 17.5 recently and found an interesting addition. This version has incorporated the ability to classify data....

2018-02-20

798 reads

Killing A Service Broker SPID

by MarlonRibunal

Marlon Ribunal - SQL, Code, Coffee, etc.

Killing a SPID shouldn’t be complicated. Execute the command KILL [SPID] and that should kill the session. But there are situations...

2018-03-06 (first published: 2018-02-20)

6,320 reads

OR vs UNION ALL – Is One Better For Performance?

by Bert Wagner

Bert Wagner

Today I want to show you a trick that could make your queries run faster.
It won’t always work, but when...

2018-02-20

210 reads

OR vs UNION ALL - Is One Better For Performance?

by Bert Wagner

Bert Wagner

Today I want to show you a trick that could make your queries run faster.
It won't always work, but when it does everyone will be impressed with your performance...

2018-02-20

9 reads

Capture SQL Server Reported Errors using Extended Events

by Dharmendra Keshari

SQL Geek

In my introduction to Extended Events blog, I mentioned that the xEvent is my favorite toy for performance troubleshooting. This blog may...

2018-03-05 (first published: 2018-02-20)

11,141 reads

Getting started with the SQLUndercover Inspector

by davidfowler-42596

SQL Undercover

Here is a quick guide to getting started with the SQLUndercover Inspector.
Pre-requisites:
SQL 2012 or higherSQL Server AgentA database to store...

2018-02-19

370 reads

Summary of my Partitioning Series

by Andrew Pruski

The DBA Who Came In From The Cold

Partitioning Basics – Part 1 – Creating Partitions
Partitioning Basics – Part 2 – Splitting/Merging Partitions
Partitioning Basics – Part 3 – Switching Data
Partitioning and filegroup restores
Update to...

2018-02-19

465 reads