The second form uses a LIKE clause to create a table that has the same column names and column attributes as another table. To drop any columns in the new table, you can specify the DROP= data set ...

Microsoft SQL uses the instance ID, rather than the instance name, to create data directories. You may use the same value for the ID as you did for the name, though you may wish to shorten it for ...

You can create simple or composite indexes. A simple index is created on one column in a table. A simple index must have the same name as that column. A composite index is one index name that is ...

When this happens it is logged for every single index that is being written to. So for a table with nine non-clustered indexes on it there are 10 writes to the transaction log.

Getting the CREATE INDEX statement is as simple as adding in one more column, shown below, to this query which then generates the T-SQL CREATE INDEX statement. 'USE [' + DB_NAME(c.database_id) + ']; ...