Thank you for the study guide.

I'm planning to have the 70-450 exam until the end of the year and I appreciate all the help I can get.

There are a lot...

I'd like to see an example on when to use that.

But the thing is, a function is allowed to output a non-deterministic result. It just doesn't support temporary tables which...

Hmm... there's nothing on the referenced link that shows that behaviour of LOGINPROPERTY. Perhaps a better explanation?

Well, thanks for the question anyway, Steve. 🙂

Best regards,

I can't understand why the correct answer isn't UDP 1434 even after reading the BOL reference which had me more confused than before. :ermm:

I will read all posts before this...

SQL Server has so many "Do-This-only-after-you-do-that-first" and "You-can't-do-that-even-if-you-think-it's-logically-possible" issues that it would take 99999999 QotDs. 😛

But it's still one of the best DBMSs around.

Thank you for this question. Learned something...

I got it right because I have seen this exact question before. Back then I haven't answered it correctly.

I see how that can be problematic with large backups.

Thanks for the...

Simply brilliant!

Thank you for sharing such a great article.

Looking forward to the other parts.

Best regards,

Thank you for this little question.

I was almost skipping the SELECT...UNION parts...

Fortunately I got it right.

Great QotD for a monday morning. 😀

Best regards,

pnewhart (7/7/2011)

---

That blog post states that delete cannot be rolled back. This is inaccurate. Both truncate and...

It's really nice that they improve BOL with each new version.

The 2008 version looks way clearer IMHO.

I'm often very impressed by the MS SQL Server team.

I don't know if I...

Chad Downey (7/6/2011)

---

Got this wrong but... found in BOL 2005 the following remarks.

Updates information about the distribution of key values for one or more statistics groups (collections) in...

I've got it right. Yay! 😀

Easy to read and not too long to confuse.

The first two answers had me thinking for a while though but "query statistics" is supposed to...

Hi.

Thank you for the long explanations in the article. Much appreciated. A lot of information in a single post.

Two notes I'd like to make to help improve the article:

1) You...

Amazing read. Thanks for the contribution.

Eagerly looking forward to the next chapters (levels).

Best regards,

I learned something. Thank you. 🙂

Best regards,