SQL Clone
SQLServerCentral is supported by Redgate
Log in  ::  Register  ::  Not logged in

Scripts by Mitesh Oswal

SQLServerCentral.com profile

   Items 1 to 7 of 7   

Dynamic Shrink Log file on server

We are required to shrink the log file to make space on server.  Read more...
By Mitesh Oswal 2014/08/11 | Source: SQLServerCentral.com | Category: log file maintenance
Rating: |  Discuss |   Briefcase | 1,630 reads

Get the defination of all table type in database

THis script will generate the Drop and create script for all user define table type  Read more...
By Mitesh Oswal 2014/04/18 | Source: SQLServerCentral.com | Category: drop table
Rating: |  Discuss |   Briefcase | 1,172 reads

Get the all user and their server role

The script give you the list of all users and their respective Server roles  Read more...
By Mitesh Oswal 2014/04/02 | Source: SQLServerCentral.com | Category: security
Rating: (not yet rated) |  Discuss |   Briefcase | 1,517 reads

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.   Read more...
By Mitesh Oswal 2014/04/10 | Source: SQLServerCentral.com
Rating: |  Discuss |   Briefcase | 1,017 reads

Using Seqence Container instead of Identity

This script is an example of how to use Sequence, similar to Identity.   Read more...
Rating: |  Discuss |   Briefcase | 1,307 reads

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.  Read more...
By Mitesh Oswal 2014/02/24 | Source: SQLServerCentral.com | Category: clustered index
Rating: |  Discuss |   Briefcase | 1,336 reads

Create a copy of database with a new name

Create Copy of database with new name. 
By Mitesh Oswal 2014/02/27 | Source: SQLServerCentral.com
Rating: |  Discuss |   Briefcase | 1,845 reads
   Items 1 to 7 of 7