Fal (12/9/2013)

---

GilaMonster (12/6/2013)

---

Thanks everyone

I did have more...

There has been quite a bit of very useful scripts being posted. I'd like to share one that utilizes a neat technique that I learned about right here on SSC.

First...

At the prompting of sqlrnnr, we would like to also maim this person.

Seriously, I've very pleased to see this public apology....

People reading this thread: Beware! As GordonLiddy noted a few posts earlier, the text of this article is a direct copy/paste from Itzik Ben-Gan's fantastic book "Microsoft SQL Server 2012...

Paul White (12/3/2013)

---

I have a copy of Itzik's book, and I can vouch...

Jeff Moden (12/1/2013)

---

FINALLY!!! AFTER NEARLY 40 YEARS, AN EXPLANATION!!!! When I was in the service, I had a...

Grant Fritchey (11/22/2013)

---

I got to meet another Threadizen last night. Revenant is doing some seriously wild stuff with the technology we all use. If you get the chance to talk...

Thanks Dwain.

desperadomar (11/18/2013)

---

Thanks for the info ,I will give it a try to sp_whoisactive, but when you use sp_who2 I can only see some spid's in the

column...

I like to use sp_who2 and/or Adam Machanic's WhoIsActive to determine the root blocker.

Thanks gand. I enjoyed putting it all together, and I hope many will get some use out of it.

Speaking of Tally / Numbers tables - does anyone have a tally-table based query that you wish would run even faster? I'm going to be doing a test of the...

Steve Jones - SSC Editor (11/14/2013)

---

No such thing, for...

Lynn Pettis (11/13/2013)

---

Just finished the interview, and I feel like a Junior DBA....

Stefan Krzywicki (11/13/2013)

---

You can't know everything. There is a hell of a lot to know in SQL Server and if the interviewers didn't set up expectations for the interview properly...