Struggling with C#
I taught myself programming with Quick Basic (started with Turbo Basic but couldn’t find a book on it, so bought...
2009-09-09
378 reads
Spools in Execution Plans
I got the question the other day, when are you likely to see a spool in an execution plan? Easy,...
2009-09-09
2,873 reads
Some 24 Hours of PASS Sessions Can Now be Viewed Online
If you missed out on some of the 24 free, live sessions that made up the 24 Hours of PASS,...
2009-09-09
496 reads
Speaking at Space Coast User Group
I have the privilege of presenting, Dive into the Default Trace, at the Space Coast User Group, tomorrow evening (Sept....
2009-09-09
313 reads
Be Careful of Facebook
Even the President thinks so! In his talk yesterday, he warned kids about Facebook, and being careful what they should...
2009-09-09
1,078 reads
Great Post on Clearing all data from your Data Warehouse
Hey there Gang !
Most of you probably know Jamie Thompson has move his blog over to SQLBlog.com. This is worth noting...
2009-09-09
430 reads
SQL Server 7.0 – Transaction Log Not Backing Up
I have not worked with SQL Server 7.0 in a loooong time. So when I received a call from a...
2009-09-09
2,025 reads
Books You Should Own
Have you ever wondered where to go to get good information that will help you in your day to day...
2009-09-09
500 reads
Writing a Technical Article – Where to Publish
This is part three of a series on writing a technical article. The advice might apply to non-technical articles, but...
2009-09-09
3,640 reads
PASS Connector Editorial for Sep 9, 2009
I currently write the editorial for the PASS Connector which is published every two weeks as part of my role...
2009-09-08
720 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