Using GROUP BY and HAVING
In this post, we discuss how to use the GROUP BY and HAVING clause in a T-SQL statement and how to use them with aggregate functions.
Deardurff
Tables and Relationships
Understanding the difference between Parent Tables and Child Tables and the difference between Primary Keys vs Foreign Keys.
Creating Table Relationships
This demonstration will walk through how to create table relationships and foreign key constraints using SQL.
SQL Statement Categories
There are four main categories of statements used when writing T-SQL. What are the differences between each of these categories?
Delete vs Truncate vs Drop
What is the difference between the DELETE, TRUNCATE, and DROP statements in T-SQL?
The OUTPUT Clause
How to use the output clause with Data Manipulation Language (DML) statements like INSERT, UPDATE, and DELETE.
Troubleshooting Waiting Tasks
In this post, we will discuss Dynamic Management Objects (DMO’s) used to troubleshoot for Waiting Tasks in SQL Server.
Table Structures in SQL Server
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).
Execution Plans – Table Operators
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 are Transactions?
The ACID properties of SQL Transactions, What are the different ACID properties of a transaction how they ensure that data is Atomic, Consistent, Isolated, and Durable.