SQL Server optimizer just uses a cached plan, issue first
DBCC DROPCLEANBUFFERS
go
EXEC dbo.USP_SAMPLE_PROCEDURE N'%94'
And you will CI scan in both executions
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
No comments:
Post a Comment