Welcome to MSDN Blogs Sign in | Join | Help

Browse by Tags

All Tags » compilation   (RSS)
Wednesday, November 18, 2009 9:32 AM

Changed behaviour of OPTION RECOMPILE syntax in SQL Server 2008 SP1 cumulative update #5

On Monday we released Cumulative update package 5 for SQL Server 2008 Service Pack 1, under KB975977 . Contained in this was a very interesting fix to a long running issue with regards to the option recompile syntax and its changed behaviour in SQL Server
Posted by grahamk | 0 Comments
Wednesday, February 11, 2009 7:43 PM

Compilation Bottlenecks – Error: 8628, Severity: 17, State: 0. – Part 2

[follow up to RESOURCE_SEMAPHORE_QUERY_COMPILE diagnosis] Last week I wrote about the initial diagnosis of this problem, and now here's the follow up. So if you remember we had a DBCC MEMORYSTATUS and a load of other PSSDIAG data collected and we knew
Posted by grahamk | 1 Comments
Tuesday, February 03, 2009 3:33 PM

SQL Server Compilation Bottlenecks – Error: 8628, Severity: 17, State: 0. – Part 1

[alternative title: Memory Troubleshooting using DBCC MEMORYSTATUS] The following samples are taken from a live problem I was working on for most of last week. The steps might well help you resolve an occurrence of the above error, but the methodology
Posted by grahamk | 2 Comments
 
Page view tracker