Forcing Execution Plan
Very rarely there is a need to force an execution plan and even more rarely we should be doing it....
2018-07-30 (first published: 2018-07-20)
12,928 reads
Very rarely there is a need to force an execution plan and even more rarely we should be doing it....
2018-07-30 (first published: 2018-07-20)
12,928 reads
We have configured email alerts in our environment. Recently I had requirement of sending SMS for critical alerts on production...
2014-03-31
1,915 reads
There is a way by which we can merge the .trc and .blg files to get a great view as...
2013-10-17 (first published: 2013-10-09)
6,285 reads
INTRODUCTION
Statistics contain information about the data. How the data is distributed inside the table. They are representation of a table....
2013-09-29
3,878 reads
By Steve Jones
The PASS Summit goes on tour this year, with the final date the first...
By Arun Sirpal
The Business Critical tier of Azure SQL Managed Instance offers the read-scale out feature...
By Rohit Garg
Cloud computing is essential for modern development, data storage, and scalable applications. Setting up...
Comments posted to this topic are about the item How a Legacy Logic Choked...
Comments posted to this topic are about the item Sometimes, Troubleshooting Is Hard
Comments posted to this topic are about the item Dimensional Modeling Case Study, Part...
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