| Author |
Topic |
|
RickD
Slow But Sure Yak Herding Master
3608 Posts |
 Posted - 2009-03-27 : 08:47:31
|
[praise]Don't usually do this, but I have to say congratulations to Microsoft for this functionality, it makes populating the fact and dim tables in data warehousing so much easier and has saved me weeks of work. This has got to be one of the best functions written for SQL in a long time.  Thank you again whoever onb the dev team thought this one up..  [/praise][rant]It nearly makes up for the waste of time that is Vista Ultimate 64 bit and the extra £150 I have just had to spend to go back to 32 bit simply because I can't find the problem and it keeps freezing my laptop (which gets kind of annotimng when it keeps happening ever hour or so). Tried turning things off one at a time to find the problem, but no joy.[/rant] |
|
|
robvolk
Most Valuable Yak
15732 Posts |
Posted - 2009-03-27 : 10:04:57
|
| Yeah, I gotta agree, I originally thought "Merge, OK, that's kinda handy" and then went to Itzik's PASS presentation, where he spent WAY too much time going over all the cool stuff you can do with it. Fortunately we're reaching a new design phase so I'm gonna push MERGE whereever I can.AFAIK MERGE is part of the ANSI SQL standard. |
 |
|
|
spirit1
Cybernetic Yak Master
11752 Posts |
Posted - 2009-03-27 : 10:23:14
|
| you just have to know that it doesn't solve the locking problem you had when doing if exists update lese insert type of stuff___________________________________________________________________________Causing trouble since 1980Blog: http://weblogs.sqlteam.com/mladenpSpeed up SSMS development: www.ssmstoolspack.com <- version 1.5 out! |
|
|
|
RickD
Slow But Sure Yak Herding Master
3608 Posts |
Posted - 2009-03-27 : 10:54:10
|
rob - I would..  Didn't realise it was ANSI standard though.spirit1 - I don't have locking problems currently, but will bear it in mind. |
|
|
|
cshah1
Constraint Violating Yak Guru
347 Posts |
Posted - 2009-03-29 : 13:43:03
|
| Although MERGE is part of ANSI SQL "NOT MATCHED BY SOURCE" clause is not part of the standard. It is a T SQL Extension. |
|
|
|
darkdusky
Aged Yak Warrior
591 Posts |
Posted - 2009-03-31 : 07:44:16
|
| I don't think you can credit MS with thinking it up.http://decipherinfosys.wordpress.com/2007/11/20/merge-command-in-sql-server-2008/ |
|
|
|
spirit1
Cybernetic Yak Master
11752 Posts |
Posted - 2009-03-31 : 07:46:28
|
well since it's ANSI standard it's not really them who thought it up  ___________________________________________________________________________Causing trouble since 1980Blog: http://weblogs.sqlteam.com/mladenpSpeed up SSMS development: www.ssmstoolspack.com <- version 1.5 out! |
|
|
|
robvolk
Most Valuable Yak
15732 Posts |
Posted - 2009-03-31 : 08:14:14
|
| Typically any feature added to the ANSI SQL standard has existed in some vendor's product for quite a while. |
|
|
|
SwePeso
Patron Saint of Lost Yaks
30421 Posts |
Posted - 2009-03-31 : 08:48:42
|
Too bad Microsoft didn't incorporate full functionality for Windowed Functions...
E 12°55'05.63"N 56°04'39.26" |
|
|
|
|
MERGE in SQl 2008 is excellent..