IF RDBMS = SQL Server, NoSQL = ???
SQL Server is, arguably, the leading relational database management system out there. With continuous development and enhancement of exciting features...
2017-11-08
451 reads
SQL Server is, arguably, the leading relational database management system out there. With continuous development and enhancement of exciting features...
2017-11-08
451 reads
It’s said that “promises are made to be broken”. Surely database administrators don’t fall in that category? It’s that time...
2016-12-28
684 reads
Is this one of those weird food combinations like honey on pizza or salt and pepper on apples that’s going...
2016-11-22
571 reads
Three men are in a hot-air balloon. Soon, they find themselves lost in a canyon somewhere. One of the three...
2016-09-20
396 reads
Suffering SQL Server Performance Issues?: A story of Olympic sprints and handy SQL Server hints!!!
Usain Bolt, the world’s fastest runner,...
2016-08-18
371 reads
Recently, a customer mentioned that they seemed to be missing records in tables they don’t delete from. Generally, at this...
2016-02-25
1,438 reads
SQL Server statistics can make things a bit freaky. You might have read one of my previous articles portraying a...
2015-10-30
1,533 reads
Microsoft are releasing regular CTP updates for SQL Server 2016. In the very recent release (CTP 2.4), there is a...
2015-10-20 (first published: 2015-10-16)
3,535 reads
Statistics, in simplest terms, refer to the distribution of data in a column or index. They are represented in a...
2015-09-21
760 reads
Look at some of the graphs produced by the intra query parallelism deadlocks, below.
Bart Duncan explains this “phenomenon” (bug, rather)...
2015-09-10
1,361 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