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: )

538 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: )

266 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 3.5 billion...

2020-07-22

Blogs

Getting Started with Robotic Process Automation (RPA) Using the Power Automate Desktop

By

There are a lot of hot phrases you’ve likely heard thrown around during various...

Two methods of deployment Azure Data Factory

By

Azure Data Factory is a fantastic tool which allows you to orchestrate ETL/ELT processes...

Moving the Community Forward

By

Today is the last day that the PASS and SQL Saturday websites will be...

Read the latest Blogs

Forums

Who is my customer?

By Kathi Kellenberger

Comments posted to this topic are about the item Who is my customer?

Newbie; Unsure where to Start?

By ptmuldoon

Hi,  First time poster, and hoping everyone goes easy on me. I am very...

DB corruption error 8905, fixed using repair_allow_data_loss ,

By huishi.ca

hi all, I need some help here. Recently, I've found a db with error...

Visit the forum

Ask SSC

SQL Server Q&A from the SQLServerCentral community

Get answers