Danny Ocean (9/10/2013)

---

Just because of "Steppenwolf" having length 11. So insert...

Don`t worry; this question is exception! 🙂

The answer is definitely wrong! I ran the exact same query on SQL Server 2008 R2 & I got the same error everyone got:

Msg 8152, Level 16, State 14, Line...

L' Eomot Inversé (9/4/2013)

---

Excellent question, correct answer and explanation. This is something where people can easily go wrong, as some of the MS documentation is a bit confused.

Hany Helmy...

martin.whitton (9/4/2013)

---

For the clearest possible confirmation of this answer, see http://support.microsoft.com/kb/967576 which states:

SQL Server maintains the Atomicity, Consistency, Isolation and Durability (ACID) property by using the Write-Ahead Logging (WAL) protocol....

I have to disagree with this answer as per MSDN:

"Transactions Durable: After the database engine acknowledges that a transaction has been committed, its changes are persistent in the database"; so...

Maybe this is the easiest question ever in SSC; thanx Steve 😀

raulggonzalez (8/28/2013)

---

Thanks for the question, it made me scratch my head 🙂

The answers are worded as in BOL, anyway just trying to match the definition with the RANKING functions was...

Complicated question! :w00t:

Good to know some new info; 😉

hany.helmy (8/14/2013)

---

kaspencer (8/14/2013)

---

I have worked with SQL Server on and off for many years, but I don't think I recall ever seeing "ORDER BY [number]" as it appears in this...

kaspencer (8/14/2013)

---

I have worked with SQL Server on and off for many years, but I don't think I recall ever seeing "ORDER BY [number]" as it appears in this question.

Could...

Thanx 4 the easy question 🙂

Good to know some new info. 😉

Steve Jones - SSC Editor (7/15/2013)

---

hany.helmy (7/14/2013)

---

In the explanation it was mentioned the following: "The DEK is inside the backup", to be honest I am not an expert of (Transparent...