Viewing 15 posts - 55,186 through 55,200 (of 59,078 total)
Since I don't use DTS or SSIS for this type of stuff... what happens to the data that caused the error? Can the error handler be made to save the...
September 5, 2007 at 7:52 am
Heh... thanks Lowell ![]()
September 5, 2007 at 7:50 am
Aye... nicely done, Lowell... and, I think you'll really like this, as well ![]()
Just in case someone can't use xp_CmdShell, there's a little known...
September 5, 2007 at 7:30 am
That's kinda why I use BCP for this type of stuff... you can program BCP to survive just about any error and squirrel the "bad" rows in a separate file...
September 5, 2007 at 6:55 am
Hust for a point of reference... we set TempDB to be 9 gig on bootup.
September 5, 2007 at 6:50 am
You are correct... things are going to get a little complex because you need a query to build a dynamic query from Master.dbo.SysServers.
September 5, 2007 at 6:33 am
For more reasons than I can count, you will likely regret the day that you used Text or NText if there's any chance of ever needing to edit the column.
Creating...
September 5, 2007 at 6:25 am
Ganapathi,
It's good that the code works... but do you know WHY it works? ![]()
September 5, 2007 at 6:20 am
The only thing I can see that might be doing this is your 11PM DB Maintenance job... check it and see if you are "regorganizing" the data... there's at least...
September 5, 2007 at 6:04 am
You bet... thanks for the feedback...
September 4, 2007 at 10:19 pm
We still don't have a clue how long this job may last, Bill. ![]()
September 4, 2007 at 10:11 pm
Mary,
Lowell's code is great but, as he said, there's a bit of a performance problem... takes about 4 and a half minutes to return 100,000 rows. The following function is about...
September 4, 2007 at 9:17 pm
The problem is that c.Text is an NVARCHAR column of 4000... don't forget that this is UniCode and contains 2 bytes per visible character so it's really 8k if the...
September 4, 2007 at 6:02 pm
Karthik,
You didn't believe me? ![]()
http://www.sqlservercentral.com/forums/shwmessage.aspx?forumid=8&messageid=395872#bm396072
September 4, 2007 at 5:36 pm
Viewing 15 posts - 55,186 through 55,200 (of 59,078 total)