How do you sum values for each group without GROUP BY and still keep every row? Here is how SUM with OVER and PARTITION BY answers a reader’s question.
SQL SERVER – Performance Comparison IN vs OR
Which query runs faster, one with IN or one with OR? Here is my performance comparison IN vs OR on AdventureWorks, and both turn out equal.
SQL SERVER – How to Fix CONVERT_IMPLICIT Warnings?
CONVERT_IMPLICIT warnings are one of the most common performance issues I find in health checks. Here is how to find them in your queries and how to fix them.
How to Generate Fibonacci Series for the First 1000 Values? – Interview Question of the Week #174
How to generate Fibonacci series for the first 1000 values? Most answers online stop near 70 or 80 values because the numbers get too big. Here is mine.
How to Search Special Characters in Table Column? – Interview Question of the Week #172
Can you find [blog.] in a column with LIKE? Most people I interview cannot. Here is how to search Special Characters in a table column the right way.
SQL Server – Performance Comparison of Function Trim and LTRIM(RTRIM)
A workshop question: what is the performance comparison of function TRIM and LTRIM(RTRIM) in SQL Server? Here are the test results.
SQL SERVER – Split Comma Separated Value String in a Column Using STRING_SPLIT
STRING_SPLIT arrived in SQL Server 2016 but is still underused. Here is how to split comma separated value string in a column into rows, quickly.