VARCHAR

VARCHAR diff function

by SteveStedman
February 13, 2013February 13, 2013
1 Comment
CTE

Last month I posted another CTE blog entry Using a CTE to Split a String Into Rows with Line Numbers. Since then I have used it… Read More »VARCHAR diff function

Cannot resolve the collation conflict

by SteveStedman
December 14, 2012July 28, 2015
TSQL

One possible cause of the “Cannot resolve the collation conflict” error message is that your database collation doesn’t match the TempDB Collation. Recommendation It is… Read More »Cannot resolve the collation conflict

Using the OUTPUT Clause in TSQL for Auditing

by SteveStedman
March 28, 2012February 18, 2015
TSQL

The OUTPUT clause is often times underappreciated by the TSQL programmer. There are many really interesting things that you can do with the OUTPUT clause,… Read More »Using the OUTPUT Clause in TSQL for Auditing

Size of all databases on one SQL Server

by SteveStedman
December 4, 2011December 4, 2011
TSQL

Here is a script that I created to get the size of all of the databases on one SQL Server. Generally I stay away from… Read More »Size of all databases on one SQL Server

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

Restoring A Log Chain

by SteveStedman
November 19, 2011October 20, 2012
Recovery

This is a followup to my Whats more important than a backup plan article posted a couple of months ago. When you do a database… Read More »Restoring A Log Chain

Index Fragmentation and SHRINKDATABASE

by SteveStedman
November 12, 2011November 23, 2024
Performance

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

Finding the names of all indexes on a SQL Server

by SteveStedman
June 11, 2011May 6, 2021
TSQL

I needed a way to list of of the indexes for an entire database, but I was running into a problem using sys.indexes that I… Read More »Finding the names of all indexes on a SQL Server

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