SQL Server Query: Fast with Literal but Slow with Variable

by

Probably it is because in the parameter case, the optimizer cannot know that the value is not null, so it needs to create a plan that returns correct results even when it is. If you have SQL Server 2008 SP1 you can try adding OPTION(RECOMPILE) to the query.

More Related Contents:

  1. Which are more performant, CTE or temporary tables?
  2. Using merge..output to get mapping between source.id and target.id
  3. What do Clustered and Non-Clustered index actually mean?
  4. How to add Active Directory user group as login in SQL Server
  5. Why use the INCLUDE clause when creating an index?
  6. How to set a default value for an existing column
  7. SQL Server pivot vs. multiple join
  8. LIKE vs CONTAINS on SQL Server
  9. An attempt was made to access a socket in a way forbidden by its access permissions
  10. How do I find a stored procedure containing ?
  11. SQL Server GUID sort algorithm. Why?
  12. Why is a UDF so much slower than a subquery?
  13. Does the order of columns in a WHERE clause matter?
  14. An attempt to login using SQL authentication failed
  15. SQL Server, the misleading XLOCK & optimizations
  16. How to create the linked server for SQL Server 2008 where we have the database from 2000 and 2005
  17. How to find SQL Server running port?
  18. SQL Server 2008 – How do i return a User-Defined Table Type from a Table-Valued Function?
  19. Changing SQL Server collation to case insensitive from case sensitive?
  20. SQL Server SELECT LAST N Rows
  21. What’s the best way to store co-ordinates (longitude/latitude, from Google Maps) in SQL Server?
  22. Database design: Calculating the Account Balance
  23. Which is quicker COALESCE OR ISNULL?
  24. Instead of trigger in SQL Server loses SCOPE_IDENTITY?
  25. INFORMATION_SCHEMA vs sysobjects
  26. Merge multiple rows into a single row
  27. What are row, page and table locks? And when they are acquired?
  28. Error converting data types when importing from Excel to SQL Server 2008
  29. CHECKSUM and CHECKSUM_AGG: What’s the algorithm?
  30. Implementing one-to-zero-or-one relation in SQL Server

Leave a Comment