Gianluca Sartori

Gianluca Sartori is an independent SQL Server consultant and a performance tuning specialist. He has been working in the software industry since 1999 and has been working with SQL Server ever since. Currently he is working as Senior DBA for a famous Italian Formula1 team. Besides consulting projects, he works as a SQL Server trainer and in his spare time he contributes to the SQL Server forums. He is also a speaker at several conferences in Italy and in Europe.

Blog Post

DataMoshpit!

Today I’m presenting at DataMospit, the most metal conference in the data space! You can download the Sea of Madness bingo card from here: https://github.com/spaghettidba/CodeSamples/raw/master/SQLServerInfernals/InfernalBingo.xlsx The winner will get...

2023-09-16

72 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