Finding Blocking Queries
One of the common problems with when diagnosing what appears to be a slow scenario where there may be blocking involved is determining what is… Read More »Finding Blocking Queries
SMALLINT
DBCC CheckIdent
Being day six of the DBCC Command month at SteveStedman.com, today’s featured DBCC Command is DBCC CHECKIDENT. Description: DBCC CHECKIDENT is used for check on… Read More »DBCC CheckIdent
Are you wasting half the capacity of IDENTITY?
When creating a table you can specify IDENTITY with the following syntax: For example The IDENTITY property is valid for data types of the integer… Read More »Are you wasting half the capacity of IDENTITY?