Viewing 15 posts - 2,596 through 2,610 (of 6,216 total)
February 3, 2003 at 6:08 am
You could use named instances, run one client per instance.
Andy
February 3, 2003 at 4:44 am
Another way to do that is to issue a set rowcount 1000000 or whatever value. Definitely makes sense to break up into chunks, you could even run multiple spids doing...
February 3, 2003 at 4:40 am
Lets start with #1. The functions should work - can you post the code you're using?
Andy
February 2, 2003 at 4:29 am
Means you only create it once, so the blocking issue should just about go away. Probably need to index it to make it effective. Then any place you would have...
February 2, 2003 at 4:28 am
The basic join should be fine, I think if just change instr to charindex it will work.
Andy
February 1, 2003 at 2:59 pm
Shouldnt the duration of the lock matter more than the number? Considered just making it a permanent table (even if still in tempdb) and adding spid as a column. A...
February 1, 2003 at 2:33 pm
We'll get it fixed. We hate slowness as much as anyone else, maybe more, we spend a lot of time here! As Steve mentioned, its often just a matter of...
January 31, 2003 at 5:12 pm
Interesting idea. Like any cert, if they keep the standards high, it could end up being worth what it costs to take it. How much and how high, I guess...
January 31, 2003 at 5:10 pm
Possibly you could use Log Explorer from Lumigent, just got it installed at work, have not used enough to say for sure if it would do it or not. No...
January 31, 2003 at 5:07 pm
Tried stop/start the log reader. I think it reports last status, if not changed that is all you get.
Andy
January 31, 2003 at 10:28 am
Could be. Emailed Steve to check. Some days we use a LOT of bandwidth. We'll get back to you.
Andy
January 31, 2003 at 4:51 am
I'd be interested to hear as well. Tend to get tunnel vision between being a DBA kinda guy and running a SQL site too - I should get out more!
Andy
January 30, 2003 at 6:33 pm
BMStone,
Please refrain from flaming. If you have an issue that needs to be addressed, please contact me, Steve Jones, or Brian Knight. We work hard to keep the forums noise...
January 30, 2003 at 3:38 pm
We'll check. We're in the process of building a replacement server now, but there may be other factors making it slow right now.
Andy
January 30, 2003 at 2:25 pm
Viewing 15 posts - 2,596 through 2,610 (of 6,216 total)