I've been building databases since I started working with PFS File in the 1980's. :w00t:

It seems like there is a literal meaning for NULL, which is "unknown", and a practical...

User defined server roles looks interesting. Thanks for the question Steve.

A minor correction is needed on the reference. It points to fixed server-level roles not user defined and...

Thanks for the question.

Here's an interesting read on the use of VIEW DEFINITION permissions instead of encryption.

Options For Hiding SQL Server Code[/url]

Enjoy!

Nice question Steve!

So far, the most chosen wrong answer is: CHECKINTEGRITY. :hehe:

Which, of course is not a valid DBCC check. :w00t:

Would you like to work in a place where the more talented people rise faster than the average worker, regardless of seniority, friendliness with management, or any other non-skill...

sdhamani1020 (6/13/2013)

---

I tried this option. Apparently the table with CompanyID does not have any related table.

However , the table with revenue id , does bring up lot of related...

This will be pretty hard to answer definitively without having a lot more information about all the tables and fields in the database.

Totally grasping at straws, I'm wondering if the...

Sometimes extra characters are included when copying and pasting code from SSC. You can try pasting the code into something like Notepad first and then copying from Notepad to...

I've been using sp_Blitz for a while and love it! It's an invaluable tool that no DBA should be without.

A minor correction: The article mentions version 16 as...

Nice follow up Hugo. I didn't over-think it today. 😉

A minor typo in the explanation.

ELSE...

Thanks for the excellent question Hugo.

At first I thought the trick was that we don't know if the ValueCol was an integer or varchar data type. I almost over-thought...

Ah, that's more like it. ...

Nice question! I had to guess the correct answer. According to the script below the correct answer may not be so simple.

-- Code from the QotD

select * into...

Thank you so much Lowell and Lynn. I'll give both of these a try and see if there is any difference in the query plan.

Enjoy!

Dave

marcia.j.wilson (3/12/2013)

---

... The other thing that I've run into is the expectation that I will be always available. I've had people call me late at night that wouldn't think...