TomThomson (5/23/2014)

---

happycat59 (5/22/2014)

---

raulggonzalez (5/22/2014)

---

thanks for the question,

but why all answers say "only" at the end?? that's a bit confusing since no option has all the types listed in BOL....

If all mentioned files types mentioned in the answer are correct plus the database mail & local Maintenance plan logs; then the word "Only" is incoreect here 🙂

Good question & explanation, thanx.

Hugo Kornelis (5/20/2014)

---

Thanks for the question, Andy!

Oh, and before I forget - the first link in the explanation appears to be broken, I had to use copy and paste to...

Good question, thanx Andy 🙂 but I don`t recall I ever seen more than 10 FK on a single table.

Koen Verbeeck (5/19/2014)

---

Nice question, thanks.

I always find it a bit strange when I read something like this:

"what are the optimal settings" <> "may be optimal"

Too bad the documentation doesn't really...

paul.goldstraw (5/19/2014)

---

Hany Helmy (5/17/2014)

---

paul.goldstraw (5/16/2014)

I had a similar problem with 2012 where using CTRL+R didn't toggle the results window. I followed the advice on this page. Perhaps you're affected in...

Thanx...

TomThomson (5/16/2014)edit: Ah, I now see that earlier today the wrong answer was right (and there was a wrong word too). I should have read to the end of...

Steve Jones - SSC Editor (5/16/2014)

---

Arrggh, I ticked the wrong box, and apparently got fooled by the documentation. I use this all the time, so I'm guessing I was moving...

Really good question, enjoyed reading, searching, answering it & the explanation is great too.

Thanx Andy 🙂

Yes, the 2nd one worked, thanx 4 sharing!

Not me 😎

In the question, it`s mentioned the column name is: Lastupdatetime, but in the code, it`s Lastupdatedatetime 🙂

And now it`s 34 got it wrong 🙂