Are you using dynamic management objects from 2008? Most of them are in 2005, so you can just reuse them.

SELECT * FROM sys.dm_os_performance_counters ;

for example, works in 2005.

I'm a huge fan of Embarcadero's ERStudio. It's just an excellent piece of software. Yes, it generate the model straight off the database. You can also use it to design...

If you're looking at an event, like sql batch completed, then the query that's in the text column is what generated the reads, writes, cpu and duration that are in...

I just started working on an article on the backup header, so I can't point to it yet, but basically, the full backup has a marker for where it's at...

To my knowledge we don't do that.

Who is the spam from?

richardm-1037631 (2/8/2012)

---

Grant

I really liked your statement "don't associate the log backups to the full or differential, but also, don't ignore them because of the full or differential." That hit...

If you're looking for more, my chapter in the SQL Server MVP Deep Dives Volume 2[/url] book is all on parameter sniffing. (proceeds from the book go to charity in...

richardm-1037631 (2/8/2012)

---

Grant

Thanks for the response. I've got 2 additional questions. Currently on my secondary server, sql server and sql agent are running as "Local System". Does this...

richardm-1037631 (2/7/2012)

---

I am trying to setup a backup routine for my primary and secondary SQL2005 DB servers. The primary server has DBs with sizes around 200GB and the secondary...

Wait, you're running a full backup every two minutes? Is that right?

Assuming I'm reading that correctly, don't do that. If you want to be able to restore to a point...

Parameter values are not stored. If a procedure has 4 parameters, then a plan will be created that has spaces for 4 parameters. Sniffing will ensure that the plan stored...

Lynn Pettis (2/7/2012)

---

Now that it is officially posted on facebook, I can start telling everyone.

Kassondra gave birth to a healthy baby boy yesterday in Germany. Grayson Matthew was born at...

mtassin (2/7/2012)

I don't see different query plans with 4136 on or off, I see vastly different performance with respect to response times. So much so that I would be...

Really?

Wow.

I...

I have not seen it, but the first two look like system generated statistics. That's nothing to sweat since they're going to be completely rebuilt anyway since statistics generated in...