Hi, Ramya,

nice work! Very detailed, very interesting!

Only thing that irritated me in terms of processes: We'd have a single point of failure in the external table; at least the assigned...

• This reply was modified 4 years, 4 months ago by  Dscheypie. Reason: Removed [code] tags

Hi, Lowell,

great work, thank you! I added your procedure to my toolbox; just renamed it to GetTableDDL because I have a simple SP called GetObjectDDL for stored procs, functions etc....

I like your post: Each command has it's right to exist, and WE have to decide the appropriate use.

Your compilation of criteria is a nice catalogue for a discussion when...

Hi, tromeo,

that was an interesting article for me: Up to now I did not know anything about the abbreviations "CI" and "AS". Of course I did not have too many...

It definitely is too expensive to save money by not unit testing software. The same goes for documentation.

Especially for newbies that work themselves into it: If they have documentation AND...

Hi, Jefferson,

thank you for your article. You put some work in it, and this is something I really appreciate!

Personally I was mislead because based on the headline I expected an...

Ah, hi Tom!

Thanks for your valuable remarks and your work!

See you later...

Jens-Pater...

ronmoses (10/31/2013)

---

sknox (10/31/2013)

---

The following T-SQL code creates database users which map to the Windows groups. Every member of those groups, when logging into SQL Server, will have the rights of...

Of course you are right: Never change things in the last minute. I...

Nice idea, this question!

SQL Server writes only changed data pages, not variables. That concept in mind forbids any other answer, doesn't it?

L' Eomot Inversé (10/3/2013)

---

Nice question.

I find it quite surprising that 58% of answers so far were wrong; and even more surprising that nearly half of the wrong answers were not...

Jeff Moden (10/1/2013)

---

Actually, this is going to cause a mess for me when we upgrade from 2005 because NULL is considered to be a DISTINCT value. For 2005, the...

Yes, that's correct. A better answer could have been "... is actually planned to be implemented in SQL Server 2014 ..."

Jens-Peter 🙂

MarkusB (10/1/2013)

---

Not sure about this question.

I think there is no correct answer given, because even the link provided for SQL 2014 says "Topic Status: Some information in this topic...

@braindonor: Good of you to mention that, thanx.

But hopefully the book's a bit more. At least he wrote about some exercises in the book!

Jens-Peter