Dynamic Shrink Log file on server

We are required to shrink the log file to make space on server.

Difference with DataLength and Len with CHAR and NVARCHAR Datatype

Get the defination of all table type in database

THis script will generate the Drop and create script for all user define table type

Get the Column level difference for 2 database

The query will help to get the column level difference for 2 database(Like Prod and Dev database). This help us to verify what are the column changes has been done in dev environment after Prod deployment.

Get the all user and their server role

The script give you the list of all users and their respective Server roles

What will be Identity value

Using Seqence Container instead of Identity

This script is an example of how to use Sequence, similar to Identity.

Create a copy of database with a new name

Create Copy of database with new name.

Get the all the tables on the server which do not have Clustered index

Get the list of the tables on the server which dont have the clustered index.