Thanks for the tip! You are always Jeremy-on-the-spot! Thank you for your
contributions!
On Thursday, February 24, 2022 at 7:30:10 PM UTC-6 Jeremy Evans wrote:
> On Thu, Feb 24, 2022 at 3:47 PM Tim Tilberg wrote:
>
>> Today I was scripting out some DB maintenance tasks on SQL Server, and
>> wa
On Thu, Feb 24, 2022 at 3:47 PM Tim Tilberg wrote:
> Today I was scripting out some DB maintenance tasks on SQL Server, and was
> leveraging a query similar to:
>
> SELECT DISTINCT create_ts
> FROM #{table}
> WHERE create_ts < DATEADD(MONTH, -2, GETDATE())
>
> I initially thought "Hey, what does
Today I was scripting out some DB maintenance tasks on SQL Server, and was
leveraging a query similar to:
SELECT DISTINCT create_ts
FROM #{table}
WHERE create_ts < DATEADD(MONTH, -2, GETDATE())
I initially thought "Hey, what does this look like with virtual row blocks,
avoiding interpolation?