Viewing 15 posts - 4,171 through 4,185 (of 6,216 total)
You'll get the max speed by removing all indexes from the destination table and using BCP with a large batch size. Given that the performance using DTS is acceptable (more...
May 29, 2002 at 8:29 am
The answer is it depends. For a highly scalable app you'll want to open and close the connection as needed. For less intense apps I see nothing wrong with holding...
May 29, 2002 at 7:31 am
It's damn handy and much cleaner than the global temp thing (which I've used a few times!).
Andy
May 29, 2002 at 7:29 am
Were you able to see where the space was being used? Tempdb maybe? Or the temp folder on C?
Andy
May 29, 2002 at 7:28 am
It's not just connections, it's what those connections are doing. Or if you're using Personal Edition, then connections is even more critical since there is a limit. Or you're trying...
May 29, 2002 at 6:10 am
It is possible to do output params if you use sp_executesql, the syntax is a little weird but doable. Try this thread:
Andy
May 29, 2002 at 6:04 am
You can change the name using sp_changeobjectowner, the only question is whether the app will break or not. If it just uses the tablename everything works since it tries currentuser.tablename...
May 29, 2002 at 5:31 am
May 28, 2002 at 7:11 pm
Not much to go on? Are they all using the same stored procs, running the same query? Might just need to do some index tuning. Is the server overloaded?
Andy
May 28, 2002 at 7:10 pm
Definitely sounds bad. Extending the time out will just mask the problem. You're using linked SQL tables or doing everything via code? Are you using the latest MDAC on the...
May 28, 2002 at 7:08 pm
Only way would be if you could establish a VPN connection or use PCAnywhere, etc.
Andy
May 28, 2002 at 7:01 pm
Might check to see if sqlmaint.exe is still running, might have gotten hung up.
Andy
May 28, 2002 at 6:59 pm
Backup and restore will preserve the indexes. A "copy" may or may not depending on how you do it.
Andy
May 28, 2002 at 1:49 pm
I doubt it would cause a problem but have never tried. I'd recommend testing on a separate machine first.
Andy
May 28, 2002 at 1:25 pm
Viewing 15 posts - 4,171 through 4,185 (of 6,216 total)