Click here to monitor SSC
SQLServerCentral is supported by Redgate
 
Log in  ::  Register  ::  Not logged in
 
 
 

Content with tags Administration, Migration Rss

   Items 1 to 3 of 3   
 

Script to configure Log File Size for Large DBs

Use this script to set recommended Log files size growth for larger DBs. For more, please refer article: http://sqlmag.com/blog/choosing-default-sizes-your-data-and-log-files  Read more...
By Ajay Dwivedi 2015/12/15 | Source: SQLServerCentral.com | Category: database configuration
Rating: |  Discuss |   Briefcase | 1,110 reads

Conversion of default objects to column defaults

This script can convert the usage of bound default objects in tables to column defaults  Read more...
Rating: |  Discuss |   Briefcase | 382 reads

Conversion of rule objects to column check constraints

This script can convert the usage of bound rule objects in tables to column check constraints  Read more...
By Michael S√łndergaard 2010/01/28 | Source: SQLServerCentral.com | Category: sp_bindrule
Rating: (not yet rated) |  Discuss |   Briefcase | 510 reads
   Items 1 to 3 of 3   
 
Tags
database configuration (1)    
default (1)    
dynamic script (1)    
log files (1)    
optimization (1)    
restore (1)    
rules (1)    
sp_bindefault (1)    
sp_bindrule (1)    
sp_unbindefault (1)    
sp_unbindrule (1)