Script to take database backup, compress it and upload to SFTP...

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? ...

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? ...

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....

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....

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....

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....

...

Script to find open active transactions and sessions at database level...

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....