Letter To My Father
We spread my Fathers ashes over the past weekend. It was one of the hardest things...
2019-09-06 (first published: 2019-08-22)
501 reads
We spread my Fathers ashes over the past weekend. It was one of the hardest things...
2019-09-06 (first published: 2019-08-22)
501 reads
Greetings everybody! It has been a while since I posted anything here. I figured I...
2019-04-26 (first published: 2019-04-15)
752 reads
Hello all!
This year at PASS Summit, I will be distributing the below ribbons once again to ANY and ALL Service...
2018-10-10
184 reads
Hello everybody! Greetings from the very warm state of Texas! One of the most popular questions I get when talking...
2018-08-23 (first published: 2018-08-02)
2,015 reads
Hello everybody! Thank you once again for stopping by and reading. April has been pretty busy with presentations, and I...
2018-04-25
98 reads
Hello everyone! I recently had to do an analysis of a client’s database workload using the Azure DTU Calculator(DTU Calculator)...
2018-04-24
1,186 reads
Hello everybody! Thanks for stopping by again. In Part 1 of this series, I gave the background of the project, and...
2018-04-02
112 reads
Hello everybody!
I have been working with one of my favorite clients lately on migrating their SQL databases to a DBaaS...
2018-02-10
129 reads
I have the priveledge of speaking at two SQLSaturday events coming up in the near future. This is the first...
2018-01-02
110 reads
Connecting to Failover Group
So in Part 1 of this series, we created and configured our Failover Group. Well, now that...
2017-12-26
112 reads
It’s been forgotten about and neglected for few years but I’ve decided to dust...
I am honored to announce that I have been renewed as a Microsoft MVP...
By Rohit Garg
Demystifying KTLO: A Deep Dive into Keep The Lights On Work in IT...
Comments posted to this topic are about the item How a Legacy Logic Choked...
Comments posted to this topic are about the item Navigating Multi Platform Realities in...
I have tried a number of times to export and then import my SSMS...
For the Question of the day, I am going to go deep, but try to be more clear, as I feel like I didn't give enough info last time, leading folks to guess the wrong answer... :) For today's question: You’re troubleshooting a performance issue on a critical stored procedure. You notice that a previously efficient query now performs a full table scan instead of an index seek. Upon investigating, you find that an NVARCHAR parameter is being compared to a VARCHAR column in the WHERE clause. What is the most likely cause of the query plan regression?
See possible answers