Service packs are very critical and important. It is very important from product upgrade & bug fixing point of view.
Regular upgrades to your system with latest releases help you in :-
· Continued Support
· Resolves Problems
· New Features
Microsoft has recently released SQL Server 2008 R2 service packs. Please note SQL Server 2008 R2 and SQL Server 2008 are different versions & this release is for SQL Server 2008 R2. It will not work on SQL Server 2008 but will work only on SQL Server 2008 R2. If you are installing fresh SQL Server 2008 R2 or having SQL server 2008 R2 RTM or SQL server 2008 R2 SP1 or any other CUs installed , you just have to download and install SP2 and there is no need to install mediator releases. Service pack SP2 will contain all releases & upgrades before SP2 including SP1 upgrades.
List of Bug Fixes : http://support.microsoft.com/kb/2630458
You can download : http://www.microsoft.com/en-in/download/details.aspx?id=29848