Diagnose optimizer early termination in SQL Server plans, find cached timeouts with XML, and simplify queries using measured evidence.
The Columnstore Delta Store: Small Loads and Open Rowgroups
Inspect the columnstore delta store, distinguish rowgroup states, and choose load sizes or targeted compression after small loads.
SQL SERVER – Exploring PIVOT and UNPIVOT
The SQL Server PIVOT and UNPIVOT operators are powerful tools that provide an easy way to transform your data in SQL.
The Intricacies of T-SQL String Comparison: LIKE VS ‘=’
Let us learn The Intricacies of T-SQL String Comparison. In SQL, the way you compare strings can greatly impact the results of your queries.
SQL SERVER – Performance: Optimizing High Volume OR Conditions through TempTable
We explore an alternative approach when dealing with high volumes of ‘OR’ conditions in our SQL queries: the use of a TempTable.
SQL SERVER – A Comparison of CHARINDEX vs LIKE
In this post, we’ll explore a comparison between the use of CHARINDEX and LIKE in the WHERE clause, supported by real-world statistics.
Oversized varchar Columns and Inflated Memory Grants
Investigate oversized varchar declarations, compare sort memory grants, and narrow string columns safely without losing valid data.