Thanks Mark. Glad to hear the "IO freeze" is so brief. Does snapmanager handle log backups? We've always run in full recovery mode with log backups every 15...

Ok, I was hoping for information specific to the decision of whether to go from 2005 to 2008 or directly to 2011. Along the same lines, what is meant...

If your database has been normalized you'll have to deal with child table records. Ours is one of those created, initially, by a tool ( Visio I believe) and...

I just started doing an hour per weeknight, and after some fiddling around, was able to confirm that something like 100 stats are getting done each night. I had to...

Sorry, I wasn't clear enough. I have a general understanding of using sampling rates. The question is how to choose a sample percentage that will "get the job...

Ah, it's freeSystemcache('sql plans') I kept looking for options that can be used with freeProcCache.

Now when I run the query below I get the output below. But the 12,000...

Actually freesystemcache('sql plans' ) removes adhoc plans.

( hit the post button by accident, see next one )

So that job also dumps all sql plans, not just single-use plans.

DBCC FREESYSTEMCACHE('SQL Plans')

In that sql agent job that deletes single use plans, I'm curious what this line does. We only have one sql 2008 box and it returns "10.0.2531.0"

/* enkel...

I actually watched that webcast last week. I don't want to resurrect the whole debate about ORM vs. stored procedures. The fact is that many IT shops have...

Thanks. I do have Adam's WhoIsActive and the WhoIsActive UI that can be used with it. The worst offenders run after my bedtime 🙂 but...

Rob I did email our lead developer about possibly switching the varchars to a set, large size. Or can they be tied to the column widths? The...

When I look at plans that are used less than 5 times, I do see that many of the parameters passed in are of the same data type and/or...

I'm sure the generated sql is parameterized. Here is one of our worst offenders in terms of spiking CPU. I've changed a few key words from what...

Yes the developers use an ORM to generate most of the sql. C# .net