Is Your Database Application DeadLock and Timeout Resistent?
Is your application scalable under increased activity? Timothy Claason brings us a methodology for testing how your application will deal with database load.
2010-03-10
12,658 reads
Is your application scalable under increased activity? Timothy Claason brings us a methodology for testing how your application will deal with database load.
2010-03-10
12,658 reads
By Kevin3NF
It’s not glamorous, but it works In a world where shiny new HA/DR features...
By Brian Kelley
For those testing SQL Server 2025 before it officially releases, Microsoft has made the...
If there’s one thing I’ve learned in consulting, it’s that SQL Server, and other...
Hey everyone, I’ve been experimenting a bit with digital ads for car insurance, and...
Comments posted to this topic are about the item Detecting Multiple Changes
Comments posted to this topic are about the item Ghostworkers
I want to write a trigger to detect changes to columns in SQL Server 2022. I have this table:
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) , creditlimit INT , discount NUMERIC(4, 2) , lastorderdate DATETIME , lastorderamount NUMERIC(10, 2) , lastordercontact VARCHAR(20) , created DATETIME , modified DATETIME , modifiedby VARCHAR(20) , statusid INT , active BIT , customersize INT , primarysalesid INT); GOI want to determine if both the CustomerContactFirstName and CustomerContactLastName fields are changed, but no others. What is the mask I need to use with COLUMNS_UPDATED()? See possible answers