Curb those Cursors !
With query performance becoming a constant battle, its often a forgotten fact that cursors should be avoided (in the majority...
2010-07-15
698 reads
With query performance becoming a constant battle, its often a forgotten fact that cursors should be avoided (in the majority...
2010-07-15
698 reads
My first guest editorial published !
http://www.sqlservercentral.com/articles/Editorial/70725/
Would appreciate any comments you have.
2010-07-15
580 reads
We are trying to buy another property here at the ranch. My wife had to leave town in the middle...
2010-07-15
749 reads
Download Script
Sorry that it’s taken me so long to write this post, but I have been a little busy with...
2010-07-15
704 reads
I went through the exercise months ago where I tried to re-organize my blog reading to be more efficient at...
2010-07-15
843 reads
I’ve had variations of this conversation a couple of times lately and thought it was worth writing down some thoughts....
2010-07-15
520 reads
I think this is a good idea, and I’ll give you some reasons, but every SQL Saturday ought to consider...
2010-07-15
979 reads
This is the review of the second chapter of the book Defensive Database Programming. The title of this chapter is...
2010-07-15
1,832 reads
April of 2009 I decided it was time to blog about my SQL Server experiences in earnest. Steve Jones (twitter|blog)...
2010-07-14
540 reads
The script below is a simple and quick way to find out the last backup performed successfully to the databases...
2010-07-14
784 reads
By Rayis Imayev
"I've seen things you people wouldn't believe..."— Roy Batty, Nexus-6 Replicant, Blade Runner (1982)(2026-Nov-08) Yep,...
By Steve Jones
We’ve celebrated our birthday many times at Redgate. In the Book of Redgate –...
Discover how Palantir connects enterprise data, supports AI-driven decision-making and helps companies turn insights...
Comments posted to this topic are about the item Pay for Performance, which is...
WhatsApp:0817819444 Jl. Mangunsarkoro No.24, Pamoyanan, Kec. Cianjur, Kabupaten Cianjur, Jawa Barat 43211
WhatsApp:0817819444 Jl. HOS Cokro Aminoto No.56-58, Muka, Kec. Cianjur, Kabupaten Cianjur, Jawa Barat 43215
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