Jack Corbett (8/11/2015)

---

Sean Lange (8/11/2015)

---

OMG. I just ran across this in a database from a 3rd party. There are actually 50 nvarchar(1) columns with names 1 - 50....

Sean Lange (8/11/2015)

---

Alvin Ramard (8/11/2015)

---

Sean Lange (8/11/2015)

---

OMG. I just ran across this in a database from a 3rd party. There are actually 50 nvarchar(1) columns with names 1 - 50....

Nice question, but it's a pity about the incorrect statement about only adding chunks less than 8000 bytes in the explanation.

acceleration

reflective

To me your actual data example and the query and its performance seem to indicate that you need to cluster on the natural key; or, pehaps more precisely, that you...

It's rather a nice interesting question, and I hope it will lead to some debate about performance measurement and sizing for OLTP systems and its implications for schema design.

I suspect...

jghali (8/5/2015)

---

I've been an SQL Server dba/Developper for over 20 years but never had to deal with security like here... all previous jobs had SQL Server secured and only DBAs...

That's crul and unusual punishment; anything involving a gusano (whether rojo or any other...

That's a terribly slow timetable; it should be done...

Jeff Moden (8/3/2015)

---

Heh... ironically, I absolutely agree with the idea of writing SQLCLR for file handling, etc. Equally ironic is the amount of FUD concerning such CLR endeavors and...

Ed Wagner (8/3/2015)

---

I agree with you, but I can't resist, Sean. Here's my question:

2 + 2 = 4

Joe has 8 apples and his train is running 17 minutes late.

Bob...

SQLRNNR (8/4/2015)

---

Revenant (8/4/2015)

---

Ed Wagner (8/4/2015)

---

bcsims 90437 (8/4/2015)

---

whereisSQL? (8/4/2015)

---

Ed Wagner (8/4/2015)

---

DonlSimpson (8/4/2015)

---

Eirikur Eiriksson (8/4/2015)

---

Ed Wagner (8/4/2015)

---

SQLRNNR (8/4/2015)

---

Revenant (8/4/2015)

---

Ed Wagner (8/4/2015)

---

bcsims 90437 (8/4/2015)

---

whereisSQL? (8/4/2015)

---

y...

Anyone who says "this is the most badly put together question I've seen for a long time" has clearly not looked at many Questions of the Day, and the same...

When I first saw this (it was published a day or two early, as Monday questions often are) I looked for NAME and OLDNAME and picked the only one with...