Ian

How to Map Multiple Partitions to a Single Filegroup in SQL Server (T-SQL)

by

If you’re familiar with creating partitioned tables in SQL Server, you might be used to creating a separate filegroup for each partition. This has its benefits, and may very well be the method you would choose in most scenarios.

However, you also have the option of mapping multiple partitions to a single filegroup.

In this article I share two examples of mapping multiple partitions to a single filegroup.

  • Example 1 maps all partitions to a single filegroup.
  • Example 2 maps some partitions to one filegroup, and some to another.

Read more

How to Rename a Table in SQL

by

In SQL, most RDBMSs allow you to rename a table using the ALTER TABLE statement, which is the statement used to modify the definition of an existing table.

Some RDBMs also include a RENAME statement for renaming tables.

But if you use SQL Server, you’ll need to use the sp_rename stored procedure.

Read more

SQLite DROP TABLE

by

In SQLite, you can drop a table with the DROP TABLE statement.

You can optionally add the IF EXISTS clause to suppress any errors that might occur if the table doesn’t exist.

Also, if the table is referenced by a foreign key, there are a few things to be aware of.

Read more

SQL Tutorial for Beginners

by

In this SQL tutorial for beginners, you will create your own database, insert data into that database, and then run queries against that database.

This SQL tutorial will get you running SQL queries in no time!

Read more

SQL ALTER TABLE for Beginners

by

In SQL, the ALTER TABLE statement modifies the definition of an existing table.

You can use ALTER TABLE to alter, add, or drop columns and constraints.

Depending on your DBMS, the ALTER TABLE statement can also be used to reassign and rebuild partitions, or disable and enable constraints and triggers.

Read more

SQL UNION Clause for Beginners

by

In SQL, the UNION clause concatenates the results of two queries into a single result set.

You can use the UNION clause with or without the ALL argument:

  • UNION ALL – Includes duplicates.
  • UNION – Excludes duplicates.

Some RDBMSs also accept UNION DISTINCT, which is the equivalent to UNION. That is, it excludes duplicates.

Below are some basic examples to demonstrate how it works.

Read more