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

Scripts by Devendra Thakur

SQLServerCentral.com profile

   Items 1 to 3 of 3   
 

Index Utilization Summary

This report shows all the Indexes on user defined table or view and how effectively they are being used in our project.  Read more...
By Devendra Thakur 2017/04/20 | Source: SQLServerCentral.com | Category: index
Rating: |  Discuss |   Briefcase | 672 reads

Find and Replace a value across all tables in database

End user has entered ‘goodmorning’ and ‘good morning’ interchangeably and it was causing logic failure at application level. So task was to replace ‘goodmorning’ with ‘good morning’ in database wherever it is there.  Read more...
By Devendra Thakur 2017/04/28 | Source: SQLServerCentral.com | Category: search database
Rating: |  Discuss |   Briefcase | 611 reads

Change Column datatype

This script is for converting Char to nChar and varchar to nVarchar with the same length. This process has reduced the manual work by 80% (approximately) in our case.  Read more...
By Devendra Thakur 2017/04/24 | Source: SQLServerCentral.com | Category: alter table
Rating: |  Discuss |   Briefcase | 405 reads
   Items 1 to 3 of 3