manohar (8/31/2009)

---

this is the time and io statistics

Table 'ScheduleUser'. Scan count 0, logical reads 3, physical reads 0, read-ahead reads 0, lob logical reads 0, lob physical reads 0, lob...

Sorry, don't understand the question. What version?

Read the rest of that thread. The post that you quite is speaking purely about the idea of using a trigger and is incorrect as well.

That exec plan looks pretty optimal. Not much that can be done other than widening indexes to get rid of the lookups.

How long is that taking?

Is there blocking?

What...

Anything more specific than...

What's the script of the job?

You can also get the correct syntax by reading Books Online, the SQL help file. It really is very good.

You still haven't mentioned the retention period. How long does the data have to be kept? Is older data changed, or is it read-only?

You say updates are slow. Have you...

Ok, you need a couple indexes and a partial query rewrite. I have no idea how SQL 2000 was executing this, seeing as it would have had to do table...

It is not possible. When a DB is restored or attached to SQL 2008 it...

Script or routine for what?

What maintenance are you doing on the log? Why is it so large (hint, see sys.databases for the log_reuse_wait_descr column for the reason). What recovery model?

I've worked with unpartitioned tables with over 150 million rows in. That's equivalent to 2 and a half months of your data. It's manageable and a few million is not...

That's odd. Must be something in the log that the backup needs, maybe an open transaction

Also, I have to ask, a 61 GB log file with a 560 MB data...

I understand what it is you want. What I'm curious about is why you want to see any one of the child rows. Usually for this kind of thing there's...

Integrity check has to read every single page in the database. That's going to read a lot from disk.