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 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.
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 – 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.
The Locks, Blocks, and Deadlocks of SQL Server: Unraveling the Knots
SQL Server is no exception. However, it often leads to three common phenomena – locks, blocks, and deadlocks. SQL Diagnostic Manager SQL Server
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.