Welcome to MSDN Blogs Sign in | Join | Help

Browse by Tags

All Tags » SQL Best Practi... » SQL Service Packs   (RSS)
Wednesday, December 06, 2006 3:16 PM

How can I limit the number of reboots when applying hotfixes and the like to SQL Server and OS?

Avoiding reboots after applying a Service Pack or a hotfix to SQL is a big concern to our customers. In SQL 2005, we have made several enhancements to help you avoid a reboot after applying Service Packs and hotfixes. To learn about these enhancements,
Posted by sqlblog | 1 Comments
Thursday, September 21, 2006 10:42 PM

Why is a SPID blocking itself in sysprocesses? How is it possible?

After you apply SQL 2000 Service Pack 4, you might observe that a SPID is blocking itself, as reported in the output of sysprocesses. If your custom scripts/applications monitor blocking by relying on the output of sysprocesses column, they will start
Posted by sqlblog | 1 Comments
 
Page view tracker