Viewing 15 posts - 6,631 through 6,645 (of 18,926 total)
BCP will eat 1 M rows like it's nothing. If you really are having issues with the import (like users can't work), then I'd redo it.
April 28, 2011 at 10:11 am
It just does error out (by design). You need to use dynamic sql.
I've had to do something similar for a website. I simply concatenated the right DB name...
April 28, 2011 at 9:49 am
You either need to use full dynamic sql or solve the problem differently.
What are you trying to accomplish exactly?
April 28, 2011 at 9:32 am
Thanks Albaza.
I'll put in an official request for my toy DB and I'll go from there.
We have a test environement but I can't overwrite it at will :crazy:.
April 28, 2011 at 9:21 am
ALZDBA (4/28/2011)
Since you aim for minimal prod sys interference .... let's keep it simple.
How about lightweight tracing just for the the sp_prepare and sp_execute statements (of course...
April 28, 2011 at 8:51 am
Rajat Jaiswal-337252 (4/27/2011)
homebrew01 (4/26/2011)
Ninja's_RGR'us (4/26/2011)
The best alternative is to delete in smaller chunks and run tlog backups within the loop.
Yes, that is how I do it, with no problems. ...
April 28, 2011 at 8:07 am
Just got a reply from Adam and there's no way to use his script to do what I need (unless I'm prepared to start an infinite loop and kill it...
April 28, 2011 at 8:06 am
Tx, I had forgotten about that script... That is definitely something that could help!
Actually this seems like a better download link :
April 28, 2011 at 7:49 am
Jack Corbett (4/28/2011)
April 28, 2011 at 7:15 am
Jack Corbett (4/28/2011)
Yeah, there might be too much load, but I thought it might be an option and more lightweight than a trace.
I've tested that option in another project and...
April 28, 2011 at 7:02 am
Jack Corbett (4/28/2011)
Yeah. But you could get SHOWPLAN_XML and I think you can do some pretty complex filtering. Might be worth looking at.
Similar issue here... prod server with...
April 28, 2011 at 6:44 am
Ya and assuming you only have 16 months of data in there, that means you're likely flushing out 150 to 250 million rows.
At that point I'd consider partitioning and simply...
April 28, 2011 at 6:41 am
I don't see anything usefull in there in the events list. The closest thing might be cache_insert.
Anything else would scare the life out of me... getting millions of rows...
April 28, 2011 at 6:37 am
My other challenge here is that when I run a report or whatever so that I can see what's going on. The statements seem to already have been prepared...
April 28, 2011 at 6:07 am
Brandie Tarvin (4/28/2011)
Ninja's_RGR'us (4/27/2011)
While we're at it... is there any way (other than a trace) to see all the queries run by a session between 2 dates?
Not by a trace?...
April 28, 2011 at 5:59 am
Viewing 15 posts - 6,631 through 6,645 (of 18,926 total)