A SQL join is where you run a query that joins multiple tables.
This SQL joins tutorial presents basic examples of SQL joins, as well as an introduction to the various join types.
Continue readingBasic SQL Queries
This article contains examples of basic SQL queries that beginners can use to retrieve data from their databases.
Continue readingSQL DELETE for Beginners
This article contains basic SQL DELETE statements that beginners can use to delete data from their database tables.
SQL UPDATE for Beginners
This article contains basic SQL UPDATE statements that beginners can use to update data in their database tables.
Return All Rows From a Specific Partition in SQL Server (T-SQL)
When you create a partitioned table in SQL Server, you specify which values go into each partition.
This is done when you create the partition function. When you create the partition function, you specify boundary values, which determine which values go into each partition.
Once you’ve created your partitioned table, and you’ve inserted data, you can run a normal SELECT statement to return data, just as you would with a non-partitioned table (actually, even non-partitioned tables have one partition).
But did you know that you can also specify which partition you want data from?
You can do this with the help of the $PARTITION system function in your WHERE clause.
Find the Partitioning Column for a Partitioned Table in SQL Server (T-SQL)
In SQL Server, you can use the following query to determine the partitioning column for a partitioned table.
Continue readingHow to Fix “ALTER TABLE SWITCH statement failed”
If you’re getting error 4939 while trying to switch a partition in SQL Server, it’s probably because you’re trying to switch to a partition that uses a different filegroup.
One of the requirements of switching partitions is that both the source table or partition, and the target table or partition, must be located in the same filegroup.
Continue readingSQL Self Join
This article provides an overview of the self join in SQL, as well as a basic example.
Continue readingSQL Natural Join
This article provides an overview of the natural join in SQL, as well as some basic examples.
Continue readingSQL Full Join
This article provides an overview of the FULL JOIN in SQL, as well as some basic examples.