Row versioning fundamentally changes how SQL Server handles read operations during write transactions. Instead of blocking, SQL Server can serve a previous version of the row. We enable row versioning in SQL Server by turning on READ_COMMITTED_SNAPSHOT ISOLATION (RCSI). In this post we will demonstrate blocking without row versioning and…
Learn about Writing SARGable Expressions in T‑SQL to maximize SQL Server performance and efficiency with your queries.
The restoration process of a SQL Server database passes through two phases: Restore and Recovery.
In late 2018, I recorded a series of videos for APRESS publishing on how to write T-SQL Queries. (I have linked to the O’Reilly website below.) There are four titles in the series with each title about 45 minutes in length. The first is how to write a T-SQL SELECT…
What is SQL? What is the difference between SQL the language and SQL the server?
What are the basics in writing a T-SQL SELECT? How to return columns and records from a table in SQL Server.
How to use the WHERE statement to filter records when the value is a number or integer data type in a T-SQL statement.
How to use the ORDER BY statement to sort records in a T-SQL statement in both ascending and descending order.
Restricting data by using Table Constraints in SQL Server. What are the different table constraints in SQL Server?
Learn about Transaction and Errors in SQL Server. Understand Auto-Commit vs Explicit Transactions for better error handling.