Category: DBMS

Database Management Systems

Switch-Out a Partition in SQL Server (T-SQL)

Posted on by Ian

In SQL Server, partition switching allows you to load large amounts of data in or out of a table very quickly. This saves you from having to run delete or insert statements, and can be very useful when working with large data sets.

You can use the ALTER TABLE statement to switch a partition in or out of a table.

To switch a partition out of a table, the code goes like this:

ALTER TABLE Table1
SWITCH PARTITION x TO Table2

This switches partition x from Table1 to Table2 (where x is the partition number).

Continue reading →

SQL Server CASE Expression

Posted on by Ian

In SQL Server, the T-SQL CASE expression is a scalar expression that returns a value based on conditional logic. It evaluates a list of conditions and returns a value, based on the outcome of those conditions..

In some ways, the SQL Server CASE expression is similar to IF...ELSE. However, CASE allows you to check for multiple conditions, whereas IF...ELSE doesn’t.

Continue reading →

Install PostgreSQL on Ubuntu 20.04

Posted on by Ian

Did you know that PostgreSQL is available in all Ubuntu versions by default?

Yes, that means that your Ubuntu 20.04 installation probably already has a PostgreSQL package sitting there waiting for you to install it.

And you can install it with one command, which I’ll show you below.

But what if you prefer to run the latest version of Postgres instead? Well, I’ll also show you how to install that. Installing the latest version is almost as easy as installing your local package.

Continue reading →

Install PostgreSQL on Ubuntu 18.04

Posted on by Ian

The following steps demonstrate how to install PostgresSQL on Ubuntu 18.04.

There are a couple of ways to go about installing Postgres on Ubuntu.

But before we start jumping in and installing it, did you know that by default, PostgreSQL is already available in Ubuntu 18.04?

So one option is to go right ahead and use the version that’s already included with Ubuntu.

But unless you have reason not to, you will probably want to run the latest version of PostgreSQL, in which case you’ll want to download and install the latest version.

This tutorial covers both options.

Continue reading →