SQL Server Education (by the geeks, for the geeks)
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 MoreHi Friends, Last week, I blogged about Trace Flag 4136: https://www.sqlservergeeks.com/sql-server-did-you-know-about-trace-flag-4136/ and bunch of other posts related to parameter sniffing: https://www.sqlservergeeks.com/sql-server-using-optimize-for-query-hint/ https://www.sqlservergeeks.com/blogs/AmitBansal/sql-server-bi/8/forceseek-hint-in-sql-server-2008-part-i https://www.sqlservergeeks.com/sql-server-forceseek-hint-in-sql-server-2008-part-ii-working-with-parameter-sniffing/ I got a question from reader asking me …
SQL Server OPTIMIZE FOR UNKNOWN to disable parameter sniffing at query level Read More