removed by poster to keep thread from getting locked

Gregory, may I recommend that you get a performance tuning consultant in for a few hours or a few days to give your system a review? I suspect there...

I fall squarely in the use the right tool for the job camp. And if I decide that a GOTO is the right tool for the job, that is...

Matt Miller (#4) (1/17/2010)

---

I didn't.

I'm saying that most OO languages these days would tend to...

I think you are missing some things from your example, such as transactioning and error handling. :hehe:

It was actually a very intense and interesting exercise. Obviously significant tuning and benchmarking, but quite a bit of analytical work too. When you have a table with...

CirquedeSQLeil (1/15/2010)

---

I've seen that as well. Nice to run...

sparky-407434 (1/15/2010)

---

If you set up a FULL backup of original database you could use it for the simple method of replication from previous reply. Also if you don't do Transaction...

With so little to go on my gut says this is a case for a star schema and proper OLAP constructs.

I will add that if you really want...

be wary!!! If you let it DTA will severely bloat your database with massive numbers of indexes with huge amounts of INCLUDED columns. And trust me, LOTS of...

doug turner (1/14/2010)

---

LOL!!! Thanks, but I've tried to tell them that. I'm doing what I'm doing from Google, a book, and this Forum. They don't see a...

If you wish to be successful in this endeavour, which is complex and has high-end requirements/constraints, you REALLY need to get a qualified professional to assist you. It is...

I don't believe partitioning is necessary here. Just do the deletes in batches small enough that you are guaranteed index seeks/bookmark lookups (if clustered index isn't on date). ...

I feel compelled to add that replication is an ADVANCED topic. Almost every 'regular user' out there that tries to implement it goes astray - often with really bad...

Key point that many miss:

If you do a REORG of index, you MUST update the statistics manually.

If you do a REBUILD of index, you must NOT update the statistics manually...