Monitoring Resource Governor Memory Grants
A very useful query that will allow you to monitor the resource governor memory grants along with other useful information.
2011-03-03 (first published: 2011-02-14)
3,198 reads
Scripts
Search for a text in all databases
This procedure searches for a specified text in all (or one selected) databases in all (or selected) tables.
2011-03-02 (first published: 2008-01-25)
5,085 reads
2011-03-01 (first published: 2011-02-18)
4,007 reads
Columns Explorer - With constraints create / drop scripts (no cursors)
Gets all columns infos, foreign keys (multicolumn fk handled), referenced primary keys, default and check constraints, indexes, Create/Drop scripts for all constraints.
2011-02-28 (first published: 2011-02-18)
1,589 reads
String tokenizing / splitting
We often have need of string splitting in applications. I had need of one in some T-SQL development I am currently doing for a friend.
2011-02-25 (first published: 2011-02-09)
2,029 reads
Financial Month
This Script will return the respective financial month(Starts from April to March) for a calander month Input(Starts from January to April), May use for many Consolidated Financial Reports.
2011-02-21 (first published: 2011-02-05)
1,529 reads
2011-02-21 (first published: 2011-02-05)
1,954 reads
Search for a specified GUID (or its part) in all databases (updated)
This procedure searches for the specified GUID (or its part) in all (or selected one) databases
2011-02-21 (first published: 2008-01-24)
940 reads
2011-02-18 (first published: 2011-01-25)
3,058 reads
(new) Kill ALL Connections To a SQL Database
Ever puzzled by the database "Currently in Use" error even though you thought all connections had been Killed? That’s because the wrong table SysProcesses was used.
2011-02-15 (first published: 2011-01-26)
3,937 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...
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...
Forums
Alamat kontak resmi BCA KCP Pedurungan | Tlp/Wa:0817866887
Tlp/Wa_Cs:0817-866-887 Jl. Brigjen Sudiarto No.294, Palebon, Kec. Pedurungan, Kota Semarang, Jawa Tengah 50273
Alamat kontak resmi BCA KCP Majapahit Telp:0817866887
Tlp/Wa_Cs:0817-866-887 Jl. Majapahit No.112, Pandean Lamper, Kec. Gayamsari, Kota Semarang, Jawa Tengah 50161
Alamat kontak resmi BCA KCU BANYUWANGI Telp:0817866887
Tlp/Wa_Cs:0817-866-887 Jl. Jenderal Ahmad Yani No.24-26, Panderejo, Kec. Banyuwangi, Kabupaten Banyuwangi, Jawa Timur 68416
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