SQL Server, What's In My Buffer Cache?
When SQL Server reads pages it stores them in an area of memory called the buffer cache, things like memory...
2019-03-06 (first published: 2019-02-19)
2,228 reads
When SQL Server reads pages it stores them in an area of memory called the buffer cache, things like memory...
2019-03-06 (first published: 2019-02-19)
2,228 reads
I recently wanted a script to tell me that for every database on a given server
What levels of backups I...
2019-02-28 (first published: 2019-02-13)
3,300 reads
Log shipping is one of the simplest and most bulletproof methods to get SQL Server to replicate data to a...
2019-02-21 (first published: 2019-01-31)
2,731 reads
In writing some sample demos around LOB and Row-Overflow data I found a couple of oddities in the way reads...
2019-02-20
155 reads
We’ve had backup encryption out of the box since SQL Server 2014, yet I’ve rarely seen it used. In an...
2019-02-19 (first published: 2019-01-28)
9,945 reads
There are plenty of scripts out there that can show you the waits that are occurring on your server, however,...
2019-02-18
164 reads
OK so the title is a bit of a bold statement but bear with me, I’ve been burned by this...
2019-02-11 (first published: 2019-01-23)
6,652 reads
I’ve been meaning to start a series of posts on “Dipping your toes into the cloud” for a while now,...
2019-01-30
191 reads
A lot of people don’t realise that some deadlocks can be removed entirely with the introduction of a new index....
2019-01-23 (first published: 2019-01-14)
6,415 reads
I thought I’d use this post to round up some of my other posts into a list of often overlooked/unknown...
2019-01-22
251 reads
By Daniel Janik
The circle cylinder of life Maybe you’ve noticed all the twenty somethings tight rolling...
By Chris Yates
In today’s data-driven economy, organizations are no longer asking if they should invest in...
By Rohit Garg
PostgreSQL, often referred to as Postgres, is a powerful, open-source object-relational database system that...
Comments posted to this topic are about the item How a Legacy Logic Choked...
Comments posted to this topic are about the item Databases and Disasters
Comments posted to this topic are about the item Automating SQL Server Access Review
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