BWFC (1/17/2014)

---

Ed Wagner (1/16/2014)

---

SQLRNNR (1/16/2014)

---

JAZZ Master (1/16/2014)

---

Revenant (1/16/2014)

---

naked (as in 'We Scots...

Thanks for a simple question to end the week and have a good weekend.

I ran some similar comparisons, but I had run them up to handle varchar(8000) and ran against a million-row test table with the strings filled to capacity. They were...

SQLRNNR (1/16/2014)

---

JAZZ Master (1/16/2014)

---

Revenant (1/16/2014)

---

naked (as in 'We Scots like two things...

Luis, your function is much simpler than mine was working out to be. I was working on creating a derivative on the DelimitedSplit8K function and was most of the...

You have definitely peaked my interest with this one. I've been playing with adapting Jeff Moden's DelimitedSplit8K function covered in the article at http://www.sqlservercentral.com/articles/Tally+Table/72993, but I don't have your...

Coke

Fix (as in make efficient)

Steve Jones - SSC Editor (1/15/2014)

---

Ed Wagner (1/15/2014)

---

Steve Jones - SSC Editor (1/15/2014)

---

WayneS (1/15/2014)

---

Steve Jones - SSC Editor (1/13/2014)

---

I'm hoping to get back to SQLBits this year, but with surgery...

Code

marcjason (1/15/2014)

---

certainly. I want to start simple so I'll start with multiple stored procs each one with a select query in. In reality I'll probably make it more complicated as...

Steve Jones - SSC Editor (1/15/2014)

---

WayneS (1/15/2014)

---

Steve Jones - SSC Editor (1/13/2014)

---

I'm hoping to get back to SQLBits this year, but with surgery coming, timing will matter. I hope they...

That was an excellent question; thank you for it. Query hints...you'd better know what you're doing. Most times it's better to let the optimizer do what it does...

I attended a Azure seminar just last week and the presenter said "there are strategies for backing up your databases" when he was asked about it. I asked if...

fun (the easy stuff isn't as rewarding :-P)