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,719 reads

Blogs

A Pursuit of Lifelong Learning

By

The following came across my YouTube feed today. It’s an interview with General James...

Advice I Like: Time and Focus

By

“You don’t need more time because you already have all the time that you...

Book Review: Microsoft 365 Copilot and Agent Administration Fundamentals

By

I don’t currently manage Microsoft 365 Copilot in an enterprise environment, but it is...

Read the latest Blogs

Forums

What Did Healthy Look Like?

By Laura Copeland

Comments posted to this topic are about the item What Did Healthy Look Like?

DML Trigger Types

By Steve Jones - SSC Editor

Comments posted to this topic are about the item DML Trigger Types

PostgreSQL in action with Opensearch

By sabyda

Comments posted to this topic are about the item PostgreSQL in action with Opensearch

Visit the forum

Question of the Day

DML Trigger Types

How many types of DML triggers are there?

See possible answers