Trim Left Char (for single words)
Remove the first replications of a specified char in a word. It does not work well with text that contains blank spaces in the middle.
2012-08-16 (first published: 2012-08-02)
955 reads
Scripts
Script to get an ordered list of all stored procedures with parameters
Generate a per-schema, per-procedure ordered list of all stored procedures for the current database, together with their parameters, datatypes and nullability.
2012-08-14 (first published: 2012-08-08)
2,251 reads
List of objects from particular schemas
This helps to get list of all objects in a particular schemas.
2012-08-13 (first published: 2012-08-08)
1,158 reads
2012-08-13 (first published: 2012-07-31)
1,790 reads
2008 Index Rebuild using DMV
Index Maintenance procedure with HTML Reporting capabilities. Please refer to attached script for detailed information.
2012-08-09 (first published: 2012-07-26)
1,662 reads
Calculate alphabetic sequence
This simple function allows to calculate a code sequence of letters. AAA, AAB, AAAC, ADF, .... AAZ, ABA, ABC, ... ZZZ
2012-08-08 (first published: 2012-07-25)
956 reads
2012-08-03 (first published: 2008-01-09)
2,322 reads
2012-08-01 (first published: 2008-02-15)
3,219 reads
2005 Online Index Rebuild using DMV
Identifies indexes with average logical fragmentation >= 30% using the DM available in MSSQL 2005. Please refer to script for more information.
2012-07-31 (first published: 2007-10-09)
4,376 reads
2012-07-25 (first published: 2012-07-12)
2,518 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