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    Description of sp_create_plan_guide http://msdn.microsoft.com/en-us/library/ms179880(SQL.90).aspx   This feature can be useful when you are trying to enforce the optimizer using a specific execution…


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 in the SQL errorlogs:   SQL Server has encountered %d occurrence(s) of…