Suboptimal Sort Calculation
Beware of the suboptimal sort cost calculation in SQL Server. Comparison with Oracle included. Continue Reading
SQL Server
Do You Know Your Object-Relational Mapper’s Overhead?
A call to ORM API can comprise of much more than a database call. Its overhead can be measured. Continue Reading
Comparing TSQL and PL/SQL Performance
Why Oracle outperforms SQL Server Continue Reading
Microsoft Azure SQL Server CPU Performance
Comparing the performance of different MS Azure virtual CPU core configurations. Continue Reading
SOS_SCHEDULER_YIELD waits during low CPU utilization
SQL Server OS scheduler unexpectedly throttles the load which decreases the throughput and increases the response time variability. Continue Reading
TDS Encryption Overhead
Are you aware of your TDS encryption overhead? It’s often negligible, but your mileage may vary depending on the cipher suite. Continue Reading
Correlated Subqueries in the SELECT Clause (2)
Examples where Oracle optimizer doesn’t unnest subqueries in the SELECT clause Continue Reading
Correlated Subqueries in the SELECT Clause
How Oracle and SQL Server optimize correlated subqueries in the SELECT clause with an example how to manually optimize such queries for Oracle. Continue Reading
Breakpointing SQL Execution with WinDbg
Debugging SQL Server with WinDbg Continue Reading
Which Cipher Suite is being used for TDS Encryption?
Tracing TCP to find out the cipher suite which is being used for TDS encryption Continue Reading