What is the best practice for decide to upgrade MS SQL Database service Pack.
Hi, I think for upgrade MS SQL Service pack we can check the service pack fix and decide for upgrade, Is this correct approach or always we should keep product latest service pack. My concern is only here to make mine database service more secure and best performance. Is there any disadvantage of keep latest service pack? Is any financial investment involving in upgrade the latest service pack that we have to pay Microsoft for upgrade product service pack?
It is not unknown for service packs to introduce new bugs, so whilst it is a good approach to keep up with the latest service packs for security and performance and stability, you should always test the service pack on a dev or test version of your database/application/code, just like you would with ANY change. To answer your financial question - no, as long as you have paid for the licence for the product initially, then service pack updates are free.