2019-10-07 (first published: 2010-11-02)
3,461 reads
Harsha Majety
2015-05-08 (first published: 2013-06-25)
82,773 reads
2013-08-26
19,378 reads
Re-throw Errors with Logging
This article brings you a technique and framework to use in your stored procedures that can allow you to re-throw and log errors.
2013-03-28
5,990 reads
Blogs
Understanding Zonal Redundancy in Azure SQL MI
By Arun Sirpal
Do you know what happens when you enable zonal redundancy for your SQL managed...
SQL Server Database Compatibility Levels
By Kevin3NF
Why You Shouldn’t Overlook This Quiet but Critical SQL Server Setting If you’ve...
The PASS Summit on Tour in the Netherlands
By Steve Jones
The PASS Summit goes on tour this year, with the final date the first...
Forums
How a Legacy Logic Choked SQL Server in a 30-Year-Old Factory
Comments posted to this topic are about the item How a Legacy Logic Choked...
Execution plan shows enormous number of records
The problem was reported to us by a customer. They shared a graphic execution...
T-SQL to SELECT rows where 2 columns in TBL_A do not exist in TBL_B
I have 2 tables: TBL_A and TBL_B each with the same 2 columns; ServerName...
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) ) GOIf I check the columns_updated() function return in a trigger, what is the data returned? See possible answers