Tag: mssql

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 →

Change the Priority of an Account within a Database Mail Profile (SSMS)

Posted on by Ian

Here, I demonstrate how to change the priority of a Database Mail account within a profile in SQL Server using the SQL Server Management Studio (SSMS) graphical user interface.

If you want to see how to do it using T-SQL, see Change the Sequence Number of an Account in Database Mail (T-SQL).

The priority and the sequence number are the same thing (when you change it with T-SQL you use the @sequence_number parameter).

Continue reading →