Technical Article

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 […]

You rated this post out of 5. Change rating

2001-08-10

1,669 reads

Blogs

Future Data Driven 2023 is This Week

By

The Future Data Driven 2023 virtual conference is coming on Wednesday, September 27. Register...

Opening the SQL Prompt Command Palette

By

A few years ago SQL Prompt added a command palette to let you search...

Common Mistakes in SQL Server – Part 2

By

The  Identity property creates an incremental value for the specified column automatically, which is...

Read the latest Blogs

Forums

Identifying the process that is backing the databases to virtual device

By ramana3327

We have about 20 SQL Servers. We use Net backup or Native backup for...

SQL Migration - Identifying Connections - Best approach

By ramana3327

I have one SQL Database server which is old version and planning to migrate...

Restore With Standby; A Review and A Lesson Learned

By Andy Warren

Comments posted to this topic are about the item Restore With Standby; A Review...

Visit the forum

Ask SSC Logo Ask SSC

SQL Server Q&A from the SQLServerCentral community

Get answers