I keep eyes on cumulative updates. I keep a watch that which one released and what they are impacting. If you are facing issues with SQL Server – Comulative Updates may have a solution for you. I suggest to install CU on Development Server first and later roll out the changes to production servers.
Here are the details for the latest CU released.
SQL Server 2012
CU#6 KB Article: http://support.microsoft.com/kb/2728897
SQL Server 2008 R2 SP2
CU#5 KB Article: http://support.microsoft.com/kb/2797460
SQL Server 2008 R2 SP1
CU#11 KB Article: http://support.microsoft.com/kb/2812683
I strongly suggest you go to the above links and check what are different kinds of fix it involves. Every single time I look at the improvement and I feel that how did I run SQL Server without those fixes.
Reference: Pinal Dave (http://blog.SQLAuthority.com)