SQL Server Bugs That Might Bite You
I’m on my way to give a presentation at the PASS Database Administration Virtual Chapter about SQL Server bugs. All the materials...
2014-12-10
496 reads
I’m on my way to give a presentation at the PASS Database Administration Virtual Chapter about SQL Server bugs. All the materials...
2014-12-10
496 reads
In just a little while, I’m going to give a presentation at the PASS Performance Virtual Chapter. You can download...
2014-11-20
451 reads
One of our customers is implementing a very large consolidation project in which they enable users to create their own...
2013-01-08
301 reads
I gathered the 4 most common bugs I find DBA are using in their code. Feel free to send me...
2012-11-11
456 reads
Hi,
Yesterday I delivered a session on Parallel Processing at the Israeli User Group.
I had a great time and hope you...
2012-06-05
314 reads
What comes first, the chicken or the egg? What happens first – update statistics or re-compilations?
The Statistics life cycle
As a regular...
2012-01-18
360 reads
Look at the following 3 scripts:
-- 1. Hardcoded
SELECT
*
FROM
Sales.Orders
WHERE
DateAndTime < '19900101'
-- 2. Variable
DECLARE @FilterDate DATETIME = '19900101'
SELECT
*
FROM
Sales.Orders
WHERE
DateAndTime...
2012-01-02
422 reads
2011-09-03
341 reads
Hi Everybody,
Congratulation to Yair Gutman who won a free ticket to the Advanced Programming in SQL Server 2008 R2 Course...
2011-08-28
316 reads
Hi Everybody,
Congratulation to Yair Gutman who won a free ticket to the Advanced Programming in SQL Server 2008 R2 Course...
2011-08-27
434 reads
By Chris Yates
AI is no longer a niche capability – it is a leadership catalyst. As...
By Steve Jones
A friend was asking for help with some data analysis. This was in PowerBI,...
By Rohit Garg
The internet relies on IP (Internet Protocol) addresses to identify devices and route traffic....
Comments posted to this topic are about the item How a Legacy Logic Choked...
Hi i was surprised to see the approach my coworkers used to sunset talend...
Comments posted to this topic are about the item People Make Odd Choices
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