How does Query Store capture cross database queries?
When I was writing my post Capture the most expensive queries across your SQL Server using Query Store a question crossed...
2017-11-16
614 reads
Matthew McGiffen DBA
SQL Puzzle 4: The Beale Papers
I’ve not done a SQL puzzle for a while so thought it was getting overdue…
I set this one for my...
2019-04-26 (first published: 2017-11-08)
1,429 reads
Capture the most expensive queries across your SQL Server using Query Store
I’m a big fan of using queries based on the dynamic management view sys.dm_exec_query_stats to capture the most resource hungry...
2019-04-26 (first published: 2017-11-01)
4,627 reads
Avoiding confusion with SQLCMD variables
SQLCMD variables can be a useful way of having changeable parameters for your SQL scripts, allowing you to specify the...
2017-11-01
8,212 reads
Implementing Temporal Tables Where You Have Existing Data
In my post about auditing tools in SQL Server I mentioned a few tools we have at our disposal for...
2019-04-26 (first published: 2017-10-24)
4,422 reads
Bug with STATISTICS TIME?
I love the STATISTICS IO and STATISTICS TIME commands. They are such a powerful and easy way to be able...
2017-10-17
496 reads
Avoid “Constants” in T-SQL
Unlike some other languages, T-SQL doesn’t have the concept of a constant.
As good coders, we’ve all at some point tried...
2019-04-26 (first published: 2017-10-10)
3,649 reads
Setting up Change Data Capture (CDC)
As mentioned in my post Auditing Data Access in SQL Server for GDPR Compliance CDC can be a useful tool for...
2017-10-03
13,767 reads
Auditing Data Access in SQL Server for GDPR Compliance
In relation to the GDPR, I’ve recently been looking at the tools available within SQL Server to support auditing our...
2019-04-26 (first published: 2017-09-26)
5,688 reads
When Deadlocks Become Art
We’ve all had to solve deadlock issues. Identify the two conflicting pieces of code, work out an appropriate change to...
2017-09-19
687 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
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...
Something Odd About CAST/TRY_CAST
I've got some code that is supposed to generate a unique key by prefixing...
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;