Nevermind.. found it under Products and books. The categories were collapsed for me plus I didn't scroll down the mile to see it. Please remove or delete this...

I just didn't see any good central place for General SQL Administration or for discussions on SQL tools

Thanks

Steve

Great question... got this one wrong but that's how we learn!

Learned something today... Good question and keep them coming.

Fresh installs of SQL 2008 Developer and Standard have the model database set to Full.

I was all smug in the fact that I realized NVarchar would be less efficient than Varchar in this instance and checked varchar. As I sipped my coffee...

What about SQL 2008? Is this an option there?

Fair point Bitbucket and I agree with you about everyone now knowing about the changes to Cube and Rollup. I do disagree with your end line of:

"If everything seems...

I would have to think the question if faulty in some way when close to 85% of the people answering it are getting it wrong.. IN my time here this...

This one tripped me up as well. Checking http://msdn.microsoft.com/en-us/library/ms187366.aspx it does say :

"Returns the value of the current timestamp data type for the current database. This timestamp...

That's a question from the future! Are we sure on Dec 3rd the answer will be the same? 🙂

Kind of like those DOTS (Ice cream of the future!)

Sorry I am jumping on this one late... I replaced the BOOL data type with Char and received the correct answer which was 4. That is the only one...

Great question and I got it wrong. Made me do some research and found that it is indeed a system View. Keep these great questions coming as...

At both companies I have worked for, its always been the motto if you work extra/off hours, you will get time off another time. Either leaving a half day...

I agree with Scott, in the SQL 2005 docu it shows nothing about 823

http://msdn.microsoft.com/en-us/library/ms191301(SQL.90).aspx

Poorly written question but great information!