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...
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...
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...
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...
Hi, we have a scheduled maintenance (reorg pages with original amount of free space / check integrity with indexes included) task setup on several...
Separate names with a comma.
