Viewing 15 posts - 2,251 through 2,265 (of 6,216 total)
Dont know if it will help, we have this:
http://www.sqlservercentral.com/columnists/jwiner/20010422114459_1.asp
Andy
April 17, 2003 at 1:47 pm
Agreed. You could load it up and execute it, but assuming you have to know in advance what the params are - and what to pass in - why not...
April 17, 2003 at 11:38 am
You can also use openrowset. Or return it as XML, then use OpenXML.
Andy
April 17, 2003 at 11:36 am
All of the issues I ever saw with the upgrade were related to the stats changing. Run a full index rebuild (maintenance plan is easiest way to do it), then...
April 17, 2003 at 11:35 am
Cant think of much else. With that many inserts you're going to be creating a lot of pages, doing a lot of logging, so it would help to have the...
April 17, 2003 at 11:34 am
Agree with all that, though I havent dont specific timings on file sizes. Not a bad idea to consider storing the blobs in a separate db, though that brings up...
April 17, 2003 at 11:32 am
I think CDONTS is right. Dont have code here, but we have an app at work that handles email from applications that goes out via SMTP. Seems like there are...
April 17, 2003 at 11:29 am
Haven't run into that, though I don't use merge that often. Do you have other subscribers to the same pub and are they working ok? How about turning on the...
April 17, 2003 at 8:15 am
I agree bulk insert or bcp probably makes sense - if your app works that way. If you're doing 100,000 single record inserts, harder to manage. Might want to consider...
April 17, 2003 at 8:12 am
Probably can. We're planning a forum upgrade, we'll add this to the list of ideas that we need to review/implement when we do it.
Thanks for the suggestion!
Andy
April 17, 2003 at 8:07 am
I agree with all that. Using @@identity (or scope_identity()) isn't that much to manage and if you work smartly, can all be done on the server instead of multiple round...
April 17, 2003 at 6:15 am
Insert the data into a temp table along with an identity column, then select back whichever set of rows you need using the ident to determine the range.
Andy
April 17, 2003 at 6:13 am
April 16, 2003 at 1:17 pm
Maybe the maintenance plan is running the shrinkdb first?
Andy
April 16, 2003 at 1:16 pm
Viewing 15 posts - 2,251 through 2,265 (of 6,216 total)