SLI has upsides and downsides - it's expensive to get 2 cards, typically you have to get 2 that are identical down to the the BIOS, and it is usually beyond the capacity of an average power supply unit. It doesn't provide a speed benefit with all programs.
When working it does give a 30%-70% performance boost on graphics power.
ATI's equivalent X-Fire (Crossfire) is just being introduced, and is much the same conept as SLI, except for nVidia cards. Whether or not it's really technically better or cheaper remains to be seen.