David Randolph

icon indicating a website link http://www.tuningbell.com icon indicating an email [email protected]

icon company Tuning Bell Studios icon location Chicago, Illinois, USA icon location Research Specialist at the University of Illinois College of Medicine. Schilke aficionado.

Results 5 comments of David Randolph

SCD documentation is incorrect

Do the p values imply you have some support for three-party computation?

Improve SQL Server Incremental Statement

One little tweak to make it work: ``` echo ' with ids as ( select top 400000 "BillingTransactionKey" from "dbo"."BillingTransactionFact" where "BillingTransactionKey" > coalesce({incremental_value}, 0) order by "BillingTransactionKey" asc )...

Improve SQL Server Incremental Statement

In the interests of full disclosure, we did also more than double the TEMPDB storage on SQL Server. This may have something to do with my observed performance improvement. But...

Improve SQL Server Incremental Statement

Also, we are running SQL Server version 15.0.4410. YMMV.

Improve SQL Server Incremental Statement

Okay, my subquery hack is not including all records. I really thought using "top" in a subquery would honor the "order by," but after all iterations, I find a bunch...