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

I heard through the grapevine that for some of those big retailers that got hacked, it was actually third party vendors that created the security loophole. Either way as...

Markus (9/26/2014)

---

Pricing... yea... Microsoft is starting to think they are Oracle.... soon they will be pricing themselves out of the small applications space. There are starting to be a...

Primarily it's a cost factor for us. 2008 R2 fills all our needs, so we'd see very little ROI with an upgrade to a newer version.

Nice question, I learned something. I assumed the ISNULL function would make it non-Sargable.

1% have gotten it correct? Clearly too complex for QotD. It would have been helpful know the number of correct answers to choose.

Gary Varga (8/1/2014)

---

This editorial highlights a key reason why I believe in using stored procedures. All I want from a stored procedure is to answer some question (no, not query)...

Would there be any security concerns with allowing remote admin connections? Seems like it would be ok as long as you have your sysadmin logins controlled appropriately.