Sorry, I...

SQL Monitor from Red Gate will do this (and more). You can eval and see if it is valuable for you: https://www.red-gate.com/products/dba/sql-monitor/

Disclosure: I work for Red Gate

Not completely comprehensive, but here's a Stairway we did: http://www.sqlservercentral.com/stairway/72401/

Thanks for the update.

Sarus1984 (1/22/2013)

---

Hi Steve,

thanks for your thoughts on encryption, like you I think it is to much ignored in our business.

I would like to ask a further question about encryption. Perhaps...

This is good info, but slightly old....

"Pay" isn't always accurate. For...

I'm not sure that's true. I do...

roryp 96873 (1/21/2013)

---

Steve Jones - SSC Editor (1/18/2013)

---

roryp 96873 (1/18/2013)

---

Anyone ever been to Chase Field in Phoenix? I am going to be down there in April and try to...

If you run out of space, then yes, the query fails. You don't have to restrict sizes, though as Jason mentioned, this is recommended in some cases. Not sure how...

MyDoggieJessie (1/22/2013)

---

It's a good rule of thumb to place it on multiple drives (especially in RAID configuration). Have you taken steps to monitor your tempdb usage and do you...

Tara-1044200 (1/22/2013)

---

but i am planning to put them on a single SSD drive which i asusme would be 8 files each of 100gb. so i think any file would be...

http://www.newegg.com/Product/Product.aspx?Item=N82E16820227724

A 2TB SSD was announced last week as well.

No idea, but I'll ask around.

Great explanation from Brent and sorry for the delay in responding. I wouldn't change fill factor without looking at my RAM (target v actual) and the page splits. I'd have...