Zikato

KEEP PLAN Demystified

Foreword
I was always wondering what the KEEP PLAN hint does. The documentation isn’t very specific (emphasis mine):

Forces the Query Optimizer to relax the estimated recompile threshold for a query.

In...

2022-04-07

59 reads

Everything in SQL Server is waiting for something…this is by design. And most people...

Hey fellow data friends! Wow, March was an absolutely crazy month (in the best...

We value your privacy. This policy explains what personal data we collect and why. What...

hi i never used shared datasets before in ssrs. i created a dataset called...

Hi Is it possible to get distinct values using string_agg Select T1."transType", WHEN T1."TransType"...

Hi everyone, I'm working on optimizing a DELETE query used in a data cleanup...

What types of sources can be used with the Import Flat File Wizard in SQL Server Management Studio (SSMS)?