Database Management Systems
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).
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 Table2This switches partition x from Table1 to Table2 (where x is the partition number).
In SQL Server, you can use the ROWCOUNT_BIG() system function to return the number of rows affected by the last T-SQL statement.
It works exactly the same as @@ROWCOUNT, except that ROWCOUNT_BIG() returns its result as a bigint.
In SQL Server, you can use the SET SHOWPLAN_ALL statement to return detailed information about how a T-SQL statement is executed, as well as estimates of the resource requirements for the statements.
In SQL Server, you can use the SET SHOWPLAN_TEXT statement to return detailed information about how a T-SQL statement is executed.
I’ve written quite a number of tutorials for using Database Mail, and I’ve created this article to list them all in one place.
I first included these links at the bottom of How to Send Emails from SQL Server (T-SQL), but I thought it might be helpful to move them to their own article as a quick-reference.
Continue readingI get it. You’re trying to learn SQL, but they won’t even tell you the most fundamental part – what you need to run SQL!
You’ve got the SQL code… but where do you actually run it? What software program do you need before you can run your SQL query against a database?
If that’s you, all is about to be revealed!
Continue readingIn 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.
If you’re using OPENJSON(), but you’re trying to remember how to select an inner fragment from the JSON document, read on.
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