Wednesday, December 3, 2014

Query In SP runs 10x slower than straight query - NOT Parameter Sniffing Issue

Looks like exactly the same, just wonder SET STATISTICS TIME ON also shows same results?


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