talk-data.com

Five stages of grief - internals of a hash spill

Description

You know the Hash Match operator. You know it requires a lot of memory. And you also know that it sometimes needs more memory than it has, in which case it spills to tempdb and is slow. But do you know EXACTLY what happens under the cover in the case of a hash spill? Or does you knowledge stop at "it gets slow"? Unless you work for Microsoft on the SQL Server engineering team, there really is no need to know the internals of a hash spill. But that doesn't mean you can't be curious! Would you like to waste some time to learn about dynamic role reversal, grace hash join, bail-out, bit-vector filtering, and more, then join this sessions!

Do you believe the myths that “Third Normal Form is good enough”, or that “Higher Normal Forms are hard to understand”?

Do you believe the people who claim that these statements are myths? Or do you prefer to form your own opinion? If you take database design seriously, you cannot afford to miss this session. You will get a clear and easy to understand overview of all the higher Normal Forms: what they are, how to check if they are met, and what consequences their violations can have. This will arm you with the knowledge to reject the myths about higher Normal Forms. But, more important: it will make you a better designer!

The final meetup of 2023 will be a set of lightning talks from speakers all over the world.

You can visit the schedule here:

Be aware, the times are in UTC! Timezones are very hard, ask me how I keep learning that...

thankful-field-057fcc110.4.azurestaticapps.net/Index.html

The event kicks off at 16:00 UTC, 17:00 GMT+1, order of speakers:

Deepthi Goguri Sarath Sasidharan Koen Verbeeck Roy Menger Javier Villegas Jon Vöge Hugo Kornelis John Miner

So you know all about heaps, clustered indexes, and nonclustered indexes, but are still not satisfied? Then this is just the session for you! You will learn about advanced features such as included columns, indexed views, and filtered indexes. You will find out how they are stored on disk, and how SQL Server uses them to satisfy queries. Then, you will see the tools SQL Server itself hands you to help identify just the right subset of indexes. And finally, you will get an stunning demonstration of just how bad you can hurt performance by creating too many indexes.