number of rows and columns of an instance
Get the number of rows, columns, and space used by all tables in all databases
2018-10-03 (first published: 2018-09-20)
512 reads
Scripts
Data Collections restart and clear cache files
Script to stop the default Data Collection sets, clear the cache files and then restart collection sets.
2018-10-02 (first published: 2018-09-25)
1,445 reads
Conditionally Order By Different Column
Order records based on a different column depending on which absolute value is greater.
2018-10-01 (first published: 2018-09-26)
645 reads
2018-09-26
470 reads
dba_CopyLogins
A copy of the late Robert Davis' dba_copylogins stored procedure with a bug fix. The SP copies logins, roles, and permissions between servers.
2018-09-24 (first published: 2018-08-28)
1,788 reads
T-SQL to compress (shorten) IPv6 address
Didn't find anything, so hope this will help someone with similar need.
Note I did a similar set-based version, and unless the input is more towards non-zeros in all eight 2-byte fields, the set-based performs not as well
2018-09-19 (first published: 2018-09-12)
599 reads
2018-09-04 (first published: 2018-08-23)
323 reads
FK_Add_Drop_Constraints_AllDBs
This scripts helps to generate ADD / DROP Constraints against single Database.
2018-09-03 (first published: 2018-08-14)
257 reads
2018-08-24 (first published: 2014-06-17)
698 reads
Create Database Snapshot Dynamically
Dynamic SQL can be used to generate a database snapshot. Useful for a database with a number of files.
2018-08-23 (first published: 2016-11-04)
3,540 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