Viewing 15 posts - 1,426 through 1,440 (of 6,216 total)
It's not bad, nothing fancy. Wont hurt to try it.
Andy
October 29, 2003 at 4:36 am
I just set one of these up, have seen similar. If you query the server with SQL*Net it seems to bring the connection up. Dont know why. Voodoo.
Andy
October 29, 2003 at 4:33 am
My least favorite, TIA - thanks in advance. How do I know Im going to really appreciate it?!
Andy
October 28, 2003 at 5:01 pm
October 28, 2003 at 4:57 pm
DTS you might try running from a separate machine. Have to make sure paths and permissions are there, but that way you move some of the load. Still have data...
October 28, 2003 at 4:55 pm
Thats the way its defined? Or actually has that much data? Converting to text col probably your best bet. Might find this interesting:
http://www.sqlservercentral.com/columnists/sjones/pagesize.asp
Andy
October 28, 2003 at 4:53 pm
October 28, 2003 at 5:24 am
October 28, 2003 at 5:20 am
October 28, 2003 at 5:19 am
You could use dynamic sql. Either build up the string 'use database;blah blah' and then use sp_executesql to run it, or just call your code as is from an ADO...
October 28, 2003 at 5:18 am
First thing (and best) is to try to make the code work on a set instead of a single row. If you can't (or dont want) to do that, then...
October 28, 2003 at 4:49 am
I'd agree with that! Replication is a good sized chunk to master. First thing you have to figure is which type of replication you need to use to solve your...
October 28, 2003 at 4:46 am
In some cases a cursor is also appropriate - one case would be when you need to call a proc or whatever once for each row modified. Use with care,...
October 28, 2003 at 4:44 am
I'd say that is a fair bet. Put profiler on it, see where it's coming from. Probably a good idea to also change the SA password and make sure that...
October 28, 2003 at 4:19 am
Im using a CX400, having no issues. Maybe not loading it as hard, but its been fast and stable. I'd push on them!
Andy
October 27, 2003 at 5:39 am
Viewing 15 posts - 1,426 through 1,440 (of 6,216 total)