If you are not happy with the results below please do another search
Today I heard a great analogy, and it inspired this post. Execution plans are like flight plans, there are multiple flight paths that can be taken to get from where you are to your ultimate destination. Some plans are more efficient than others, and we want to use those whenever possible. How can I make […]
The post Query Store 101 appeared first on dbWonderKid.
Query Store for Workload Replays This month’s T-SQL Tuesday is hosted by Tracy Boggiano. Tracy invites us all to write about adopting Query Store. Today, I wanted to share my favorite but a very unique way I use the Query Store for Workload Replays. You can read more about the invite in detail by clicking […]
In the beginning of my IT career, I was a developer. I wrote a lot of bad code that didn’t perform well. As more data entered my tables my stored procedures got slower and slower. More data, more problems! I started my career in performance tuning by making my crappy code a little less crappy. […]
Have you ever had a query that runs frequently start to randomly go slower? We all have and without the proper tools and knowledge, this can be hard to figure out because there can be so many different reasons. In this blog post, our goal is to make your query optimization in SQL Server a […]
In my opinion, automation will enhance DBAs. It will allow DBAs to provide more value to the business. Good DBAs will be fine. If you are a DBA with ten years of DBA experience who just repeats year one ten times, this might be a different story for a different blog post. Therefore, automation enhances […]
Here are some news, videos, tips, and links the Procure SQL team would like to share! Near Zero Downtime Migrations Near zero downtime migrations are why Azure SQL Databases can be a subscriber for transactional replication. Habits of Effective Data Leaders How many of these seven effective habits do you see at your job? AI Coming […]
SQL Server 2022 was announced yesterday at Microsoft’s Ignite Conference. Here are some of the items that caught our attention. This includes SQL Server 2022 Announcements and other announcements around the Microsoft Data Platform. SQL Server 2022 First Thoughts The following is a summary of some of my favorite announcements with some initial thoughts. Bi-directional […]
While not all implicit conversions are equal implicit conversions matter. For example, just this week I ran into a trivial code change that caused some severe regression in performance. One simple filter change caused a query to consume 227 million reads compared to 212 reads. What did the filter do? Well, it forced an implicit […]
How do I fix this? If you found this page you most likely either found yourself in the middle of a SQL Server parameter sniffing and/or data skew issue and have no idea how to get yourself out of this hole. In the eight-minute video below we go over exactly what parameter sniffing and data […]
Automatic Tuning: Scalar Functions with SQL Server 2019 Learn how SQL Server 2019 automatically makes your scalar functions run faster by converting row by row processing to set based processing without any code changes. The Silent Performance Killer: Scalar Functions vs Table Value Functions Learn how scalar functions cause row by row processing which causes […]