When Things Align Unexpectedly
Things are happening
or: Learning to Not Look a Gift Horse in the Mouth
The stars seem to have aligned. I am...
2014-11-02
866 reads
Chris
Changing Your SQL Server Name
Is the name of your SQL Server correct?
Why Worry About The Server Name In SQL?
When the name of the actual...
2014-10-31
1,637 reads
Changing Your SQL Server Name
Reading Time: 2 minutesIs the name of your SQL Server correct?
Why Worry About The Server Name In SQL?
When the name...
2014-10-31
1,012 reads
Find all triggers in a SQL Server Database
Reading Time: 2 minutes
What Are Database Triggers?
Do you know what triggers lurk in your database?
Triggers can be implemented to enforce...
2014-10-24
505 reads
Untrusted Foreign Keys
What is a Foreign Key?
Do you trust your foreign keys?
A foreign key is a link between 2 tables that is...
2014-10-23 (first published: 2014-10-17)
7,657 reads
Untrusted Foreign Keys
Reading Time: 4 minutes
What is a Foreign Key?
Do you trust your foreign keys?
A foreign key is a link between...
2014-10-17
310 reads
I Must Be Doing Something Right – MVP Award
I am extremely excited to announce that I have just received the Microsoft MVP award for SQL Server for 2014.
For...
2014-09-30
886 reads
I Must Be Doing Something Right – MVP Award
I am extremely excited to announce that I have just received the Microsoft MVP award for SQL Server for 2014.
For...
2014-09-30
947 reads
Video: Walk & Talk #003 – RPO
What is the RPO?
And why does it matter?
Join me as I walk through Jefferson Patterson Park’s Indian village and discuss...
2014-09-30
849 reads
Video: Walk & Talk #003 – RPO
What is the RPO?
And why does it matter?
Join me as I walk through Jefferson Patterson Park’s Indian village and discuss...
2014-09-30
1,066 reads
Blogs
Control Flow Restartability in Azure Data Factory
I presented at SQL Saturday Pittshburgh this past weekend about populating your data warehouse...
Monday Monitor Tips: Knowing Your RPO
By Steve Jones
A customer was asking recently about the RPO for their estate, and I showed...
Webinar tomorrow: The Role of Databases in the Era of AI
By Steve Jones
I’m hosting a webinar tomorrow with Rie Merritt from Microsoft. We’ll be talking about...
Forums
Git Repo(s) for SQL Server Database, SSIS, SSAS, SSRS, PowerBI
Hey all, Just wondering how do you guys / girls set up git repo(s)...
best choice for index when creating a composite key
hi everyone I am planning on adding a composite key for my tables. I...
Best Approach to cutover from Test to Live with new columns and tables added
We have a Production/Live version with up-to-date data and a Test version with older...
Question of the Day
STRING_AGG's behavior
Executing the following script (Sql Server 2022), you get the table t0 with 10 rows:
CREATE TABLE t0
( id INT PRIMARY KEY
, field1 VARCHAR(1000)
, field2 VARCHAR(MAX));
INSERT INTO t0
SELECT
gs.value
, REPLICATE ('X', 1000)
, REPLICATE ('Y', 1000)
FROM generate_series(1, 10, 1) gs;
GOWhat happens if you execute the following statements?
select STRING_AGG(field1, ';') within group (order by id) from t0;
select STRING_AGG(field2, ';') within group (order by id) from t0;