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...

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...

GSquared (1/10/2013)

---

Can I call this proc recursive? Under the headings of Performance, it shows some problems coming up from proc sp_Blitz. 🙂

[master].[dbo].[sp_Blitz] has WITH RECOMPILE in the stored procedure...

PAH-440118 (1/10/2013)

---

One point: You refer to making SA the database owner. I agree this should be set to a suitable account but I was always of the opinion that the...

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...

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...

OK, great, that's one start. Now can you follow up with the rest?

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...

inteledyne (6/7/2012)

---

Switching the last partition in the 6 month filegroup to the archive filegroup will cause a complete index rebuild on the whole archive table? can i prevent that from...

There's a fundamental problem with your diagram: you've got tables tied directly to files. Tables are never assigned to files - nothing is ever assigned to files. Objects...

rmechaber (5/1/2012)

---

So, while I've got your attention: is there any? miniscule? significant? write-performance hit in writing to a 2-drive mirror compared to writing the same data to a single disk...

rmechaber (5/1/2012)

---

But I don't understand why a hardware-based RAID controller doesn't simply pipe the same data off to 2 disks simultaneously, reducing the write-time penalty to something much less than...

Greg - good post, but the explanation of IOPs is not correct. You write:

In basic terms IOPS is a measurement for the amount of time, on average, required to...