Entries tagged with 'timeout' Articles and information on C# and .NET development topics

 'timeout' tag RSS

SQL Woes - Mismatched parameter types in stored procedures

Richard Moss sql | timeout | parameter no comments

A cautionary tale about performance issues that can arise when the types of parameters used in stored procedures don't match the types of underlying columns when such parameters are being used in WHERE clauses, causing implicit conversions and the 'Type conversion in expression (CONVERT_IMPLICIT()) may affect "CardinalityEstimate"' warning to be displayed in query plans.

Continue Reading