JSteppenwolf (3/2/2010)

---

There are less then 70 tables where changes occur, but most tables are small, and changes are minute. About 10 tables contain the bulk of data, and you're right,...

If you wanted to go with transactional replication you most certainly could. You could setup a synchronization schedule specific to your refresh, or even kick start the sync post refresh...

In XP c:\documents and settings\<username>\application data\Microsoft\Microsoft SQL Server\100\tools\shell

look for SqlStudio.bin

Connection information is stored in there, if you delete the file the connections go away, when you relaunch SSMS it get's...

The instances will also be fighting for disk and network i/o if they both have workloads as well, something to bear in mind.

Check the fragmentation on your indexes as well.

Glad you're back up and running.

I completely missed that when I first looked through. Good spot.

First, rollback the OS updates, then move the mdf, ldf for the database you attached and see if it will start up.

If you still have no joy then you might...

I think this is designed behavior. It still saves the password and it can be used, just doesn't show up in there. I have that with all my packages, drove...

BaldingLoopMan (2/24/2010)

---

mem settings

•If server memory is <= 3 GB, set min memory to 1 GB, and max memory to server less 512 MB.

•If server memory is > 3 GB, settings...

Oh, and don't forget to check out both ends of the communication chain. I spent a good while troubleshooting something in the past just to find out it was the...

It looks like a network error. I would check your network connectivity, see if you are dropping packets. Netmon or wireshark [/url] would both be a help in packet investigation,...

if you set statistics io on and execute the query what do you get as regards scan counts and reads?

Also, what does your execution plan look like? and io stats?

Have you compared the execution plans between the two environments to see if they are the same? How about any hits to the disk? How hard is your hardware working...