Welcome to MSDN Blogs Sign in | Join | Help

November 2009 - Posts

Friday, November 13, 2009 12:43 PM

Parameter gets converted in execution plan, when you explicitly define a different datatype for the parameter

Consider this scenario: You are trying to identify why a query like this is performing poorly: UPDATE table SET column1 = 0 WHERE table .column2 = @Parameter Where the @Parameter is explicitly specified as datatype VARCHAR(10) and the column2 is defined
Posted by John Daskalakis | 0 Comments
Friday, November 13, 2009 12:19 PM

Msg 7399 – OLE DB provider “MSDASQL” - The provider reported an unexpected catastrophic failure

Consider this scenario: - You have setup a linked server by using the MSDASQL provider - You are sometimes getting this error: Msg 7399, Level 16, State 1, Line 1 The OLE DB provider "MSDASQL" for linked server "XXXXXX" reported an error. The provider
Posted by John Daskalakis | 0 Comments
 
Page view tracker