I liked the compromised you took when dealing with this problem.

I have worked in the past with these issues and my opinion is that it is the "usage" what dictates...

There are crazy HW solutions to this problem like the use of "RAM Drives" but you will be risking integrity with them

IF you are willing to get such risk go-for...

The First step is to make the Log reader run in verbose mode.

See if that gives you more info.

Is this what you are talking about? http://support.microsoft.com/kb/911305

Hehe ... Don't mean to laugh but I sounded too good to be true for M$ 😀

True, but I'd hope most servers are more powerful than my desktop. Plus, if it's done during a maintenance window (and I wouldn't want to try creating indexes while the...

have a look at sys.dm_db_index_operational_stats

select coll, FYear + months.m

from ABC

cross join ( select '01' as m union all

...

Hehe Lowell beat me to it :d

select convert( char(8), datecolumn, 112) dt, datepart( hour , datecolumn) as hr, count(*) cnt

from table

group by convert( char(8), datecolumn, 112) , datepart( hour, datecolumn)

serge.kovacs (1/27/2009)

---

noeld (1/27/2009)

---

I have seen similar scenarios and I I know that the proplem is APP design.

Are you sure your app needs ***ALL*** before it starts.

I have been working with...

Oh boy... If such article is there it is because several ( maybe a...

Do you have tempdb on a separate drive?

If you do, using SORT_IN_TEMPDB could alleviate the problem a bit.

As long as there are not a lot of constant inserts going on...

I have seen similar scenarios and I I know that the proplem is APP design.

Are you sure your app needs ***ALL*** before it starts.

I have been working with SCADA Systems...

Good you figure it out.

Retention policy > 0 is usually not a bad thing when not a lot of transactions go through the distribution DB. It is not that good...

well If you have Enterprise Edition you could use ONLINE=ON 😉

If you don't you are probably out of luck 🙁