Nice question 🙂 I found correct answer wery fast 🙂 Little thinks - and ... bingo!

Interesting question, but when i execute bit modified this script, i receive other error:

declare

@decimal decimal(18,6),

@bit bit,

@float float,

@integer int,

...

vk-kirov (10/19/2011)

---

"The Default group can be moved out of the Default Pool"? The referenced BOL article says just the opposite:

Resource Governor Concepts

---

The default group is alterable but it cannot be...

As known, Microsoft was changed work with tempDB since SQL 2005, so it is possible, that time dimensions in SQL 2000...

Very interesting question 🙂

In my case on SQL 2008 R2 i receive follow result:

- table variable - 29290 ms

- temp table - 240 ms

Good question!!! Thanks!:-)

Good question, but it is true for SQL 2008 and not for SQL 2005!!!

Correct answer should be FALSE, because i received next results:

2009-11-16 10:50:43.533

2009-11-16 10:50:43.533

2009-11-16 08:50:43.533

2009-11-16 08:50:43.533

I'm living in Ukraine and our Timezone = +2 Hours.

Please, accept my answer as correct. Thanks.

Very interesting and good question 🙂

Good and not difficult question. I'm pleased.

Good question, but I think, that cost of this question could be higher