Have you looked to see what queries are being run during these times? Sounds like they might be hitting parallelism. It's worth checking to see what they're doing and how...

You're posting in the 2005 forum, you might get answers that are not applicable for the version you're looking for. You'll probably get more help by posting in that forum.

Well, in order to project growth, you need at least two measurements. Let's assume a week apart. Then take the difference and project it in a straight line, multiply by...

As a general rule, yes, but you do need to account for your own individual circumstances, the load on your servers, the number and size of your databases, etc. There...

It has to be something along the lines of which one will the optimizer pick first, but that's so subject to a million different factors, it's still not really...

First a comment, generic procedures that do everything, everywhere, automatically, are notorioiusly problematic. TSQL just isn't conducive to that approach.

The problem you're hitting is that you can't refer to tables...

Not sure about the first one, I suspect there's a different index name in there that is messing it up.

The second question, no update on the stats was needed because...

Most of this is available in system tables. What have you tried so far?

If you are placing a single quote within a string like this : 'O'Sullivan'. It actually has to be marked up like this: 'O''Sullivan' Note, that is two single quotes,...

The only one Gail didn't address is Update Stats. You'd be best to make that a part of the index updates. Frequency really depends on your system, but I'd say,...

You'd have to tell me how often it's called before I could tell you if it's a problem or not. I'm not crazy about setting up View SErver state for...

You have three options, all of them require you to run something on the production server.

You can set up a server side trace, which works just fine and as...

I agree. No way to know without discussing the details. A maintenance plan can just backup logs. I'd suggest that should be run many times a day, let alone X*7...

Laura Schmalzbauer (4/15/2011)

---

I'm trying to use sys.dm_db_index_physical_stats to find which indexes are fragmented enough to either be rebuilt or just reorganized. However, I am running into an issue where...

Kenneth Wymore (4/15/2011)

---

Doctor Who 2 (4/15/2011)

---

You brought up an interesting point, Jack, and that's the number of recruiters contacting you, trying to fill jobs. A few years ago...