I almost chose 42 although I have no idea why. Maybe somewhere lodged in the back of my mind I recalled hearing this bit of sci-fi trivia before... Instead I...

Interesting question. I figured I would get it wrong and that SQL Server would have a strange option to add a file during backup. Doesn't seem like a reasonable thing...

SSMS. I only use SSDT for SSIS and SSAS. I tried doing DB work in SSDT a few times but found it to be too clunky.

Working for Pandora would be interesting. Seeing how their music genome software works and what sort of database(s) are involved with that. The most interesting data I have worked with...

I should have gone with my gut. Was going to answer 4 because of the comment in the code about the one select being the same as the first. But...

Thanks for the question Steve. I use queries like this a lot for this same sort of cleanup.

I've never used SOME either. I would be interested in seeing a real world example where SOME is the best choice to use in a query.

I add line numbers, and I check the "Include column headers when copying or saving the results" option under options--> query results --> sql server. I also register servers and...

Nice question. I've seen some junior developers tripped up by this before.

I tested this out just now and I found it interesting that if you drop the global temp table, the synonym still exists in sys.synonyms. I had to issue a...

I was doing too many things at once and thought I selected the right one before I hit submit. Not a good start to the year. 😀

SQLRNNR (12/18/2014)

---

Iwas Bornready (12/18/2014)

---

I'm confused by the second option, deleting an index whether it is used by the plan or not. If an index was used by the plan, wouldn't...

Nice question Igor! I had no idea as I have never used these UDTs before.

+1 on not knowing which way to guess on this one. I almost chose 4 answers until I saw it said to pick 3. Had flag 2390 not been mentioned...

Great question. I don't use PowerShell at all currently but the more I read up on it, the more I can see uses for it. Knowing that some of the...