Blogs

Speaking at the 2025 PASS Data Community Summit

By

I will be back in Seattle this year attending the 2025 PASS Data Community...

The Book of Redgate: Motivation

By

Another of our values is this: Motivation isn’t about carrots and sticks. Constant oversight...

A Six Week Break

By

Today is my last day of work for six weeks. I start my sabbatical...

Read the latest Blogs

Forums

SUM([value]) and highest record type

By Pete Bishop

Given a record mapping table: Id Initial Updated 1 1 2 2 3 4...

should i expect data types in task->export data from ssms?

By stan

Hi i recently exported a number of "to be purged resultsets " to .tsv's. ...

Migrating Temporal/systemversioned Tables

By bernaerts_joris

Hello, for my client i have to do regular refreshes of production to dev....

Visit the forum

Question of the Day

Multiple Defaults

In my SQL Server 2022 database, I run this code:

ALTER TABLE dbo.OrderHeader 
ADD ModifiedStamp DATETIME CONSTRAINT df_Created_Getdate DEFAULT GETDATE()
GO
I decide I need to add auditing to another table and run this:
ALTER TABLE dbo.Tracker
ADD Created DATETIME CONSTRAINT df_Created_Getdate DEFAULT GETDATE()
GO
What happens with these statements?

See possible answers