sqlrider

Alex Stuart is a DBA from Manchester, UK, who levelled up from bartender to application support to accidental DBA to full-time Default Blame Accepter.
Primarily a production DBA fond of performance tuning and upgrades, but known to get hands dirty with whatever tool fits the job - Powershell, C#, ASP.NET, breaker bars.
In summer he rides fast bikes on as many racetracks as he can fit in.
In winter he reads and plays guitar and videogames. Ok, sometimes in summer he also does all of those things.
  • Interests: Technology, philosophy, motorbikes, videogames
  • Skills: Performance tuning, Azure, automation

All authors

All authors

Blogs

The Evolution of Data: From Databases to Spark to Lakebases

By

The circle cylinder of life Maybe you’ve noticed all the twenty somethings tight rolling...

Why Microsoft Fabric Signals the Next Wave of Data Strategy

By

In today’s data-driven economy, organizations are no longer asking if they should invest in...

PostgreSQL Timeline: History and Evolution

By

PostgreSQL, often referred to as Postgres, is a powerful, open-source object-relational database system that...

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...

When INCLUDE Columns Quietly Inflate Your Transaction Logs

By Chandan Shukla

Comments posted to this topic are about the item When INCLUDE Columns Quietly Inflate...

Databases and Disasters

By Grant Fritchey

Comments posted to this topic are about the item Databases and Disasters

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