SQL Confessions
I had a brainstorm of an idea for a group of articles on my blog a couple of weeks ago...
2010-12-13
509 reads
Jason Brimhall
SSIS Job Execution
While working on a process to refresh the QA environment (data purge, reload data and reapply changes made over time as parts of release cycles), I ran into self-imposed...
2010-12-13
6 reads
SSIS Job Execution
While working on a process to refresh the QA environment (data purge, reload data and reapply changes made over time...
2010-12-13
711 reads
Wait Stats resources
Today I was out and about looking for past roundups on TSQLTuesday. While doing that, I came across a post from Paul Randal (Blog | Twitter) about wait stats. The...
2010-12-13
6 reads
Wait Stats resources
Today I was out and about looking for past roundups on TSQLTuesday. While doing that, I came across a post...
2010-12-13
706 reads
Bundle of Joy
After baking for 9 months, our bouncing baby girl has finally arrived. She arrived Thursday Dec 2, 2010 at 8:28 AM (PST). There were no complications and the delivery...
2010-12-09
3 reads
Bundle of Joy
After baking for 9 months, our bouncing baby girl has finally arrived. She arrived Thursday Dec 2, 2010 at 8:28...
2010-12-09
625 reads
December 2010 SSSOLV Reminder
Here is a quick reminder and a repost of the announcement from last week. This month we will be broadcasting the meeting once again. This month the technology bug...
2010-12-08
4 reads
December 2010 SSSOLV Reminder
Here is a quick reminder and a repost of the announcement from last week.
This month we will be broadcasting the...
2010-12-08
848 reads
December 2010 S3OLV Meeting
It is amazing how the months just seem to fly by these days. I probably say that every month. It seems appropriate though. This month we will be broadcasting...
2010-12-01
2 reads
Blogs
The Book of Redgate: Profits
By Steve Jones
Redgate is a for-profit company. We look to make money by building and selling...
Session Materials for Techorama & DataGrillen 2026
I’ve uploaded the slides for my Techorama session Microsoft Fabric for Dummies and my...
Stop Using Pandas for Aggregations — Try DuckDB Instead
If you've ever loaded a 2 GB CSV into pandas just to run a...
Forums
Even When You Know What You're Doing, You Can Screw Up
Comments posted to this topic are about the item Even When You Know What...
The New Software Team
Comments posted to this topic are about the item The New Software Team
Database Mail in SQL Server 2022
Comments posted to this topic are about the item Database Mail in SQL Server...
Question of the Day
The string_agg function
We create the following table and then insert some records in it:
create table t1 ( id int primary key, category char(1) not null, product varchar(50) ); insert into t1 values (1, 'A', 'Product 1'), (2, 'A', 'Product 2'), (3, 'A', 'Product 3'), (4, 'B', 'Product 4'), (5, 'B', 'Product 5');What happens if we execute the following query in both Sql Server and PostgreSQL?
select id,
category,
string_agg(product, ';')
over (partition by category order by id
rows between unbounded preceding and unbounded following) as stragg
from t1; See possible answers