Though the missing quote mark (which is most probably a typo); the question iteself is good, didn`t know that LEN fn doesn`t work with text data type (which I am...

Very good question, thank u 🙂

Good question, and good example of using rollback within a transaction.

Thanx.

TomThomson (11/28/2014)

---

Easy question.

Correct answer, but utterly useless references. The first doesn't even mention maintenance plans. The second says they can't be used to do bakups for a database...

Good question, guessed it right, thanks.

Good to know, nice question & explanation.

This question reminds me of the 70-461 exam questions 🙂

SQLRNNR (11/23/2014)

---

While a decent question about an analytic function in SQL Server, I am not enthused by the terminology used in reference to the table variable.

Table variables are not "memory...

TomThomson (11/22/2014)

---

h.tobisch (11/21/2014)

---

Just understood:

a nonclustered index may be the same size but never larger than a clustered index, so, if it covers the data the nonclustered index will be first...

Toreador (11/21/2014)

---

It was possible to work this out by elimination - either both or neither of 4 and 5 had to be there, which ruled out all but 1 and...

Koen Verbeeck (11/21/2014)

---

Nice question, not so great explanation.

Still wonder why number 1 is not a clustered index scan.

Does SQL Server always prefer a covering nonclustered index over a clustered index?

(still...

Igor Micev (11/19/2014)

---

serg-52 (11/19/2014)

---

Thanks, good question.

I was not sure but rather had an impression that sending parameter of the UDT declared in the current DB to the proc in the...

doug.davidson (11/18/2014)

---

Still trying figure out what the point of this feature is suppose to help with.

After some reading it appears to be a quick short cut to update stats for...

Ok, good to know that, thanx.

Definitely lerned somthing new, gr8 question, thanx.