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

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

262 reads

Blogs

Fixing the PoSh Hotkey in ADS

By

I installed the PowerShell (PoSh) extension in ADS recently. This is available in the...

Capture Execution Plans Only For Long Running Queries

By

I love questions. Most of all, I love questions I can answer. I spotted...

Daily Coping 28 Sep 2020

By

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

Read the latest Blogs

Forums

SSRS - Filtering data in a report

By dduensing

I have a dataset (Name, Product A Installed, Product B Installed, Product 3 Installed,...

SQL Server Always On Availability Group Lab Setup

By sizal0234

Hi, I wanted to setup/practice Availability Groups( Refer to the below link article) at...

Keeping Your Staff

By Steve Jones - SSC Editor

Comments posted to this topic are about the item Keeping Your Staff

Visit the forum

Ask SSC

SQL Server Q&A from the SQLServerCentral community

Get answers