Comparing two query plans
This month my friend Michael J Swart(b/t) would like us to talk about the new 2016 version of SQL Server....
2016-06-20 (first published: 2016-06-14)
3,356 reads
Kenneth Fisher
Help! My backup file has doubled in size.
Help! I backed up my database yesterday and the backup file was about 200MB but today it’s closer to 400!...
2016-06-16
589 reads
Using LEN wrong.
I was reading someone’s question the other day on StackExchange and while the existing comments/questions solved the OP’s (original poster)...
2016-06-10 (first published: 2016-06-02)
4,636 reads
Comparing the contents of two tables Redux
I did a post the other day on comparing two tables. It was meant as a general overview but I...
2016-06-08
480 reads
I need help with DBCC
Many years ago during an interview I was asked to “Name the top 7 DBCC commands that you use.” I...
2016-06-06
1,419 reads
Master_Views: master_objects, master_tables, etc
There is a highly useful system view called sys.master_files. If you’ve never encountered it before it returns a list of...
2016-06-01 (first published: 2016-05-23)
1,582 reads
I hate saying no
I really do. There is a joke that DBAs say no to everything and there is some truth to that....
2016-05-31
750 reads
Connecting to Azure SQL Database
Recently I created my first Azure SQL Database. But now I need to connect to it.
You can connect using...
2016-05-25
545 reads
RAID your backups
Let’s start with a very brief definition of some RAID levels.
RAID 0 : Stripe your data across multiple disks. Writing a...
2016-05-24 (first published: 2016-05-16)
1,475 reads
Re-Evaluating Best Practices
I was reading a blog post from my friend Randolph West (b/t) on Best Practices and a thought struck me.
Starting...
2016-05-18
473 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