Columns and Records

In this post, we discuss what columns and records are in a SQL table including an explanation of objects and entities.

What is SQL?

What is SQL? What is the difference between SQL the language and SQL the server.

SQL Server Execution Model

How the SQLOS manages worker threads in the SQL Server Execution Model and the different wait queues in SQL Server to manage threads used by the CPU.

The OUTPUT Clause

How to use the output clause with Data Manipulation Language (DML) statements like INSERT, UPDATE, and DELETE.