DBCC ShrinkDatabase
Being day 24 of the DBCC Command month at SteveStedman.com, today’s featured DBCC Command is DBCC SHRINKDATABASE. When I first heard about DBCC Shrink Database… Read More »DBCC ShrinkDatabase
INT
T-SQL DATEPART Explained
Here is a quick rundown on the T-SQL DATEPART function for SQL Server. DATEPART is used to pull a single part of a date/time element… Read More »T-SQL DATEPART Explained
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?
CTE – With An Insert Statement
Queries with Common table expressions (CTE) are made up of two parts, the CTE part, and the SQL that references the CTE. In preparation for… Read More »CTE – With An Insert Statement
Free – Duplicate Indexes Report – Updated
After creating and deploying the duplicate indexes report earlier today I discovered that although the report did exactly what it says, it didn’t do what… Read More »Free – Duplicate Indexes Report – Updated
Index Fragmentation and SHRINKDATABASE
Is it a good idea to run DBCC SHRINKDATABASE regularly? Download the sample file ShrinkSample. This article and samples apply to SQL Server 2005, 2008,… Read More »Index Fragmentation and SHRINKDATABASE
MSG 128, Level 15, State 1 – not permitted in this context
Default Values and Computed Columns In SQL Server 2008, I was presented with the following error when attempting to create a table that has a… Read More »MSG 128, Level 15, State 1 – not permitted in this context
Query SQL Server 2008 Total Memory Usage
The quick and easy way to determine how much memory your SQL Server is using is to look at the Task Manager on the server… Read More »Query SQL Server 2008 Total Memory Usage