/********************************************************
"CheckAllInts"
Find all columns in all user tables in a database
defined as "int", and get the maximum value for the
column.
Uses a cursor and logs the results to a table. (One-time
CREATE TABLE statement at top of script).
Successive runs over an appropriate period of time would
allow one to find how quickly an integer value is
increasing. Useful for finding columns which may overflow
the boundaries of the integer datatype.
Author: Troy Ketsdever, Silver Creek Consulting
Date: 3/23/2005
*********************************************************/
Harnessing SQL Server Metadata- Disabling and Rebuilding Indexes
When doing bulk data changes it may be beneficial to disable indexes prior to starting the operation. Fortunately, SQL's rich metadata makes this very easy to automate in a robust fashion.
2018-05-18 (first published: 2015-10-19)
4,855 reads