Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
Log in  ::  Register  ::  Not logged in

Scripts by Vimal Lohani profile

   Items 1 to 4 of 4   

Find only characters or only integer from alphanumeric value

Extract only integers or characters from alphanumeric : 
By Vimal Lohani 2014/10/07 | Source: | Category: t-sql
Rating: |  Discuss |   Briefcase | 1,386 reads

Accurate Time between Two Dates in Year, Month,Day Format

This script shows the total time between two dates.  Read more...
By Vimal Lohani 2014/09/05 | Source: | Category: date difference
Rating: |  Discuss |   Briefcase | 2,375 reads

Code For Truncating Table with foreign Key Constraints

This can be used for data warehouses as well as truncating table with foreign key constraints.  Read more...
By Vimal Lohani 2014/08/06 | Source: | Category: truncating tables
Rating: |  Discuss |   Briefcase | 1,794 reads

Defragmentation and update statistics for all online databases

Defragment and Update Statistics.  
By Vimal Lohani 2014/03/27 | Source: | Category: defragmentation.
Rating: |  Discuss |   Briefcase | 1,523 reads
   Items 1 to 4 of 4