What could you achieve with 60% more time?
Regardless of your job or industry, do you ever have enough hours in the day to get everything done? If...
2019-01-21
194 reads
Regardless of your job or industry, do you ever have enough hours in the day to get everything done? If...
2019-01-21
194 reads
In 2018, companies looked for ways to improve their database performance and security. Their aim was to keep up with...
2019-01-07
297 reads
In 2018, companies looked for ways to improve their database performance and security. Their aim was to keep up with ever-higher expectations of speed, privacy and returns on investment....
2019-01-07
6 reads
It’s 20 years since Google was launched, the Euro was agreed, and the Three Tenors sang at the World Cup...
2018-12-17
221 reads
It’s 20 years since Google was launched, the Euro was agreed, and the Three Tenors sang at the World Cup opening ceremony. That was also the year (1998) when...
2018-12-17
5 reads
As you’re enjoying the festivities this month, spare a thought for your database administrators and IT teams. It’s one of...
2018-12-03
349 reads
As you’re enjoying the festivities this month, spare a thought for your database administrators and IT teams. It’s one of the busiest and most stressful times of the year...
2018-12-03
7 reads
“You’ve got to start with the customer experience and work backwards to the technology.” You’ve probably heard this, and other...
2018-11-20
273 reads
“You’ve got to start with the customer experience and work backwards to the technology.” You’ve probably heard this, and other similar UX advice, before. We are passionate believers in...
2018-11-20
7 reads
Modern businesses are data-driven. Many business leaders will tell you it is the “lifeblood” of their company. Good data helps...
2018-11-07
276 reads
I am responding late to a T-SQL Tuesday invite from John Sterrett. John’s call...
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...
Comments posted to this topic are about the item How a Legacy Logic Choked...
Comments posted to this topic are about the item People Make Odd Choices
Comments posted to this topic are about the item SQL Server 2022 Clusterless Distributed...
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