SQLServer How-to Topics

Databases

• How to: Add Data or Log Files to a Database (SQL Server Management Studio)

• How to: Attach a Database (SQL Server Management Studio)

• How to: Change the Configuration Settings for a Database (SQL Server Management Studio)

• How to: Create a Database (SQL Server Management Studio)

• How to: Create User-Defined Data Types (SQL Server Management Studio)

• How to: Delete a Database (SQL Server Management Studio)

• How to: Delete Data or Log Files from a Database (SQL Server Management Studio)

• How to: Detach a Database (SQL Server Management Studio)

• How to: Display Data and Log Space Information for a Database (SQL Server Management Studio)

• How to: Extract a DAC From a Database

• How to: Generate a Script (SQL Server Management Studio)

• How to: Increase the Size of a Database (SQL Server Management Studio)

• How to: Move a Database Using Detach and Attach (Transact-SQL)

• How to: Publish a Database (SQL Server Management Studio)

• How to: Rename a Database (SQL Server Management Studio)

• How to: Set a Database to Single-user Mode (SQL Server Management Studio)

• How to: Shrink a Database (SQL Server Management Studio)

• How to: Shrink a File (SQL Server Management Studio)

• How to: Start the Maintenance Plan Wizard (SQL Server Management Studio)

• How to: Upgrade a Database Using Detach and Attach (Transact-SQL)

• How to: View or Change the Properties of a Database (SQL Server Management Studio)

• How to: View or Change the Recovery Model of a Database (SQL Server Management Studio)

• How to: View or Change the Compatibility Level of a Database (SQL Server Management Studio)

• How to: View a List of Databases on an Instance of SQL Server (SQL Server Management Studio)

• How to: View the Dependencies of a Table (SQL Server Management Studio)

Stored Procedure

• How to: Create a Stored Procedure (SQL Server Management Studio)

• How to: Modify a Stored Procedure (SQL Server Management Studio)

• How to: Rename a Stored Procedure (SQL Server Management Studio)

• How to: View the Definition of a Stored Procedure (SQL Server Management Studio)

• How to: View the Dependencies of a Stored Procedure (SQL Server Management Studio)

• How to: Delete a Stored Procedure (SQL Server Management Studio)

• How to: Grant Permissions on a Stored Procedure (SQL Server Management Studio)

Index

• How to: Delete an Index (SQL Server Management Studio)

• How to: Modify an Index (SQL Server Management Studio)

• How to: Move an Existing Index to a Different Filegroup (SQL Server Management Studio)

• How to: Rebuild an Index (SQL Server Management Studio)

• How to: Reorganize an Index (SQL Server Management Studio)

• How to: View All Indexes in a Table (SQL Server Management Studio)

• How to: View the Properties of an Index (SQL Server Management Studio)

Snapshot

• How to: Create a Database Snapshot (Transact-SQL)

• How to: View a Database Snapshot (SQL Server Management Studio)

• How to: Drop a Database Snapshot (Transact-SQL)

• How to: Revert a Database to a Database Snapshot (Transact-SQL)

from 

http://technet.microsoft.com/en-us/library/ms186378(v=sql.105).aspx

http://technet.microsoft.com/en-us/library/ms345393(v=sql.105).aspx

http://technet.microsoft.com/en-us/library/ms190467(v=sql.105).aspx

http://technet.microsoft.com/en-us/library/ms189630(v=sql.105).aspx