Shipping
I've got a conference to attend in a few weeks, and needed to get some things out the door. Every...
2009-10-16
636 reads
Table Variable and Temp Table
Today I come across the great blog by Wayne Sheffield on Sqlservercentral.com about temp table and table variable so I...
2009-10-16
587 reads
PASS Board of Directors Debate - Transparency and Vision
There is an amazing debate occurring on Brent Ozar's blog where he interviewed Matt Morollo. Being a little out of...
2009-10-16
1,381 reads
Vetting the PASS Board of Directors candidates
I've had a pretty heavy involvement in Brent Ozar's interview of Matt Morollo. The reason for my intense activity is he was...
2009-10-16
1,363 reads
SQLSaturday #21 Shirt Snafu!
Thought I’d share a funny story. Way back before SQLSaturday #1 my friend Shawn recommended a local shirt/embroidery vendor, I...
2009-10-16
499 reads
Free E-Book on XSD SQL Server Schema Collections
Whether you like it or not, as a SQL Server DBA or Developer, you will eventually have to learn about...
2009-10-16
565 reads
Dev Days
I heard about the Stackoverflow Dev Days earlier this year and thought it was an interesting idea. We had talked...
2009-10-16
1,163 reads
Backing Up Your Data is Obvious, Or Isn’t It?
Often, when I give presentations on DBA best practices, I make the obvious point that databases need to be regularly...
2009-10-16
494 reads
Book Review: The Deceived
The Deceived by Brett Battles
I haven’t post on any fiction lately, thought it was time to write about something more...
2009-10-15
355 reads
SQLSaturday #21 Is Tomorrow (Oct 17)
I’m writing this in advance because I’ll be busy with all the last minute preparations, but I’m looking forward to...
2009-10-15
291 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