Just released new build of ExpressProfiler.
No major changes, just cosmetic improvements - shortcut here, confirmation dialog there, new captured events (SQL:StmtStarting/Completed,...
2014-08-11 (first published: 2014-08-04)
8,817 reads
Twice a week I am asked "why don't you add new cool feature to ExpressProfiler?"
The answer is as simple as...
2014-07-22
488 reads
Sometimes people ask me: "What wrong with following code? Why issue BP017 is registered?"
delete d
from dbo.Data d innerjoin #ids i...
2014-07-07
655 reads
Imagine that you have a huge collection of Hello Kitty images (I do).
One day you make a decision to organize...
2014-06-30
1,897 reads
Core of ExpressProfiler was born about 8 years ago when I worked for a company whose mission was the migration...
2014-06-23
743 reads
When surfing SQL Server forums you might notice a lot of questions like "How do I script my data and...
2014-06-17 (first published: 2014-06-15)
3,601 reads
Imagine that you have a table of customers
createtable Customer
(
Name varchar(30),
LastName varchar(30),
Title varchar(30)
);
go
insertinto Customer values('Alex','Smith','Mr.');
insertinto Customer values('John','Doe','Dr.');
goNow you selecting list...
2014-06-10 (first published: 2014-06-09)
1,879 reads
It may happenthatyou have a needto check thescripts thatyou have on yourdisk. For example, it may be part of yourbuildprocess.So how...
2014-06-02
1,831 reads
What are the magic pink numbers you can see in Code Outline window?The answer is very simple - these are Code Complexity...
2014-05-28 (first published: 2014-05-23)
682 reads
Today we released new version of SQL Code Guard, 2.5.5257
Main changes:
SQL Code Guard is digitally signed now to satisfy corporate...
2014-05-26
775 reads
By Brian Kelley
If you're not having success in convincing your organization to send you to this...
By Rohit Garg
When deploying SQL Server in enterprise environments, choosing the right service account model is...
By Brian Kelley
There are always bad actors who will seek to get access to and, likely,...
Not sure if this is my misunderstanding or an error in my process: Create...
Comments posted to this topic are about the item Determining the Updated Columns
Comments posted to this topic are about the item Carrots and Sticks
I am creating a trigger in SQL Server 2022 and want to detect a change in a table. Here is my table DDL:
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) GOIf I want to detect that the creditlimit was updated, what IF statements should I use? See possible answers