July SSSOLV UG Meeting
This is really late notice – apologies in advance.
We will be holding the LV UG meeting July 8th at the same...
2010-07-07
570 reads
Jason Brimhall
SQL 2008 DTS
It’s a Bird…
No, not really. It’s just Windows 7. I have recently upgraded to Windows 7. I took the roundabout...
2010-07-07
3,429 reads
Q2 Goal Review
As we close out the Second Quarter of 2010 it is time to review progress made on the Goals I...
2010-07-06
521 reads
Declare Scalar Variable
Lately I have been going through a bunch of maintenance style scripts and fixing them. Along with fixing them, I...
2010-06-22
831 reads
Who2 Article Published
I just had my second article published on June 14, 2010 at SQLServerCentral. I will be posting a follow-up to...
2010-06-22
995 reads
24 HOP Available
Just a quick note. PASS has made the 24 Hours of PASS available via streaming video. You can check it...
2010-06-16
466 reads
What, When, Where, How, Who2
Some background on sp_who2 from Jason Brimhall and a dive into the inner workings of how to find current activity on an SQL instance.
2010-06-14
14,021 reads
June S3OLV Wrapup
Last night we had our monthly Chapter User group meeting in affiliation with PASS. Honestly, the experience was quite humbling...
2010-06-11
585 reads
2010-06-10
3,930 reads
Data Compression
We have come to that time of month again – blog party. This time, the party is hosted by Jorge Segarra...
2010-06-08
1,035 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