James' SQL Footprint

if you run BACKUP DATABASE T-SQL, there is a parameter STATS which reports the percentage complete, However when you run the...

2012-03-31

1,900 reads

Select : Lock or No Lock?

Here is a post I happen to find today: why select command is not blocked by update command?

http://blog.csdn.net/zjcxc/article/details/4383113
First, I...

2012-03-30

2,979 reads

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

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

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

Comments posted to this topic are about the item Three Times a Day

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

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

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?