Few even asked me to build a video on this topic. Hence, I decided to make a Function in the WHERE Clause – SQL in Sixty Seconds 201.
SQL SERVER – Ins and Outs of Online Index Operations
I recently talked about Ins and Outs of Online Index Operations with my clients during the Comprehensive Database Performance Health Check.
SQL SERVER Performance: Functions in WHERE Clause
Functions in WHERE clause can hurt performance. I compare a query using YEAR() with one using direct column references on AdventureWorks, plus indexes.
SQL Server Maintenance Techniques: A Comprehensive Guide to Keeping Your Server Running Smoothly
This comprehensive guide explore into some essential maintenance techniques and best practices to ensure your SQL Server deployment.
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.
Case-Insensitive Unique Constraints in a Case-Sensitive Database
Enforce case-insensitive unique user names in a case-sensitive database using an indexed computed column with an explicit collation.
SQL SERVER – Understanding Incremental Statistics
Understanding incremental statistics: since SQL Server 2014, statistics can update only the changed subsets instead of a costly full scan on large tables.