|
|
-
|
|
This is a script to to identify the unused indexes within a database. The column 'ReadsPerWrite' is an important field to consider. ...
|
|
-
|
|
We all know the way to create foreign key on column, and we are using UI to create it mostly instead of script. Did you used script to add foreign key?
...
|
|
-
|
|
Script to take database backup, compress it and upload to SFTP...
|
|
-
|
|
This script demonstrates how to backup a database to a network share (i.e. UNC path). This script is written to take a full database backup for demonstration purposes. However, you can customize this script to suit your backup strategy (differential/log/full backup)....
|
|
-
|
|
We are mostly creating primary key on column while creating tables, But sometime we also need to have it after creating table or on existing table as per need, So i am sharing the script to add primary key on table....
|
|
-
|
|
This is a script we use frequently to identify the location of all clustered and non-clustered indexes as part of storage re-arrangement operations. It returns the list of all indexes along with the file group name....
|
|
-
|
|
Script to find open active transactions and sessions at database level...
|
|
-
|
|
Sometime we need to create Default values for columns after creating a tables, so as per need I am sharing a script to add Default to existing column on table....
|
|
-
|
|
This script helps restore a database from a backup file lying on a network share (i.e. UNC path). Please customize this script for your configuration. For demonstration purposes, this script has been written to perform a complete restore of the database....
|
|
-
|
|
Many IT departments use pre-created ghost images to quickly setup development and quality assurance environments. When they change the name of the server after restoring the image, the SQL Server instance name remains unchanged. Here's a script to change the SQL Server local instance name....
|
|