DBA

Determining free disk space with TSQL

by SteveStedman
December 3, 2011December 4, 2012
2 Comments
DBA, TSQL

Working on a new report for the SQL Server Health reports, I needed to display the amount of free disk space on a SQL Server.… Read More »Determining free disk space with TSQL

New – SQL Server Health report

by SteveStedman
November 19, 2011November 26, 2011
DBA, Server Health

Over the last couple of weeks I have taken a couple of the common queries that I use to analyze the health of a SQL… Read More »New – SQL Server Health report

MSG 128, Level 15, State 1 – not permitted in this context

by SteveStedman
March 3, 2011December 3, 2011
DBA, TSQL

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

SQL Server 2008 R2 Compatibility Levels

by SteveStedman
April 21, 2010November 25, 2011
DBA

There was no change to the compatibility levels between SQL Server 2008 and SQL Server 2008 R2. SQL Server can run in a number of… Read More »SQL Server 2008 R2 Compatibility Levels

Home after a week at SQL DevConnections 2009 in Las Vegas

by SteveStedman
November 14, 2009October 18, 2012
DBA, Steve

This week I have been at the SQL Connections conference in Las Vegas. With 7 to 9 hours of classes and presentations every day, all… Read More »Home after a week at SQL DevConnections 2009 in Las Vegas

Query SQL Server 2008 Total Memory Usage

by SteveStedman
September 18, 2008November 29, 2011
DBA

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

How much Procedure Cache memory does one SQL Statement take up?

by SteveStedman
September 17, 2008November 25, 2011
1 Comment
DBA

I recently have had the opportunity to work on performance tuning on Microsoft SQL Server 2005. Recently I have been doing more with performance tuning… Read More »How much Procedure Cache memory does one SQL Statement take up?

SQL Server 2008 compatibility levels

by SteveStedman
August 24, 2008November 25, 2011
DBA, TSQL

SQL Server can run in a number of different compatibility levels, but how do you change it and how do you set it. These compatibility… Read More »SQL Server 2008 compatibility levels

SQL Server 2005 Compatibility Level

by SteveStedman
January 24, 2006May 3, 2013
DBA, TSQL

SQL Server can run in a number of different compatibility levels, but how do you change it and how do you set it. These compatibility… Read More »SQL Server 2005 Compatibility Level