Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
inbs
Aged Yak Warrior
860 Posts |
 Posted - 2009-05-03 : 14:32:47
|
| In according this method, what is maximal rows i can use by this way?[url]http://vsteamsystemcentral.com/cs21/blogs/applied_business_intelligence/archive/2007/05/21/ssis-design-pattern-incremental-loads.aspx[/url]he wrote this line:For performance with large amounts of data, you will want to employ set-based updates instead.what is other way, what is mean "set-based updates" ? |
|
|
SwePeso
Patron Saint of Lost Yaks
30421 Posts |
Posted - 2009-05-07 : 02:08:11
|
UPDATE Table1SET Done = 1The other method is using a cursor and update one record at a time.
E 12°55'05.63"N 56°04'39.26" |
 |
|
|
inbs
Aged Yak Warrior
860 Posts |
Posted - 2009-05-07 : 02:52:04
|
| his method use a curser(in a link)?if i have 1M Rows ,should i use his way? |
|
|
|
SwePeso
Patron Saint of Lost Yaks
30421 Posts |
Posted - 2009-05-07 : 04:28:41
|
With one million records, you should not be using a cursor.Your coffee would get cold before update is done.Depending on your log file settings, you could do the update in one statement, or divide it into several smaller batches but still set-based.
E 12°55'05.63"N 56°04'39.26" |
|
|
|
inbs
Aged Yak Warrior
860 Posts |
Posted - 2009-05-07 : 05:56:01
|
| peso i think that you dony understand my question:1.By the link , is the right way to build if i have 1M rows to update?2.By the link, is set-based or cursor?thanks |
|
|
|
SwePeso
Patron Saint of Lost Yaks
30421 Posts |
Posted - 2009-05-07 : 06:00:17
|
The link above uses a statement likeUPDATE Table1 SET Col1 = 1 WHERE Col2 = ?That would only update one record at a time as a cursor would.
E 12°55'05.63"N 56°04'39.26" |
|
|
|
inbs
Aged Yak Warrior
860 Posts |
Posted - 2009-05-07 : 07:09:29
|
| thanks,so,i use UPSERT |
|
|
|
|
|
|
what is maxmial row ?