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...

Oh, and one more thing - 10GB is NOT a large database. My guess is that there are MANY other things you should be doing first to improve your...

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 elimination during...