Keeping a Low Profile
I’ve been mostly offline for the last ten days or so, cutting back on blogging and forum participation and mostly...
2009-09-01
574 reads
The Pain of Multi-Threading!
Alas, this isn’t really a SQL post, but thoughts on efforts to share work that has been previously done by...
2009-08-31
1,452 reads
Backing up to NUL vs Backup with Truncate only
Or “It’s 10pm, do you know where your log records are?”
Something that I’ve started to see recently is the idea...
2009-08-31
2,276 reads
Scripting Server Side Traces
If you’ve never used SQL Server Profiler, you truly don’t know what your missing. And that statement has an intentional...
2009-08-31
1,655 reads
Active August – Final Recap
Well, I had a pretty good week this week. I made an effort and met all my goals:
Eat smaller portions...
2009-08-31
1,330 reads
Submitted PASS Board Of Directors Application
Well after much deliberation I have decided to submit an application for the PASS Board of Directors. I embark on...
2009-08-31
1,424 reads
SQL Lunch Calendar
We have been working hard trying to get speakers to complete the year for our SQL Lunch schedule. I am...
2009-08-31
1,731 reads
Notes On the Jacksonville Code Camp
I drove up to Jacksonville Friday afternoon for the 2009 Jacksonville Code Camp led by my friend Bayer White. I...
2009-08-31
1,658 reads
Decompressing on Compression in SQL Server 2008....
Compression is one of the major features introduced in SQL Server 2008, and one that can significantly reduce disk storage. ...
2009-08-31
9,541 reads
- Easiest Rebuild Ever - Windows 7
I'm somewhat conservative with my machines. These days it's a tool for me, and I'm not looking for the coolest...
2009-08-31
1,678 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