2015-04-14
1,785 reads
Stewart Campbell
2014-09-03
1,973 reads
2014-08-28
2,172 reads
2014-01-27
1,482 reads
2012-11-20
2,114 reads
2012-01-27
2,244 reads
2011-11-03
2,757 reads
2011-08-12
2,047 reads
2011-03-28
3,431 reads
2011-01-21
3,877 reads
Blogs
Convert SQL Audit Files to a CSV Using Read-SqlXEvent
By Patrick
SQL Server Audit is an efficient way to track and log events that occur...
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...
Forums
changing over to a tab delimited file in my pkg that walks thru folders
hi, we just decided to change over to a tab delimited format in a...
how to query that stores mulit select field data
Hi everyone, I have a table as below, I would like to strip out...
Getting all ancestral parents of a table
From this link - https://stackoverflow.com/questions/22005698/how-to-find-all-the-dependencies-of-a-table-in-sql-server I can find all the child dependencies starting from my...
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;