Bert Wagner

Recursively Querying Row Groups

Recursively Querying Related Rows Recursive queries are fun to plan and write. They can be frustrating too depending on the complexity of the problem you are trying to solve....

2020-09-02 (first published: )

524 reads

Moving 1/3 of a heap

Watch this week’s video on YouTube. A Giant Heap Recently I had to filter out 1.2 billion records from a 3.5 billion row heap. Don’t ask me why this...

2020-08-03 (first published: )

263 reads

Blogs

Power BI Monthly Digest – October 2020

By

In this month’s Power BI Digest Matt and I will again guide you through...

Daily Coping 26 Oct 2020

By

I started to add a daily coping tip to the SQLServerCentral newsletter and to...

Welcome to 3Cloud …

By

A little over a month ago, Pragmatic Works Consulting was a part of a...

Read the latest Blogs

Forums

Dividing data equally in 4 sessions

By S_Kumar_S

Hi All I have a table which contains the transactions done by cards. Below...

Unique value constraint among active records

By CanuckBuck

I have a lookup table that implements a system-generated Id for DRI purposes.  The...

Textfield comparator.

By ben.brugman

A client would like to be able to recognize similar free-texts in a text...

Visit the forum

Ask SSC

SQL Server Q&A from the SQLServerCentral community

Get answers