Tag: Efficient Queries
Implicit Conversion Recommendation
Improve SQL Server performance by avoiding an implicit conversion in a search predicate.
Posted: September 30th, 2010 under Implicit Conversion, Query Optimization, SDR-Q36.
Tags: Analyze Execution Plans, Analyze Queries, Analyze Query Performance, Efficient Queries, Execution Plan, Improve Query Performance, Query Optimization, Query Tuning, SDR-Q36, SQL Server Performance
Comments: 2
Missing Join Predicate Recommendation
The ‘Missing Join Predicate’ recommendation (SDR-Q19) given by SQL doctor for a query that results in the cartesian product of two or more tables will help identify bottlenecks in TSQL to improve query performance.
Posted: September 23rd, 2010 under Missing Join Predicate, Query Optimization.
Tags: Analyze Execution Plans, Analyze Queries, Analyze Query Performance, Efficient Queries, Execution Plan, Improve Query Performance, Query Optimization, Query Tuning, SDR-Q19, SQL Server Performance
Comments: none
