Optimize Character Field Usage

This stored procedure was designed to scan all your character based columns in a particular database and show the minimum, maximum and average data length. As well as give an efficiency rating of the data stored. Input: None Output: Table name, Column name, Defined datatype and length, Average length of data for that column, Minimum […]


1,645 reads


Why do DBAs dislike loops?


If you started out as a developer you were probably taught how important loops...

Public and Demo Data Coming Soon!


Any database professional that has been around the Microsoft world for more than about...

New Centralized View of SQL Resources in Azure


Yesterday, some new views were made available in the Azure portal that will be...

Read the latest Blogs


Upgrade to SQL Server 2008 R2 SP2 from SQL Server 2005 SP3

By iosman123

Hello, I noticed that SQL Server 2005 SP3 is not in the in the...

Can't drop database in "restoring" state from secondary instance of AG

By auaiomrn

MSSQL version: 2016 (13.0.5026.0) Situation: Removed a database from an availability group so it...

ReportServer Database upgrade fails

By lmarkum

I've tried several times to successfully  migrate a SQL Server 2008R2 ReportServer and ReportServerTempDB...

Visit the forum


SQL Server Q&A from the SQLServerCentral community

Get answers