An Introduction to Database Design
An introduction to database design for those people that might not understand what is involved.
2013-01-11 (first published: 2011-01-18)
28,105 reads
Paul White
- Twitter: @https://www.x.com/SQL_Kiwi
- Website: https://www.sql.kiwi
Understanding and Using APPLY (Part 2)
The second of a series by Paul White examining the APPLY operator. In this section learn how this operator compares with joins and about both the cross and outer options.
2012-01-13 (first published: 2010-04-19)
28,510 reads
Understanding and Using APPLY (Part 1)
The first of a two-part series of articles examining the APPLY operator. Learn the basics of how this operator works and how it can help you solve some tricky problems.
2012-01-06 (first published: 2010-04-12)
50,720 reads
2012-01-03
2,536 reads
2011-11-01
1,949 reads
2011-10-27
2,273 reads
2011-09-20
2,373 reads
2011-09-08
2,477 reads
2011-09-01
2,624 reads
2011-08-24
2,766 reads
Blogs
Why Microsoft Fabric Signals the Next Wave of Data Strategy
By Chris Yates
In today’s data-driven economy, organizations are no longer asking if they should invest in...
PostgreSQL Timeline: History and Evolution
By Rohit Garg
PostgreSQL, often referred to as Postgres, is a powerful, open-source object-relational database system that...
Understanding Zonal Redundancy in Azure SQL MI
By Arun Sirpal
Do you know what happens when you enable zonal redundancy for your SQL managed...
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...
Databases and Disasters
Comments posted to this topic are about the item Databases and Disasters
Automating SQL Server Access Review
Comments posted to this topic are about the item Automating SQL Server Access Review
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