Hmm - in my experience CXPACKET waits are almost always the result of a suboptimal...

If you have the same problem did you try the same solution (-g startup setting)?

Oh, one more thing - be wary of using xp's in triggers. Better would be to put relevant data into a table that is asynchronously used to send the...

what error do you get? Have you checked various logs?

I am...

There really was no need for indexing information or the query plan. 🙂 The query as written clearly was doing 4 table scans and 4 associated joins. ...

If all your links to user_name are unique, this or something similar could work:

SELECT CASE WHEN MU.USER_NAME = ET.Prvd_ID THEN 'abc'

...

1) checkdb is VERY IO intensive, so I would expect to see indications of IO/Memory pressure during it's execution

2) There are MANY things that can interplay to cause memory to...

I would think that doing 4 table scans and 4 joins on a table with 40M rows WILL take some time. 🙂

Mark_Pratt (10/27/2009)

---

You can also get a performance gain regarding backups and restores.

If partitioned tables in your PRIMARY filegroup only hold 6 months of data, your filegroup backup may only take...

Which is precisely why we are all here on the SQLServerCentral forum!! 😎

Performance will improve because of exactly what I stated: partition elimination. You can have queries that will now touch just a (perhaps tiny) fraction of the table instead...

SinisterPenguin (10/27/2009)

---

TheSQLGuru (10/27/2009)

---

1) the first poster is incorrect. you CAN get performance increases from partitioning without multiple filegroups - sometimes vast improvements even. This would come from partition...

As Gail says, index column order is CRITICAL for most efficient querying. You need left-to-right hits on the columns or you can't do seeks.

1) monitoring for a few days is meaningless for db growth considerations.

2) you need to figure out how big each database will be over the course of 12...