TCP Storm in SQL Server
Beware of TCP storms in SQL Server, especially in SQL Server 2014 where they can cause a serious performance problem. Continue Reading
SQL Server
Excessive Context Switching due to TDS Encryption
TDS encryption can have a dramatic performance impact in SQL Server 2014 because of excessive context switching. The implementation was significantly improved in SQL Server 2016 and 2017. Continue Reading
SQL Server Extended Events Trace Overhead
Measuring Extended Events Trace overhead and correctly interpreting the trace information. Continue Reading
Cardinality Estimation for “MINUS” Operator
Mind inaccurate cardinality estimations when using MINUS operator in subqueries. Continue Reading
Bind Variable Peeking vs. Parameter Sniffing
Comparison of bind variable peeking in Oracle with parameter sniffing in SQL Server Continue Reading
Comparison of a Cardinality Estimate in Oracle and SQL Server
This blog post is a short observation on assumptions that Oracle and SQL server optimizers make for estimating cardinality of a rowset obtained after applying an equality predicate which contains different columns of the same table. Continue Reading
Index Organized Table vs. Clustered Index
Comparing efficiency of IOT in Oracle with Clustered Index in SQL Server. Continue Reading
SPN for SSRS
Troubleshooting Kerberos authentication in SSRS due to SPN Continue Reading
Disjunctive Subquery Optimization
Disjunctive subqueries are the subqueries which are applied to the or operator. Alternatively, these queries can be rewritten to use the union all operator which may be a more efficient way to retrieve the records from the database. This blog post compares the efficiency of SQL Server and Oracle optimizer when dealing with the transformations of disjunctive subqueries.
Continue Reading
Table Spool Performance Problem
Table Spool can degrade SQL Server performance. Continue Reading