A couple of things. You aren't presenting your thoughts or question well. Your first post said "I have setup" Not to dwell on it, but if you don't phrase a...

Replication occurs on a schedule. Did you set up push or pull replication?

Your post doesn't make a lot of sense, so please carefully explain what you think is, or isn't,...

Sometimes I hate Ajax crap.

Link updated, apparently Google doesn't want to make it easy to sync the URL with the content.

I used to work in Richmond, now I'm a...

LOL, I had some skills at 25, though much different skills. Definitely more passionate about the "cool" technology pieces. Not sure I could have run this site then.

Well I showed Gail last year, but here I am

Nice and quiet.

Set up a tracer token as well, see where the times come back.

If you have specific publications, how much data is changing? It's possible that you might exceed the capacity...

Let us know what happens.

What is tempdb set at for a size? I wonder if you can set it lower and restart SQL.

Surprisingly I see things with the horses as well that remind me of managing people all the time.

jpowers, best of luck in finding something.

Thanks again for all the responses.

One thing I thought of recently is that most of the "fads" and "new things" that are put out...

The SARGable argument, for me, would make me lean towards straight integer or character columns.

It sounds like a security issue from your description. I would contact your web hoster with the issue.

Ah, but less and less all the time. I remember when I...

This one?

http://www.sqlservercentral.com/Questions/Tags/System+databases

I agree with Gail. Think about what happens if your database fails 10 minutes before the next full/diff backup. How much work is gone since the last full/diff?

That's a risk,...