How to use the output clause with Data Manipulation Language (DML) statements like INSERT, UPDATE, and DELETE.
What is the difference between the DELETE, TRUNCATE, and DROP statements in T-SQL?
How to use IDENTITY columns in a table. An IDENTITY field is very similar to an auto-number field, where the number will automatically be added as each record is inserted.
How to use an INSERT statement to add records to a table in SQL Server. We will begin with just a simple INSERT statement that will add one row into the table.
How to read Heap and Clustered Index table operators in a SQL Server Execution Plan. One way of determining if a table is structured as a Heap or a Clustered Index is to look at the table operators from the Execution Plan.
What is the data manipulation language (DML)? How to write the INSERT, UPDATE, and DELETE statements in T-SQL.
Heaps vs Clustered Indexes and how tables are structured and data is stored in SQL Server. Data rows from a table are stored in the data pages in either an unsorted order (Heap) or a sort order (Clustered Index).
Data Pages and Extents in SQL Server and how data is stored in SQL Server. Data records are physically stored in 8kb data pages on the hard drive.
How SQL Queries are processed by the Relational Engine. Parsing, Resolving, Optimizing, Compiling, and Executing to return SQL Sets.
A closer look at the Serializable Transaction Isolation Level and how it could prevent Phantom Reads concurrency issues in SQL Server.