No problems with 22.3.0. No extensions. Responds quicker overall

The <> will be slow as you still have to compare claims since 2019

Depending how often it has to run it may benefit from a computed column (logic) + index...

Please provide some sample data and expected results in an easily consumable way. Like an sql script we can execute in a sandbox

Happy Anniversary. Still my goto site for SQLServer since 2003

Forum decided it didn't like links

Search for "sqlstudies" "partitioning-on-a-nullable-column"

Mostly it is about widening the skillset, learning about new features, problems and solutions. Also a meeting ground with ex-peers.

Lack of decision power makes it harder to visit the sponsor...

The absence of notifications did a lot. Anyway there is a new version of Visual Studio 2026 and SSMS 22 (instead of 21)

Thanks Chandan Shukla for the extensive answer. That was the info I was looking for.

Give it a few more years. Sora 2 is already making plausible fake video's.

There's also a lot of progress on the mobility of robots

if you have the queryplan you can view if it's being used

from stackoverflow "sql server check if index exists on temp table" (copied because there forum doesn't like links lately)

Still allright but the cold/flu is coming to town

Is there an order by? You can have duplicates and sql may pick a random duplicate without order by

Thanks Grant for coming to Dataminds Belgium. Did you have a good signal with that large antenna?

Thanks for the extensive write up.

Could you mention "Important Licensing Note: The AWR-based queries above require Oracle's Diagnostic and Tuning Pack license. If you don't have this license, stick with...

Thanks for showing what is available in the mssql VSCode-extension