Jeff Moden (7/9/2014)

---

sqldriver (7/7/2014)

---

Jeff Moden (7/7/2014)

---

Luis Cazares (7/7/2014)

---

david.holley (7/7/2014)

---

Jeff Moden (7/7/2014)

---

jfogel (7/7/2014)

---

Great, just great. A year ago I wrote something that has to break down a CSV-style parameter string and...

It's been happening the last couple days. I'll not be able to expand the table or programmability nodes in object explorer, getting an error.

The output that I posted is from...

Gazareth (7/9/2014)

---

sqldriver (7/7/2014)

---

Actually, that's pretty helpful, since I at least have a better idea of where to focus my time now.

Especially when I open up a 3000 line stored...

Man, I wanted that free month of PluralSight from the 24 hour wait stats blog post, but my boss was terrified it wouldn't be anonymous.

:Whistling:

I would feel genuinely terrible dropping what I have to deal with on unpaid volunteers. The little things that I get stuck on, sure. But it's my responsibility overall. I...

Jeff Moden (7/7/2014)

---

Luis Cazares (7/7/2014)

---

david.holley (7/7/2014)

---

Jeff Moden (7/7/2014)

---

jfogel (7/7/2014)

---

Great, just great. A year ago I wrote something that has to break down a CSV-style parameter string and it uses a...

Actually, that's pretty helpful, since I at least have a better idea of where to focus my time now.

Especially when I open up a 3000 line stored procedure, hit...

cbrammer1219 (7/7/2014)

---

wBob (7/3/2014)

---

The main problem with this proc is that you reference the CTE twice. SQL Server will process that twice because CTEs behave like views rather than temp...

TheSQLGuru (7/5/2014)

---

If I added everything I wanted to my Common TSQL Mistakes talk it would be about 327 hours long!! 🙂 Actually I did give the talk on a...

TheSQLGuru (7/1/2014)

---

create index ix_Split_1 on #Split_1 (NewParameter)

Good call on the joining to a split-built derived table and how putting that into a temp table could make things faster. However,...

The days everyone else gets off 🙂

Hi Eirikur,

You were half right, but it was right enough to get things working. The versions and paths both matched, but for some reason SSMS would run directly from the...

This was in the same query where someone had a non-clustered index on a bit column with "_V2" in the name, I guess insinuating that there was a "_V1" which...

Tough crowd. I thought the NOLOCK on an update was amusing.

Nothing, just obfuscating actual code.