DBCC UPDATEUSAGE is a command available in SQL Server that is used to update the page and row count metadata for database objects.
Gherkin Language Beyond English: Keywords in Other Languages
The Gherkin language is not limited to English. This post shows the language header, the same scenario in English, French and Hindi, a keyword table, why a team gains from writing in its own language, and the limits found when the keywords are mixed.
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.
Office Hours with Special Host – Brent Ozar
It was a treasure trove of learning experiences. Today, we will discuss Office Hours with Special Host – Brent Ozar.
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.
CTE or Temp Table: Choosing Where an Intermediate Result Lives
A CTE is a name, not a saved result. Build both versions on 20,000 rows, compare the plans, and see why the answer is never always one or the other.