Viewing 15 posts - 3,001 through 3,015 (of 6,216 total)
Good answer! If you have sufficient memory, you only pay for the physical reads once. Testing with no data in cache is the worst case. It will happen sometimes, but...
October 28, 2002 at 7:47 am
Might want to look at this, get some ideas or just use as is!
http://www.sqlservercentral.com/products/bwunder/archiveutility/
Andy
October 28, 2002 at 5:55 am
Think you need the with move option to change where the log files go.
Andy
October 28, 2002 at 4:35 am
The ECID column of sysprocesses identifies sub threads. Not quite related but I'll throw in, not unusual for either the app or a component of the app to open a...
October 28, 2002 at 4:33 am
One would be to just do the move at the end of instead of during the loop. The other would be to make sure you're closing the connection and setting...
October 28, 2002 at 4:31 am
Not sure you should be looking at physical reads at all then, just logical. Have you tried the index tuning wizard?
Andy
October 27, 2002 at 9:51 pm
Why does it need to be physical reads? Read ahead reads will drive the disk just as well.
Andy
October 27, 2002 at 3:28 pm
I'd guess that once it knows its a heap and/or that its going to do a table scan, the read ahead reader picks everything up from disk, making the query...
October 27, 2002 at 4:38 am
Havent tried any 3rd party tool for replication so can't help much. I've found replication to be very reliable, just have to look at your situation to see if replication...
October 26, 2002 at 10:55 am
You might also gain a lot by indexing the join columns, even if only long enough for the operation.
Andy
October 26, 2002 at 6:25 am
DTS packages maybe. Other than that, apps pointed at the old server maybe.
Andy
October 25, 2002 at 7:59 pm
Try updating the originatingserver column in sysjobs.
Andy
October 25, 2002 at 2:11 pm
Just create scripts and run. You can shortcut the process some by creating copy of the table structure, setting up your indexes using EM, then once you're happy script them...
October 25, 2002 at 1:35 pm
Just tested, works fine here. Tried stop/start mail?
Andy
October 25, 2002 at 12:49 pm
Log shipping should work, its not going to be that much extra work compared to just doing the log backups anyway. Simpler and fewer constraints than trying to use replication....
October 25, 2002 at 11:29 am
Viewing 15 posts - 3,001 through 3,015 (of 6,216 total)