Fortunately, there are often free products that are only slightly less effective than their paid counterparts. For example, if your employer won't pay for SQL Prompt, you can always...

Being an avid fisherman, I've always thought there would be great value in a site where you could share fishing results and in return, receive other people's results. If...

It's looking like most here have never used this, me included. Does anyone have any real world examples?

We're on 2008 R2 Enterprise at my shop and we've cancelled plans to upgrade to 2012 because of the costs. Once Microsoft stops supporting 2008 R2 I believe we'll...

Cool stuff. In my last job I had to set this kind of stuff up using VBA or a bunch of formulas behind the scenes. Good to know...

Wow, I didn't understand synonyms to be so abstract. Thanks for the question!

I'm getting to this one a day late, but as written it now returns NULL:

DECLARE @OUTPUT VARCHAR(max);

SELECT @Output = @Output + SPECIFIC_SCHEMA + '.' + SPECIFIC_NAME + Char(13) + Char(10)

...

Fun little story, reminds me of The Grinch Who Stole Christmas, for some reason.

Thanks for sharing.

This should probably say "Dropping an index on the table that is not used by...

So as it is currently written, is the query actually doing this?:

SELECT s.*

FROM dbo.Stocks s

WHERE s.id IN ( SELECT s.id

...

Thanks for sharing! I think this article does a good job of showing how similar DBAs and detectives are. It takes a lot of investigation, critical thinking, and...

Wow, I've never had to do bitwise operations. I totally interpreted that as a math problem (one to the one hundredth power).

Thanks for the question!

I also thought select #1 would use a clustered index scan. Interesting that it doesn't. I have tested this out on a DBA table that captures CPU utilization...

Fun questions, thank you.

Good question, learned something new.

Thank you