joseph_c (12/27/2013)

---

Going to my first SQL Summit and shaking Itzik Ben-Gan's hand. His fundamentals for SQL Server book is what I cut my teeth on. Getting to shake...

Yeah, I traced back the problem through the...

My favorite memory is hearing that my stuff is other people's favorite memories, heh.

My least favorite memory: trying to troubleshoot people's computers and networks as they reach my site. :rolleyes:

Why is it headline news that you agree with me, Steve? Are you saying you don't always agree with me, is that what you're saying? You'd better not be lying...

Awww, wow, sad to see the podcast end, but looking forward to seeing what you're focusing on next.

Thanks for showing this to folks and including your findings!

A couple of quick notes - the Cost Threshold thing isn't really seconds. The BOL topic says it's seconds for a...

Ha! No worries. Do you have T-SQL handy to detect that? If so, can you email it to me at help@brentozar.com? If so I'll add it to the check,...

Ooo, nifty! Thanks, I'll give that a shot - I don't have a multi-instance VM at the moment, but I happen to be working with a client later today...

I'd love to see someone else do it, but I'm not aware of how to enumerate the list of instances that way.

Hahaha, yeah. There's a few similar things I'd like to be able to detect (partition alignment, driver versions, etc) but there's only so far I can go in T-SQL. ...

The question is - how do you get a list of named instances inside T-SQL? I'm not aware of a way to do that.

quackhandle1975 (2/18/2013)

---

Just a question for a possible upgrade, have a Server here with 8 sql instances installed (yes on a prod server, I know, I know!) , maybe a future...

Not exactly. SQL...

Fill factor 0 is the same as 100....

Hahaha, yeah, that's fixed in the upcoming v17. The funny part is that sp_Blitz doesn't actually use WITH RECOMPILE, but the check looks for the words, and the words...