Compat Level - 10.. but databases were written in 8 or 9 - but you'll have to wait if you want an example... snowed here today and they shut us...

Something else is a bit disturbing here... the datetime2 is often a default time now for getdate() (or seems to be) and it can be problematic in databases created prior...

Adi,

I too am ait put off by that assumption. Maybe the question should be tossed.

J

Can't quite understand why I should expect it to fail unless I had never understood DateTime2 in the first place. I expected it to work and it did.

Sure...

Correct. It is fairly common for someone to advise me to add shrink to my plan but it seems to me unnecessary and what I've read indicates I'm right....

I like it as is. There are purposes for shrinking. It is easy to do. It is a well-known fact that shrinking a database hurts...

It's nice that we not only learn but get credit at the same time.

Strange... backing up files in Diff format... never knew.

My discovery was as follows:

When you try to process a dimension that has been created (before you try to create a cube), the data sources and data source views will...

All I can say is WOW. Neat one!

Good question... had to look this one up. Had no idea option existed.

My eyes stumbled over this several times... "inside groups"... maybe if the questions had been ordered a bit differently it would be easier to figure out which answer is correct.

Agreed - Hugo, great question. I'm fascinated with the way the round works in SQL.

Ditto... good question. Sql rounding is confusing when you have been trained to add .5 to an integer to round - as it doesn't work that way. ...

Good to hear someone put what I felt here...