interesting, in testing have you let it run for hours just to see if it ever stops or finishes?

run the session and the other system view whose name i can't remember but it's not requests

i have a join and dump the data into a table and check it...

just install it and tell us what happens

unless you have a good reason, don't shrink any of the db files. it may cause performance issues

blandry (11/18/2008)

---

I'm not sure you can link the OpenSource movement to the economic downturn directly - though I believe there may be some connection. Microsoft themselves are, to some...

there isn't much difference between MS and Open Source on the backend. The difference is in the finished product.

Take OpenLdap and Active Directory. The former you get a blank LDAP...

i set up a system using a free MS tool called logparser

i use it to dump logs into a db and then have SQL code along with SQL 2005 reports...

there is also an option to run the snapshot to a DVD and I think an external hard disk is OK then use that to initialize the sub

thx

i'm on a project right now to improve our replication. we have jobs that generate up to 70 million commands in a few hours. publisher is ok. we're having trouble...

check your memory settings, run a profiler trace. too many possibilities to think about

in my experience it's a big performance hit on the server being profiled. i prefer to copy the query and run my own execution plan

check your snapshot schedules, you might have a snapshot running several times a day

in one case we had to change the column for the clustered index. we have queries that select over 1 million rows in some cases with a one column in...

there is a bug in sql 2005 where if you run alter index and the log reader runs on the publisher at the same time then it may not pick...

i get this once in a while when i have to deliver a snapshot of a table that is 300 million rows. just ignore it.