Viewing 15 posts - 46,261 through 46,275 (of 59,062 total)
Just to be sure... creating a view doesn't necessarily improve any performance and, if it's done badly, can be quite the performance hog.
December 30, 2008 at 4:59 am
Good thread. I like the sp_MakeWebTask trick.
December 30, 2008 at 4:55 am
Adi Cohn (12/30/2008)
December 30, 2008 at 4:50 am
Heh... so which is it that you actually want? A running total, or a current balance for new rows... there is a slight difference.
December 30, 2008 at 4:42 am
GilaMonster (12/30/2008)
Jeff Moden (12/30/2008)
Seems like the intent of Microsoft was to make things easier for folks that don't know how to do it in T-SQL...
I don't agree with that....
December 30, 2008 at 4:37 am
Like I said, I'm curious... how many rows in the Course Reference table and any chance of you attaching the first 10 rows of the 10 million row file you...
December 30, 2008 at 4:34 am
A cursory overview (no pun intended) says that this is a hierarchical sproc and it uses a cursor and a whole lot of RBAR... lord only knows what the sprocs...
December 30, 2008 at 1:19 am
Heh... ya know? Thanks for the feedback, Jeffrey... Seems like the intent of Microsoft was to make things easier for folks that don't know how to do it in...
December 30, 2008 at 1:13 am
I was also looking at today's article on SSIS and what I think is a fairly simple import...
http://www.sqlservercentral.com/articles/SSIS/64766/
All I can say is "Good Grief"... it took this person a couple...
December 30, 2008 at 12:24 am
You'd have to shorten the lines in the code box you made... but you're ok.
December 30, 2008 at 12:13 am
I'm curious... how many rows in the Course Reference table and any chance of you attaching the first 10 rows of the 10 million row file you imported? I'd...
December 29, 2008 at 11:59 pm
Bob Hovious (12/29/2008)
I think the OP has abandoned us anyway. Don't know whether...
December 29, 2008 at 11:33 pm
With the limited information I have from you, the best I can do is what I've already done. Perhaps it's time for you to post the actual update query.
December 29, 2008 at 11:30 pm
Would you tell us what the error is, please?
December 29, 2008 at 11:25 pm
Viewing 15 posts - 46,261 through 46,275 (of 59,062 total)