Gail Wanabee (5/17/2015)

---

I've worked in shops where formal documentation was required for all code and it had to be maintained.

I've worked in shops where developers insisted that the best...

Jeff Moden (5/14/2015)

---

I have to strongly disagree with that if it's done correctly. The next...

Yet Another DBA (5/14/2015)

---

The only issue I have documentation is that a piece of paper doesn't know what the code does. I have run into documentation, schedules, in-line comments all...

Notes Scribbled on paper <> Novel

Code Comments <> Documentation

Just in case that was not clear to everyone already.

jacksonandrew321 (2/2/2015)

---

GilaMonster (2/2/2015)

---

Since that post is a...

fellmeth (1/19/2011)

---

Thanks, Grasshopper. I'd forgotten about this post. I'll keep your solution in mind for the future. What I discovered a few weeks ago was that we'd been copying existing...

Eric M Russell (4/27/2015)

---

PHYData DBA (4/27/2015)

---

We would be running anything after 2008R2...

We would be running anything after 2008R2 if any of our vendors...

Felt weird pointing that out, but I know you wanted to see it.

The article itself is very good at covering...

Steve Jones - SSC Editor (4/27/2015)

---

Just a joke...

Not only does is this bad for society in general, but it also affects...

Only simple comparisons work.

NOT + <any operator> ...

Hugo Kornelis (4/21/2015)

---

PHYData DBA (4/21/2015)

---

This is a lot of words that mean nothing, explain less, and contradict some of your other words.

Did you read through all the posts here?

Did...

Hugo Kornelis (4/21/2015)

---

PHYData DBA (4/21/2015)

---

Hugo Kornelis (4/21/2015)

---

So I compare various ways of using ROW_NUMBER to run the while loop versus using IDENTITY to run the while loop.

quote]

As I said... Of...

Hugo Kornelis (4/21/2015)

---

Ed Wagner (4/21/2015)

---

What if your code ran too fast and you wanted to slow it down? Between the pivot and the rcte, that should do the trick....