Email Alerts
-
Utilities to maintain a surrogate key architecture
You've discovered why and when to work with a surrogate key architecture, and how to establish its framework. In the third installment of this series, learn how to maintain the database with utility routines and stored procedures. Feature
-
Utility routine: sp_ChangeParentValue
This routine transfers the relationship to child table rows from one parent table row to another. Feature
-
Utility routine: sp_CheckKeyValues
Contributor Brian Walker offers a routine to return a result set containing the integer value ranges represented in a selected table and column. Feature
-
Utility routine: sp_FindDuplicateRows
This routine finds cases where multiple rows match across a specified set of criteria (columns) in a selected table. Feature
-
Utility routine: sp_CheckRowCounts
Contributor Brian Walker offers this routine to return a result set containing row counts along with IDENTITY value information for selected tables. Feature
-
Utility routine: sp_OrganizeKeyValues
This routine organizes the IDENTITY values into a single contiguous range (1-N) for a selected table. Feature
-
Utility routine: sp_ResetNextKeyValue
This routine resets the next available IDENTITY value for selected tables. Feature
-
data structure
A data structure is a specialized format for organizing and storing data. Definition
-
Sysindexes.status vs. INDEXPROPERTY
SQL Server 2005 expert Adam Machanic explains why the INDEXPROPERTY system tool is the best way to get relevant index information. Ask the Expert
-
Getting BI from the contact center
Forward-thinking contact centers are using quality monitoring applications for business analysis. Article