2017 Year in Review for SQLDusty.com
2017 was an awesome year for SQLDusty.com! Thank you to all of the readers and visitors that stopped by to...
2018-01-29
413 reads
2017 was an awesome year for SQLDusty.com! Thank you to all of the readers and visitors that stopped by to...
2018-01-29
413 reads
[read this post on Mr. Fox SQL blog] Recently I had a requirement to collate and briefly compare some of the various methods to perform SQL Server backup for...
2018-01-28
31 reads
[read this post on Mr. Fox SQL blog]
Recently I had a requirement to collate and briefly compare some of the...
2018-01-28
1,143 reads
Over the last several weeks, we have been making several changes to various settings in SSMS. Now that you have...
2018-01-28
403 reads
Houston, We Have a Problem
We are living in a crazy world. And it just gets more and more crazy all...
2018-01-28
883 reads
When you are performance tuning code, you will frequently examine the execution plans to see what is happening. As you...
2018-01-27
471 reads
Earlier this week the folks at PASS reached out to last year’s speakers asking us to share a story of...
2018-01-27
144 reads
I’m proud to announce that I will be speaking at PowerShell + DevOps Global Summit 2018 on the conference runs from April 9th 2018 through April 12th 2018. This is...
2018-01-27
10 reads
I’m proud to announce that I will be speaking at PowerShell + DevOps Global Summit 2018 on the conference runs from April...
2018-01-27
350 reads
I really like the dbatools project. This is a series of PowerShell cmdlets that are built by the community and...
2018-01-26
771 reads
As for me, I'll keep writing whenever time permits. I don't expect every post...
By Steve Jones
This is an interesting invitation this month. Jeff Ianucci is a new host, and...
By alevyinroc
T-SQL Tuesday is a monthly blog party hosted by a different community member each...
Comments posted to this topic are about the item Pay for Performance, which is...
Hi I have this slow query that is pulling data from a linked server....
Comments posted to this topic are about the item 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