Viewing 15 posts - 3,376 through 3,390 (of 6,216 total)
Permissions default to dbowners and sysadmins, you just have to grant others access.
Andy
August 26, 2002 at 6:45 pm
Server side cursors (different from TSQL cursors) dont get used very often. They can be more efficient at times since you only pull x records to the client, even though...
August 26, 2002 at 5:14 pm
August 26, 2002 at 2:25 pm
There is a tool call SQL Load Simulator (or something close to that) on the BORK Resource Kit, lets you run a script on a lot of concurrent threads. Great...
August 26, 2002 at 2:25 pm
Havent seen anything like this and would be surprised if changes via EM would cause it. Definitely install SP2, I dont think anyone has had any problems with it and...
August 26, 2002 at 2:23 pm
It will work, you'll have to adjust permissions on it though. Since Outlook is locked down once you apply any of the newer Office service packs we've moved to CDO...
August 26, 2002 at 2:22 pm
I didnt realize you could create an extended proc in pure VB, thought it had to be C?
Andy
August 26, 2002 at 2:20 pm
Gotcha. Couple other notes. One is I hate to see code without error handling. Another is..I dont see where you are setting your connection to nothing, just closing it? Finally,...
August 26, 2002 at 2:19 pm
Linked servers are the usual way, could set up a script to add them to the sandbox, either using a sql login or the NT user (requires delegation I think?).
Of...
August 26, 2002 at 6:28 am
Interesting. For me it would be easier to read if you broke up the source code and put your comments/discussion just above the pertinent code. Scrolling up/down isnt fun. Thats...
August 26, 2002 at 6:09 am
Interesting. Good to see some content that pushes the envelope!
Andy
August 26, 2002 at 6:03 am
It might be documented, dont remember seeing it. I'll try to look through the MDAC to see what is there.
Andy
August 24, 2002 at 6:57 pm
1.6...or even 6 million rows isnt all that much. Definitely need to look at the query plan and hardware performance.
Andy
August 24, 2002 at 6:54 pm
Networks usually have the capacity to handle it. I'd guess(!) most are 100m switched these days. Now if you're going across T1 or slower, might want to reconsider.
Andy
August 24, 2002 at 6:52 pm
Have to agree about the Profiler thing, logging to a table can hurt performance, but let ME decide!
On the sandbox thing, we have a simiar situation where I work. We...
August 24, 2002 at 8:07 am
Viewing 15 posts - 3,376 through 3,390 (of 6,216 total)