Tag: query tuning
SQL Server Query Tuning – Serious SQL Fun
Share it if you like it!
SQL Server Query Tuning – Serious SQL Fun Read MoreSET STATISTICS PROFILE ON
For example, in the above plan (zoomed out), it’s tedious to figure out where cardinality estimation has gone bad. You hover the mouse cursor over every arrow to see the numbers …
SET STATISTICS PROFILE ON Read MoreSQL Server Implicit Conversion
Hi Friends, Are SQL Server Implicit Conversions expensive? Yes, they are! Not only does a SQL Server Implicit Conversion takes extra CPU, it can also cause loss of precision or fail …
SQL Server Implicit Conversion Read MoreSQL Server – Did you know about Trace Flag 4136 ?
Hi Friends, Parameter Sniffing, in general, is a good thing and your queries can benefit from that. Here are some of my blogs posts that you can read to get some …
SQL Server – Did you know about Trace Flag 4136 ? Read More