I would love to see Parkour happen here.

I have found that actually leaving the building and getting outside for a walk is the best way to clear my mind without being away for too long. We have...

Initially I was going to answer that the Exists clause would return more cost effectively just because I know that in certain situations it does behave better. However, not knowing...

This is where my lack of experience with SQL 2008 bites me again. I too thought the question was referencing table variables. Good question, I learned something new!

Doh! I read the question too fast and answered incorrectly. Good QOTD.

I would guess this was 3 points because the site admins expected everyone to get it wrong unless you took the time to translate your local time into UTC time....

Joel, you are correct, Visual Studio is all that you need to set up CLR functions. I would agree however that understanding what the assembly is doing and being able...

I know a lot of people with Masters degrees who are out of work right now and I have worked alongside people with PHd's, MBA's and bachelors degrees all doing...

You never know what the future will hold so I think it pays to be diligent in advancing your own skills even if you can't put them into practice at...

Is there a DB setting that we need to set in order to execute this code? I cannot get it to run even if I remove the CREATE PROCEDURE statement...

I agree with the others as well. I think the wording of this question was misleading as CUBE and ROLLUP both existed as keywords previously just not in the same...

I am guessing you would use it if you had some sort of program code or oddly formatted text inserted into a table and each string started with either []...

At the companies I have worked for, overtime has always been expected as necessary. Comp time has always been unnofficial and something that has been worked out with my bosses....

It would be great to see a site set up specifically for the purpose of showing how database security measures work. The only downside is that junior hackers could sign...

I agree that it shouldn't be necessary but unfortunately a great number of the idiots are the ones managing the budgets and making the final calls. SOX has forced alot...