In that case, the bottleneck may not be network latency, it may be the processor. Aside from increasing the number of threads, which I think has already been mentioned, you...

With SQL Backup, I would recommend changing the MAXDATABLOCK parameter to a lower value. By default it's about 4MB, and this can cause trouble for SANs and network backups. Changing...

Hi All,

I'd go with Red Gate SQL Compare for accuracy reasons. It will attempt to alter your columns if it can rather than trying to rebuild the table every time,...

Hi Raj,

  You might want to try out some of the database synching tools on the market. You could synchronize the data at the click of a button. Otherwise, you're...

It's probably best to use nslookup to resolve a host name. Pinging doesn't always work, especially if the firewall does not allow ICMP to get through. That's a fairly common...

Hi,

   I ran into a problem with FTP after we upgraded to Windows 2003. Routing and Remote Access Service only allowed PASSIVE FTP through the server. Being Mr. Lazy, I...