SQLRNNR (6/5/2014)

---

Grant Fritchey (6/5/2014)

---

Please, please, please, bestester behavior, no piling on of any kind (or I'll delete the posts and I can do that, BWA-HA-HA-HA, THE POWER!, ahem, where was...

Message deleted - how this website converts "backspace" into "send" is beyond me, and I didn't mean to send this as it was much too mild. A less mild...

thomashohner (6/4/2014)

---

Great thread gentlemen this helps a new guy like myself out. Knowing what irritates the more experienced guys/gals will help alot.:blush:

I will say its crazy some of the stuff...

Lynn Pettis (6/3/2014)

---

TomThomson (6/3/2014)

---

patrickmcginnis59 10839 (6/3/2014)

---

Rudyx - the Doctor (6/3/2014)

---

A great list discussion - my 3 cents:

- table variables need to be depracated with extreme prejudice

- SSMS generated...

Khmer

patrickmcginnis59 10839 (6/3/2014)

---

"Best practices" is pretty much a key phrase that helps gather recommendations...

patrickmcginnis59 10839 (6/3/2014)

---

Rudyx - the Doctor (6/3/2014)

---

A great list discussion - my 3 cents:

- table variables need to be depracated with extreme prejudice

- SSMS generated code (IMAX screen...

When I saw this, I found myself wondering if this were the documentation bug again or not? It could be a trick question, where the "correct" answer was the...

crmitchell (5/30/2014)

---

Strictly speaking f6 isn't a toggle

It will cycle through all open panes not just those two and if you don't have the results pane visible it won't show it.

You...

If you have no schema-bound objects which depend on the database default collation you could alter the database collation using ALTER DATABASE and then alter the column collatins for each...

The idea that the RAID5 (or RAID6) performance disadvantage disappears because of the buffering is a bit careless, as it doesn't consider recovery times when a disc goes down -...

palesius 61659 (5/29/2014)

---

The spinning never stops 🙂

So when the seek part is done, it will have to complete half a rotation on average for the correct part of the disc...

I agree with a lot of what's been said, but I don't much care whether commas are leading or trailing.

Some extra hates are

code layout that forces frequent...

Interesting question, I learned something new from this one. Quite good mental exercise, as there's no useful documentation that I could find and I'd never used this function.

Some...

Well, Jeff has braved it but didn't comment on the normalisation bit of the...