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

Content with tags Maintenance, Dynamic SQL Rss

   Items 1 to 2 of 2   

Flexible Statistics Update

Update the statistics starting from most accessed and modified ones, with a time limit. Procedure will exit when @MaxExecutionTime parameter is greater than the current execution time.  Read more...
By Ugur Yorulmaz 2018/04/19 | Source: SQLServerCentral.com | Category: update statistics
Rating: |  Discuss |   Briefcase | 245 reads

Check Candidate Columns for NOT NULL Constraints

This script reports table columns that allow NULL values but that currently have no NULL values, making them candidates for adding a NOT NULL constraint.  Read more...
By Charles Jacobus 2013/01/23 | Source: SQLServerCentral.com | Category: data integrity
Rating: |  Discuss |   Briefcase | 690 reads
   Items 1 to 2 of 2   
cursors (1)    
data integrity (1)    
data management view (1)    
dmv (1)    
system view (1)    
table variables (1)    
update statistics (1)