If you’re creating a SQL Server Agent job for the first time, you might find that you need to enable the SQL Server Agent extended stored procedures (SQL Server Agent XPs) first.
When you use the SQL Server Management Studio (SSMS) tool to start the SQL Server Agent service, these extended stored procedures are enabled automatically.
When you use T-SQL, you can enable the SQL Server Agent XPs with the sp_configure stored procedure.
This page contains direct links to SQL tutorials and reference articles for beginners.
Continue readingIf 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.
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.
In SQL, if you want to remove a table from a database, you need to use the DROP TABLE statement.
That destroys the table and all its data.
Continue readingNormally if you need to drop a foreign key in SQL, you’d use the ALTER TABLE statement. But if you’re using SQLite, that’s not an option.
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.
Continue readingIn SQL, if you want to remove a column from a table, you need to use the ALTER TABLE statement with the DROP COLUMN clause.
That removes the column and all its data.
Continue readingIn 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!
Continue readingThis article provides a quick example of renaming a table in SQL.
Most of the major RDBMSs allow you to rename a column with the ALTER TABLE statement. SQL Server is an exception.