SQL Profiler should be a good place to start. Go with multiple threads to match your workload a bit.

select datalength(column_name) from Table

How long has replication been up and running?

Your best bet is to google skuupgrade=1 and 2005 the doc isn't real clear.

Also what OS are you running?

How many inserts do you do within that transaction?

Here is why...

An bad index, should show up as a corruption issue and the data should be corrupt period, the corruption would not move to the last hours worth of...

I think he is (and I was going to ask) for is the view definition...

Any chance this is all just a time zone issue, is always exactly a whole multiple of hours it is missing?

Also when you just use the query that is in the view with the same qualification you get the same results right?

Ok humor me and give it a try with the date/times fully specked out ie

'01/01/2010 15:30:45.123'

Any chance you can post the query?

Ok if just running the query that is used for view is also giving you the wrong results then I suspect that the view is not the issue.

Is the window...

Yes creating an index on a view can slow things up while the index is being created. There is also some overhead on write operations as well. ...

One big thing on schema design is that you need explicit defined primary keys. Other than that general good design is your best bet.

There are some scripts out there that claim to do it as well as at least one third party application.

Do a google search on

decrypt sql 2005 stored procedure

And you...