Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
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,279 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,100 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,218 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 | 959 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,192 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,236 reads

Create a copy of database with a new name

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