After taking a few MS Certification exams, I have noticed that many questions tend to ask a question and provide a multiple choice answer that allows more than one answer...

For me, this was a great question. The Microsoft link explains the properties in a concise and understandable way and the meat of what it explains is actually also...

Since I haven't had a chance to try Sql 2008 yet, you gotta wonder sometimes... How much of a DBA's job hinges on the ability to search the internet...

The question brought to light that circumstances exist where the estimated plan and the actual plan can be different. I'd be interested in seeing more topics on how to...

This one threw me. I use CTRL - L constantly for the estimated execution plan and never once tried to run an actual execution plan. There is no...

Ah, can we lobby for points? [Sounds like going to court for a traffic ticket cuz ya know the officer won't be there.] Stupid Interviewer Tricks aside,...

I was afraid to answer this question because it was not worded clearly. In the question the word "new" is in quotation marks. What does "new" mean? ...

The fact that they are created with the view and maintained explains why it is so difficult to manage views with ansi_nulls set to off (and required because they have...

I noticed the link was wrong also. Interesting..., if you set an option on a server and the view does not contain an obligatory option switch, then ansi nulls...

Is there not a difference between publishing a Data Type and aliasing a data type? After reading the article above, I made a choice to not check publish Data...

Could be where you are trying to deploy to. I tried several deployments

localhost/reports

localhost/reporting

finally this one worked

localhost/reportserver

I think it depends on the configuration. I have no trouble is I...

How does one remove the unicode inserted into email so that pasting into the sql browser doesn't double space the code?