Does a Query always wait in the SUSPENDED State?
(Be sure to checkout the FREE SQLpassion Performance Tuning Training Plan - you get a weekly email packed with all the...
2018-06-05
1,043 reads
(Be sure to checkout the FREE SQLpassion Performance Tuning Training Plan - you get a weekly email packed with all the...
2018-06-05
1,043 reads
I know Nashville is most famous for Country music, but in the recent years, it has become home to more...
2018-06-05
293 reads
If you have been reading my last blog posts, you know that I’m currently working on a SQL code migration...
2018-06-05
505 reads
I got the chance to sign up for a few courses from the Brent Ozar Unlimited team and took it....
2018-06-15 (first published: 2018-06-05)
2,949 reads
Problem:
Early in the morning I received emails requesting for support as the applications were failing to connect to one of...
2018-06-18 (first published: 2018-06-05)
4,724 reads
You may (or may not) have a requirement to setup a linked server to Azure SQL Database from a locally...
2018-06-13 (first published: 2018-06-05)
1,869 reads
In a recent post I wrote about a new functionality for Azure SQL Database’s TDE feature: Bring Your Own Key. At the time the only way to bring your...
2018-06-05
32 reads
In a recent post I wrote about a new functionality for Azure SQL Database’s TDE feature: Bring Your Own Key....
2018-06-12 (first published: 2018-06-05)
1,919 reads
Watch this week’s episode on YouTube.
Occasionally you may need to create a lookup table of values for a single query. ...
2018-06-13 (first published: 2018-06-05)
4,389 reads
Watch this week's video on YouTube
Occasionally you may need to create a lookup table of values for a single query. Building a permanent table of these values is a...
2018-06-05
48 reads
The first version of my accounting assistant could not find a single purchase of...
Why isn’t AI paying off yet? Drawing on lessons from digital transformation, Joyful Craftsmen...
By Steve Jones
I’m really excited about some growth in Flyway support. I’ve been asking about this...
Comments posted to this topic are about the item Pay for Performance, which is...
Comments posted to this topic are about the item Too Many Choices
Comments posted to this topic are about the item Table Partitioning in SQL Server:...
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