How is it possible to use Index Seek for LIKE %search-string% case?

EXEC dbo.USP_SAMPLE_PROCEDURE N'94'





EXEC dbo.USP_SAMPLE_PROCEDURE N'%94'

Lookin at XML plan

<ColumnReference Column="@Beginning" ParameterCompiledValue="N'94'" ParameterRuntimeValue="N'%94'" />

---

Best Regards,Uri Dimant SQL Server MVP, http://ift.tt/1iQ9JkR



MS SQL optimization: MS SQL Development and Optimization

MS SQL Consulting: Large scale of database and data cleansing

Remote DBA Services: Improves MS SQL Database Performance

SQL Server Integration Services: Business Intelligence