2013-07-31 (first published: 2008-07-15)
1,610 reads
Scripts
2013-07-30 (first published: 2013-06-12)
1,528 reads
The Ultimate Index Width Stats Reporter
Reports index length stats for indexes who's lengths exceeding parametrized thresholds (defaults to 0 - get all) for total length and seek length, optionally filtering schemas and tables.
2013-07-26 (first published: 2009-01-16)
2,322 reads
2013-07-25 (first published: 2002-03-19)
3,753 reads
Find unused jobs
Job list cluttered?
This script will return a list of jobs that either have not run in X months or where the next schedule run date is older than today.
2013-07-24 (first published: 2013-06-25)
1,273 reads
2013-07-22 (first published: 2009-04-30)
3,902 reads
2013-07-19 (first published: 2013-07-01)
657 reads
The Automated DBA: Space Usage Snapshotter (sysadmin; central DB)
Records snapshots of space usage & buffer cache usage stats by partition, index, table, schema, filegroup, & database. Stats incl Reserved, Used, Data, buffer cache for row, lob, & overflow.
2013-07-17 (first published: 2009-05-30)
2,785 reads
Simple and efficient way to split string with seperator
Split a string with separator without looping. Can be efficiently used with joins if necessary.
2013-07-12 (first published: 2013-06-15)
2,422 reads
2013-07-10 (first published: 2013-06-19)
1,638 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
BCA KCU TEGAL | Tlp/Wa:0817866887
Tlp/Wa_Cs:0817-866-887 Jl. A. R. Hakim No.2, Mangkukusuman, Kec. Tegal Tim., Kota Tegal, Jawa Tengah...
BCA KCP Dakota | Tlp/Wa:0817866887
Tlp/Wa_Cs:0817-866-887 Jl. Dakota No.Raya 42, H dan 46, Sukaraja, Kec. Cicendo, Kota Bandung, Jawa...
BCA KCP Mohamad Toha | Tlp/Wa:0817866887
Tlp/Wa_Cs:0817-866-887 Jl. Moch. Toha No.197, Cigereleng, Kec. Regol, Kota Bandung, Jawa Barat 40253 @BCA...
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