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.
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 – Manage Database Size with DBCC SHRINKDATABASE and WAIT_AT_LOW_PRIORITY
In this blog post, we will explore the DBCC SHRINKDATABASE command and its options, focusing on the WAIT_AT_LOW_PRIORITY feature.
SQL SERVER – Steps to Identify with Odd and Even Rows
Sometimes, when working with SQL, you might need to do something special with odd and even rows in your table. This can be a bit tricky.