Viewing 15 posts - 91 through 105 (of 141 total)
I'd love to see someone else do it, but I'm not aware of how to enumerate the list of instances that way.
February 18, 2013 at 12:54 pm
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. ...
February 18, 2013 at 6:03 am
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.
February 18, 2013 at 5:49 am
quackhandle1975 (2/18/2013)
February 18, 2013 at 5:39 am
jasona.work (1/22/2013)
Fill factor 0 = 100% full on each page (no free space) so adding ANY new rows to the table will cause a page split, correct?
Not exactly. SQL...
January 22, 2013 at 8:03 am
richardmgreen1 (1/22/2013)
I'm just woring through this and I've found a database where all the indexes have a fill factor of 0 (yup, zero).
Fill factor 0 is the same as 100....
January 22, 2013 at 4:46 am
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...
January 15, 2013 at 6:46 am
The log-bigger-than-database check is one of my favorite recent additions. I can't believe how often it comes up, and it's something I never would have thought to check for...
January 15, 2013 at 6:07 am
GSquared (1/10/2013)
[master].[dbo].[sp_Blitz] has WITH RECOMPILE in the stored procedure...
January 10, 2013 at 12:59 pm
PAH-440118 (1/10/2013)
January 10, 2013 at 12:08 pm
Hi! Brent here. If you're the kind of person who learns best by reading, I'd check out the book Virtualizing Tier 1 Applications on VMware vSphere. I'm typing this from...
October 24, 2012 at 10:24 am
No, I mean follow up on the error. Check all of the event logs described in our troubleshooting checklist:
http://www.brentozar.com/archive/2011/12/sql-server-troubleshooting-checklist/
Go through all of those, and the error's going to show...
September 8, 2012 at 10:38 am
OK, great, that's one start. Now can you follow up with the rest?
September 8, 2012 at 10:35 am
No, you can't ignore the error. 😀 Check all of the event logs described in our troubleshooting checklist:
http://www.brentozar.com/archive/2011/12/sql-server-troubleshooting-checklist/
Go through all of those, and the error's going to show up in...
September 8, 2012 at 10:21 am
inteledyne (6/7/2012)
June 8, 2012 at 6:27 am
Viewing 15 posts - 91 through 105 (of 141 total)