Microsoft has announced SQL Server 2012 service pack 2 is available earlier this week. Service packages are cumulative updates and upgrade all editions of SQL Server 2012. This service pack contains up to and including SQL Server 2012 Service Pack1 Cumulative Update 9 (CU9). Here is the list of the bugs which are fixed in SQL Server 2012 SP2.
If you are facing any of the following issues and have not installed any of the cumulative updates, you should indeed update to SQL Server 2012 SP2. On my personal development server, I have upgraded this SP2 and after a week’s testing, I am planning to roll it out to my production server.
I am very excited about the bug fix of Poor Performance when using table variables, as I had just talked about during my last presentation in India.
You can download SQL SQL Server 2012 from this download link.
Reference: Pinal Dave (http://blog.sqlauthority.com)