Thanks for the question, good to explore some of the newer features.

Thanks for the question!

Nice question thanks. (Though I am surprised by the number of people getting it correct.)

mtassin (5/2/2011)

---

On another note though, I notice something about the final graph of performance around the 270 mark on the X axis. The pure SQL set based method seems...

gary.rumble (5/2/2011)

---

I'd be interested in seeing the data you used for benchmarking.

I tried a method that used a cte to generate a table of offsets for the delimiters. Then...

Thanks for the excellent article that was both entertaining and instructional. I will be making use of your new splitter soon!

Tom.Thomson (4/29/2011)

---

Well, I don't see any smileys so I guess I'd better answer that assuming you were being serious. 😉

Each phone number is introduced by a 1 character code, and...

Tom.Thomson (4/28/2011)

---

Peter Trast (4/27/2011)

---

OK, here is the fix for hardcore 1NF fans. One column, long text datatype (pick your fav) like concatenating an entire name if there is no use...

Vishal Mehta (4/27/2011)

---

actually instead of storing logins in a table I have queried active directory & based on the credentials stored in it, the parameters could be driven. Will be...

Thanks for the article, it was well written and expands my knowledge of Reporting Services.

Yep, work from home is allowed, only for exempt employees, and in a lot of cases expected...

Peter Maloof (4/27/2011)

---

If you were a little under the weather, would your manager expect you to:

A. Telecommute, and do a day's work

B. Call in sick, and do no work

C. Come...

Nice question, thanks!

Thanks for the question!

Nice question, thanks!

What is more troubling for me is that if you expire and/or disable an AD account any SQL Agent job(s) setup to run under that account will continue...