Kevin3NF

Kevin Hill is a career SQL Server DBA living in Dallas, TX. His specialities include HA/DR, Best Practice configuration, Performance tuning and teaching new and accidental DBAs
  • Interests: Cycling, family, sci-fi, DBA stuff

Blog Post

SQL Server Wait Stats

Everything in SQL Server is waiting for something…this is by design. And most people never think about it… Until your application is waiting to complete its request, sell the...

2025-04-30 (first published: )

371 reads

Blog Post

The Cost of Not Having a DBA

Does skipping a DBA save money? Wait until your system grinds to a halt, your backups fail, or your cloud bill skyrockets. The “DBA? We Don’t Need No Stinkin’...

2025-04-14 (first published: )

580 reads

Blog Post

SQL Server Time Bombs

Common Reasons for Emergency SQL calls If you are a production DBA (or Accidental prod DBA) you’ve gotten that frantic call in the middle of the night. Or maybe...

2025-03-12 (first published: )

539 reads

Blogs

The PASS Summit on Tour in the Netherlands

By

The PASS Summit goes on tour this year, with the final date the first...

Azure SQL Managed Instance: Boost Performance with Read-Scale Out

By

The Business Critical tier of Azure SQL Managed Instance offers the read-scale out feature...

Free Cloud Environment Setup: A Beginner’s Guide

By

Cloud computing is essential for modern development, data storage, and scalable applications. Setting up...

Read the latest Blogs

Forums

How a Legacy Logic Choked SQL Server in a 30-Year-Old Factory

By Chandan Shukla

Comments posted to this topic are about the item How a Legacy Logic Choked...

Sometimes, Troubleshooting Is Hard

By Grant Fritchey

Comments posted to this topic are about the item Sometimes, Troubleshooting Is Hard

Dimensional Modeling Case Study, Part 4 – Dynamic Time Duration Dimension

By Hang Liu

Comments posted to this topic are about the item Dimensional Modeling Case Study, Part...

Visit the forum

Question of the Day

The Updated Columns List

I have this table in SQL Server 2022:

CREATE TABLE CustomerLarge
  (CustomerID               INT NOT NULL IDENTITY(1, 1) CONSTRAINT CustomerLargePK PRIMARY KEY CLUSTERED
 , CustomerName             VARCHAR(20)
 , CustomerContactFirstName VARCHAR(40)
 , CustomerContactLastName  VARCHAR(40)
 , Address                  VARCHAR(20)
 , Address2                 VARCHAR(20)
 , City                     VARCHAR(20)
 , CountryCode              CHAR(3)
 , Postal                   VARCHAR(20)
)
GO
If I check the columns_updated() function return in a trigger, what is the data returned?

See possible answers