Welcome to MSDN Blogs Sign in | Join | Help

Browse by Tags

All Tags » SQL Tips and Tr... » SQL Performance   (RSS)

Plan guides (plan freezing) in SQL Server 2005/2008

  SQL Server 2005   The plan guides were first introduced in SQL Server 2005.You may find detailed information about the plan guides in SQL Server 2005 here:   General information http://msdn.microsoft.com/en-us/library/ms187032(SQL.90).aspx

SQL I/O Error Message and its resolution

Starting with Microsoft SQL Server 2000 Service Pack 4 (SP4), SQL Server helps detect stalled and stuck conditions for database I/O reads and writes. When an I/O operation has been pending for 15 seconds or longer, SQL Server logs the following message
 
Page view tracker