Scalar Valued Functions in SQL Server 2019

One of the coolest new performance improvements in SQL Server 2019 is a better support for Scalar Valued Functions. As you (hopefully) know, Scalar Valued Functions always introduced a huge amount of performance problems – based on their implementation in SQL Server. Scalar Valued Functions prior SQL Server 2019 I ...

Read more

SQLpassion Online Training in June 2019

On June 24, 2019 I’m running a one-day long webinar about SQL Server Query Tuning Fundamentals. In this one-day long webinar you will learn about: How to access your data through Indexes Heap Tables Clustered Index Non-Clustered Index Index Scans Index Seeks Execution Plans Overview Estimated Execution Plan Actual Execution ...

Read more

Save 50% on my SQL Server Performance Tuning & Troubleshooting Workshop

As you might know, I’m running next week in Utrecht/Netherlands my SQL Server Performance Tuning & Troubleshooting Workshop. The agenda of this deep-dive workshop is quite impressive: Performance Tuning Fundamentals Extended Events Working with large Databases Transactions & Currency Lock Escalations Deadlocking Latches & Spinlocks Troubleshooting TempDb Performance Monitoring Performance ...

Read more

SQL Server on Linux – how does it actually work?

Over the last few weeks I have already written a lot about how to run SQL Server on Linux, Docker, and Kubernetes. But I haven’t yet talked about how SQL Server can actually run on Linux. Therefore, it’s time today to unveil this little secret 🙂 . Drawbridge When Microsoft ...

Read more

Copyright © 2018 by SQLpassion e.U. · Imprint · Offerings · Academy · Contact · Data Protection · Go to Top