As usual very informative question from Hugo, Thanx 🙂

Thanx Hugo 4 those 2 very useful questions, NoLock=NoDoubt 😉

@ the time of posting this, I was the only 1 who got it right out of 9 attempts 😛

EZ question, sp_*** for system SP`s.

Gr8 question, only the Constraints Violation part I was not sure about, thanx.

GilaMonster (1/9/2014)

---

The first is deprecated, the second is not, both can result in incorrect results, duplicate rows and missing rows, so neither is the best to use. Best is to...

NICE VU 😀

EZ 🙂

Good question, I like it 🙂

Correct, I guessed it right, thanx for the question.

That was ez & clear enough 4 me, thanx 4 the question.

Basic question, but yet very good & useful, thanx Igor.

I was sure of the 1st option, but the 2nd was tricky and even hard to find upon searching.

Never used "FileTable" b4, so learned somthin new 2day, thanx Andy.

Hugo Kornelis (9/30/2015)

---

None of these answers are fully correct. To ensure minimal data loss, one should always start by a tail-log backup. (Which will fail if the log file is...

I am using this a lot lately.