I just moved my database over to SQL Server 2012 last month from a shared SQL 2005 box maintained by someone else. It took awhile but now everything is up and running smoothly. Should I now apply SQL Server 2012 Service Pack 1 or leave things alone?
I'm not real familiar with maintaining a SQL Server, so I'm reluctant to install a major update with things running well. Only thing I've noticed is that it tends to roll forward a bunch of transactions if I reboot in the evening, so I'm guessing it is slow to clear the buffer cache. Not sure this is a problem though. Any insight would be appreciated.