PASS Summit 2011: Day One
After getting a little lost from the rail to the hotel, I finally got to sleep Sunday night after a...
2011-10-10
500 reads
The Smiling DBA
PASS Summit 2011: My Itinerary
Here goes with what I hope to achieve the following week in Seattle, WA Oct 9-15 for my 4th summit.
I...
2011-09-29
1,397 reads
24 Hours of PASS: Answer questions…
I will try my best to answer some of the questions after the Standard Operating Procedure webcast for 24 Hours...
2011-09-20
1,176 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
Vending Machine Proposal Template
The Super Proposal Vending Machine Proposal Template is a comprehensive and customizable tool designed...
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;