Data Driven Subscription - SQL Server Standard Edition
A simple example of using T-SQL and the Boomerang framework to create a data driven subscription.
2012-02-08 (first published: 2012-01-04)
1,941 reads
Scripts
2012-02-07 (first published: 2011-12-15)
1,047 reads
2012-02-06 (first published: 2011-12-23)
1,545 reads
2012-02-02 (first published: 2012-01-20)
3,908 reads
2012-02-01 (first published: 2012-01-20)
2,213 reads
2012-01-30 (first published: 2011-12-23)
879 reads
Calculate the values for MAX Memory for SQL Server
Use this script to calculate MAX memory setting on a dedicated SQL server.
2012-01-27 (first published: 2011-12-14)
3,482 reads
2012-01-25 (first published: 2011-11-09)
1,281 reads
2012-01-25 (first published: 2011-12-15)
1,191 reads
Stored procedure to find and replace text in a text file
find and replace text in a text file using tsql
2012-01-23 (first published: 2011-12-16)
3,112 reads
Blogs
Stop Using Pandas for Aggregations — Try DuckDB Instead
If you've ever loaded a 2 GB CSV into pandas just to run a...
Understanding Fabric Ontology
By James Serra
What problem is Fabric Ontology trying to solve? For years, most data conversations have...
QUOTENAME Basics: #SQLNewBlogger
By Steve Jones
Recently I ran across some code that used a lot of QUOTENAME() calls. A...
Forums
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...
The string_agg function
Comments posted to this topic are about the item The string_agg function
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