This article provides an overview of the self join in SQL, as well as a basic example.
SQL Natural Join
This article provides an overview of the natural join in SQL, as well as some basic examples.
SQL Full Join
This article provides an overview of the FULL JOIN in SQL, as well as some basic examples.
SQL Cross Join
This article provides an overview of the CROSS JOIN in SQL, as well as some basic examples.
SQL Left Join
This article provides an overview of the LEFT JOIN in SQL, as well as some basic examples.
SQL Inner Join
This article provides an overview of the INNER JOIN in SQL, as well as some basic examples.
SQL Right Join
This article provides an overview of the RIGHT JOIN in SQL, as well as some basic examples.
Check the Space Used by a Table in SQL Server
SQL Server has a system stored procedure called sp_spaceused that enables you to check the size of a table in a database.
You can use it to check the number of rows, disk space reserved, and disk space used by a table, indexed view, or Service Broker queue in the current database, or the disk space reserved and used by the whole database.
SQL Alias Explained
The SQL alias is a nice little feature of SQL that allows you to write more concise code and create column names when no column name exists.
There are two SQL alias types; column aliases, and table aliases. In this article, I provide an overview of both.
Switch-In a Partition in SQL Server (T-SQL)
In SQL Server, you can switch partitions in and out of a partitioned table.
You can do this with the ALTER TABLE statement. Basically, it goes like this:
ALTER TABLE OldTable
SWITCH TO NewTable PARTITION xThis switches the partition for OldTable into partition x of NewTable (where x is the partition number).