Out of date statistics will seriously affect the query and might mean it does lots of I/O and doesn't consider indexes.

To fix either

(1) Turn on auto create and auto update...

Out of date statistics will seriously affect the query and might mean it does lots of I/O and doesn't consider indexes.

To fix either

(1) Turn on auto create and auto update...

Normally the first option is the way to go.

If you are worried because the database grew that is what happens in normal running. You'll find it has some free space...

Thanks, I'm glad it worked so well for you.

Tim

RedGate SQL Compare will show you the differences and script them so you can bring them together again.

You can also keep a snapshot of databases so in you case you...

Tara, it is unlikely you need to worry.

If you leave SQL Server to determine how much memory it needs it will normally do this accurately. Normally it grabs as much...

Looking at your figures reducing the fill factor on those indexes may have spectacular results.

I have a few examples of production indexes that would fragment by 50% over 24 hours...

Gail, you are never short of a decent tip, and that's an excellent one!

Passes the test of not having to write it down and almost impossible to guess or crack...

BarkingDog, this is a good question and you will probably get a number of pedantic, 'best-practice' and impractical answers to it.

For my money you tie down your production DBs first....

I think you need to be much more specific!

Deleting one row on a unique clustered index .. really quick

Deleting one row on a nonclustered index .. slightly slower

Deleting one row...

Further to this I just got the following reply from Paul White on another thread:

Paul White (4/30/2009)

---

SQL2K5 caches 1 data page and one index allocation map page for a temporary...

Grant, thanks very much for your input too, I really appreciate the help.

Tim

I actually abridged my profile too much! I was capturing both events, and I...

Thanks Mike, I'm glad the link was useful. I agree with your DMV experience, I got just the same effect.

One thing I didn't mention in the previous post is the...

I tried this on a SQL 2005 database migrated from SQL 2000 and had this exact problem. I wanted to do small shrinks as the database in question is a...