Please post this as a separate topic. Sounds like the SQL server was not listening on the expected ports. One thing you can try in this situation is...
This server has 8gigs of memory, is a dual xeon dual proc machine. Lots of places mention about running out of paged pool etc with large file copies...
This issue is back to haunt me :( I did have logging turned on in DTS and the message I posted was from the log. I tried using Robocopy to see if it...
Thank you. Sounds like we will be having lots of fun. Anyone know if making a change to the client network utility will help apps that use ADO.NET...
Hi: we have an app that doesn't like named SQL instances and has a hardcoded database name (oh!*)#) Also since this is not an enterprise class app...
Thanks guys. The script ran fine last night. Network congestion could have been an issue as I was testing during the day time. However the servers...
Hi - I am trying to copy a database backup from one machine to another. Currently I am doing this in DTS using VBScript code using FSO. The file...
Guys, how can I get the plan for a stored procedure? Thanks
At the risk of sounding vague... We have a query that does some analytical processing on one of our databases. The query accepts a date range and...
Hi : we are considering using a trigger to populate a utility table with data information for later export. My concern is around the transaction...
Hi: I noticed that the URLs for previously posted topcs have changed. Anyway someone can post how old posting IDs can be used with the new URL...
Large batches would mean large log files, file growth, potentially disruptive locking etc. I would break up the batch into small chunks you will get...
Thank you for your suggestions. I found them very helpfull.
Hi: We have several databases that have maintenance plans set to "Reorganize data and index pages (free space 10%)". This is schedules to run once a...
Hi: I am planning on gathering some baseline information that can be used when evaluating options for future system upgrades etc. One of the things...
Hi: I am trying to troubleshoot an issue related to slow result being returned over a WAN. I have run the benchmark query on the server and across...
Hi, I am looking at ways to run large batch jobs and OLTP applications agains SQL server without the batch jobs stepping on the OLTP applications....
Hi: I have a few SQL server instances that periodically experience delays due to NETWORKIO wait type. I would like to know if there is a way to trap...
Performance tuning in my opinion requires a holistic approach. You need to be able to think through the query (number of tables,how the app connects...
Hi, thanks for your replies. * We are reindexing all tables. You are right I don't think this is necessary every week. * The maintenance is...
Separate names with a comma.
