2021-07-18
14 reads
2021-07-18
14 reads
Very few people have thought about this performance killer. It is all about report parameter of text type.
The initial situation
There...
2015-11-04 (first published: 2015-10-22)
2,413 reads
Very few people have thought about this performance killer. It is all about report parameter of text type. The initial situation There was a table with about 45 million...
2015-10-22
7 reads
Very few people have thought about this performance killer. It is all about report parameter of text type. The initial situation There was a table with about 45 million...
2015-10-22
6 reads
It’s quite an unpleasant thing that we had to face once. There was a working script, which had been functioning...
2015-10-14
1,611 reads
It’s quite an unpleasant thing that we had to face once. There was a working script, which had been functioning for a long time and did not cause any...
2015-10-14
44 reads
It’s quite an unpleasant thing that we had to face once. There was a working script, which had been functioning for a long time and did not cause any...
2015-10-14
7 reads
If for any reason you need to place the database on a network share and by default this option is...
2015-10-12
1,362 reads
If for any reason you need to place the database on a network share and by default this option is off you can follow the way described below: A...
2015-10-12
7 reads
If for any reason you need to place the database on a network share and by default this option is off you can follow the way described below: A...
2015-10-12
7 reads
By Arun Sirpal
Do you know what happens when you enable zonal redundancy for your SQL managed...
By Kevin3NF
Why You Shouldn’t Overlook This Quiet but Critical SQL Server Setting If you’ve...
By Steve Jones
The PASS Summit goes on tour this year, with the final date the first...
Comments posted to this topic are about the item How a Legacy Logic Choked...
Make your corporate events more engaging with a fun twist. Our booths capture energetic...
I've written this code, but it is showing right now as 2 rows per...
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