Activate Conference 2018: Three days of Tech Learning
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
298 reads
Classifying Data with SSMS 17.5
I upgraded SSMS to 17.5 recently and found an interesting addition. This version has incorporated the ability to classify data....
2018-02-20
805 reads
Killing A Service Broker SPID
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,379 reads
OR vs UNION ALL – Is One Better For Performance?
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
219 reads
OR vs UNION ALL - Is One Better For Performance?
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
30 reads
Capture SQL Server Reported Errors using Extended Events
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,251 reads
Getting started with the SQLUndercover Inspector
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
384 reads
Summary of my Partitioning Series
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
471 reads
SQL Saturday Chicago: I’m speaking
If you’re in Chicago on March 17 and have some free time, why not check out all the cool kids?...
2018-02-19
260 reads
STORPORT: Reading an ETL trace
One of the things I enjoy most is diagnosing storage latency. I honestly couldn’t tell you why I enjoy it...
2018-03-05 (first published: 2018-02-19)
3,726 reads
Blogs
Are Blogs Still Relevant? I Think They Still Are.
As for me, I'll keep writing whenever time permits. I don't expect every post...
Reading Blogs: T-SQL Tuesday #204
By Steve Jones
This is an interesting invitation this month. Jeff Ianucci is a new host, and...
Are Blogs Still Relevant? - T-SQL Tuesday #204
By alevyinroc
T-SQL Tuesday is a monthly blog party hosted by a different community member each...
Forums
Pay for Performance
Comments posted to this topic are about the item Pay for Performance, which is...
Slow - Linked server query
Hi I have this slow query that is pulling data from a linked server....
Too Many Choices
Comments posted to this topic are about the item Too Many Choices
Question of the Day
Too Many Choices
I have a table, dbo.MasterBrands, with this data:
BrandID OfficialName 1 Samsung 2 Apple 3 Microsoft 4 Adidas 5 Coca-ColaI run this query. What is returned for Coca-Cola?
SELECT CHOOSE(BrandID, 'Conglomerate', 'Tech and Design', 'Desktop', 'Apparel') FROM dbo.MasterBrands;See possible answers