Any compact or express edition maybe that you might have missed out on?

Any processes still opened that will be whacked by a reboot?

My last, last, last resort would be to...

This is an estimated plan. I need the REAL plan. That's where all the nuggest are found.

I also need the index definitions to really help out.

I understand you...

Not sure I understand. In report viewer??? you have to supply to real dataset so in all actually the user has to supply or choose the stuff...

Safe way to go is to wipe out everything.

Another way would be to re-run the setup to see if you can't delete stuff that way.

Last resort this in...

as2higpark (7/5/2011)

---

So, forgive my ignorance, but that query returns 750 rows. The overwhelming vast majority(>90%) are the same query that also shows as being the highest CPU offender. It is...

P.S. I'm toying with this in my system as well and I've found out that the % are very frale right after reseting the stats to 0.

I just had...

From Jonathan's blog (link posted way earlier in the thread).

What does this return?

SET TRANSACTION ISOLATION LEVEL READ UNCOMMITTED;

WITH XMLNAMESPACES

(DEFAULT 'http://schemas.microsoft.com/sqlserver/2004/07/showplan')

SELECT ...

as2higpark (7/5/2011)

---

Thanks Ninja, I just added that one to my list of queries to try.

I ran this on the problem DB and no stats are more than 0.3% modified,...

as2higpark (7/5/2011)

---

Thanks Ninja, I just added that one to my list of queries to try.

I ran this on the problem DB and no stats are more than 0.3% modified,...

I'd consider it.

http://www.microsoft.com/sqlserver/2008/en/us/compression.aspx

But you also need to plan for the next 6 months to 3 years to make sure you have enough room and budget for expansion!

Keep in mind that...

Stop shrinking your dbs it'll only hurt you.

The only way to stop a db from growing is to stop inserting data.

Equivalent would be to start purging data, or archive it...

steveb. (7/5/2011)

---

dont waste time dropping indexes to save space on the copy, as you will need the space again when you recreate them.

The simple way to move a database...

I think he wants to keep all 4 backups in the same .bak file and then remove the oldest.

What I've always seen is 1 file per backup where you delete...

This allows you to restore by mounting a db straight from the backup. Takes very little extra room on top of the backup size.

http://www.red-gate.com/products/dba/sql-virtual-restore/

as2higpark (7/4/2011)

---

Thanks to both of you, but stats are in good shape, we run a full update weekly on all indexes, plus we ran a midweek one last week as...