For me, in my lifetime, the dishwasher. And I used the scientific method to determine that.

I specialize in data.

Good script, thanks.

KenpoDBA (9/7/2015)

---

The title of this is misleading isn't it? Because you're not really getting query results out of SSMS, you're just re-running the query in PS. If you've...

I like the first answer best.

PB_BI (9/4/2015)

---

Nice question - BOL says that sysprocesses will be removed from future versions and to use sys.dm_exec_connections, sys.dm_exec_sessions, and sys.dm_exec_requests instead (https://msdn.microsoft.com/en-us/library/ms179881.aspx). That's what I love about QOTD -...

We have a similar script.

Great idea, thanks.

Ditto

Wow, this looks really risky.

Good article, thanks Val.

venoym (9/3/2015)

---

Very nice article!

Fairly good description of how to get started. As always, there will be variability in your configuration and usages.

Some things to remember:

1. You can enable Service...

We have everything in 2008 R2. When we are forced to move we will make the jump to the most current version and then probably sit on that one for...

Thanks for the tricky question.

Quite a few ways.