SQL Server Consulting, Education, and Training
This is documented, but I know a lot of people are allergic to documentation, whether it’s writing or reading.
In SQL Server 2019:
You already know that your temp table needs an index. Let’s say there’s some query plan ouchie from not adding one. You’ve already realized that you should probably use a clustered index rather than a nonclustered …
Let’s say you’re on SQL Server 2019. No, seriously. It’s been out for a couple weeks now.
You could be.
I say that you could be because you’re the kind of brave person who tries new things and …
Thanks for watching!…