+7

Still don`t know much about Hekaton, so learned somthing new 2dya, thanx.

That`s not correct, as SQL 2k8 will work fine with the in-line assignement.

Nice one, thanx.

Gr8 question, very informative, thanx 🙂

Nice tricky question, needs to be read slowly to get it right 🙂

Didn`t have enough information about this, but took a wild guess & I was right 🙂

Well, I am using sp_configure often, but I never included it in a transaction, what is the use of that anyway? 😎

+1 😉

Tricky question, but very nice as well, I was about to choose the (1 row(s) affected) option, but re-read the qusetion slowly, got it right.

Thanx 🙂

paul.knibbs (12/10/2014)

---

Slightly...

+1

TomThomson (12/7/2014)

---

Hany Helmy (12/6/2014)

---

From the explanation: "SQL Server 2008 optimized mixed extent allocation behavior reducing the need for trace flag 1118 and the contention on SGAM(s)."

So I guess there is...

From the explanation: "SQL Server 2008 optimized mixed extent allocation behavior reducing the need for trace flag 1118 and the contention on SGAM(s)."

So I guess there is no need to...

Complicated staff 😉 but @ least learned somthin new 2day, thanx