Bruce,

Congratulations and hope you've had a wonderful career!

Any great plans? Going to come back and give us some wonderful comments about how you're glad you don't have to deal with...

Thanks for the update. You might have some weird selectivity there with the data.

Good to know it's working.

You are welcome and thanks for the update.

If anything comes up, please post again here. Might help someone else.

The srvname should tell you which server. The table tells you if it's publishing or subscribing. Not sure about distributor.

that is very strange. Can you look at the plans for one good and one bad execution and see a difference?

Or post them?

Brian,

Very cool! I didn't realize you could do this in SS2K5. I think it' s probably an unintended "feature" from MS, but that is very handy. I'll have to...

If you have to, the logs can run on C, but I'd limit the max growth and perhaps even put a 1GB or so spaceholder out there for emergencies.

Make sure that statistics are up to date (and auto gen is on). I'd also rebuild the indexes and run the application a few times. This will help you determine...

ANY tool will have to look at every query. Every bit of traffic to find what's offending.

You can limit Profiler to one database, even one type of batch (T-SQL and/or...

You can use ODBCPing or just connect with QA, SSMS, whatever, They'll run 1434 by default. Or you can specifically connect on that port to SalesDBServer with "SalesDBServer,1433" in the...

That's what I used to do! Back when we had 10Mbps NICs 🙂

We used a 192.168.2.xx network to the firewall for public access.

We had a 192.168.3.xx network to our...

You want to set tempdb to be at the size that it needs for the peak. Anything less can cause delays when tempdb grows. 1MB doesn't make sense.

Is is the same for all dates? Meaning hard coding different dates.

It's possible that there's a different level of selectivity and a different plan is used.

If you go to Enterprise Manager, you can check under the replication tab to see your publications. These are publishers. You can also check subscriptions. The publication properties will tell...

You cannot easily do this after the fact. Reading transaction logs will give you most of this, and there are numerous third party products to help here. They give you...