Performance Tuning Exercise: Lazy Table Spool
Folks, it’s time for a bit of a performance tuning exercise. Below is a real world situation where a stored...
2018-07-18
23,354 reads
Is this a SQL Provision Cloned Database?
As I work with SQL Provision, I keep finding new questions and concerns from clients and customers. Recently I had...
2018-07-18
707 reads
Data lakes and swamps, oh my
I was lamenting to my friend and fellow MVP Shamir Charania (blog | Twitter) that I didn’t have a topic for...
2018-08-01 (first published: 2018-07-18)
2,988 reads
Working Hard in Baton Rouge
I’m heading back to Baton Rouge for SQL Saturday #749 this August. This is one of the largest SQL Saturdays...
2018-07-18
423 reads
RESTORE VERIFYONLY what does WITH LOADHISTORY do?
Recently someone mentioned the LOADHISTORY option of RESTORE. It’s not horribly hard to find in BOL but it wasn’t the...
2018-07-31 (first published: 2018-07-18)
3,044 reads
Know How Table Variables Different From Temporary Tables in SQL Server
Know What Table Variables are ?
SQL Server support features that allow users to work with temporary data that gets stored in temporary tables. Microsoft introduced table variables for the...
2018-07-18
37 reads
Know How Table Variables Different From Temporary Tables in SQL Server
Know What Table Variables are ?
SQL Server support features that allow users to work with temporary data that gets stored...
2018-07-18
2,073 reads
Creating SQL images in Azure with ACR Build – Part One
Whenever I’ve pushed images up to an Azure Container Registry I’ve been building them locally (using Docker for Windows) and...
2018-07-18
370 reads
Schedule an Extended Event to run at a Specific Time
When you are using the extended event to capture some data for troubleshooting purpose, you may want to start or...
2018-08-01 (first published: 2018-07-18)
5,361 reads
Power BI Custom Visuals Class (Module 111 – Horizontal Bar Chart)
In this module you will learn how to use the Horizontal Bar Chart. The Horizontal Bar Chart is similar to...
2018-07-24 (first published: 2018-07-17)
2,751 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