Ask HN: Would you run SQL Server on Linux?
Hacker News is one of the best sources for technical news out there. I check HN at least once a...
2017-09-28
567 reads
Hacker News is one of the best sources for technical news out there. I check HN at least once a...
2017-09-28
567 reads
I no longer install SQL Server on my workstation, I use Docker to spin up instances as and when I...
2017-08-22
1,763 reads
This is the ninth part in the series: SQL Server and Continuous Integration. In this post I’ll add some unit tests...
2017-07-31
1,797 reads
T-SQL Tuesday is a monthly event where SQL Server bloggers write a post based on a subject chosen by the...
2017-06-22 (first published: 2017-06-13)
6,416 reads
As of CTP 2.1 for SQL Server 2017 a set of new environment variables are available. These variables allow us...
2017-05-17
3,412 reads
I’d like to say a huge thank you to everyone who read or published a post for T-SQL Tuesday #90....
2017-05-16
412 reads
I was once asked to add a new feature to an application. It was installed on multiple SQL Server instances...
2017-05-02
400 reads
T-SQL Tuesday is a monthly event where SQL Server bloggers write a post based on a subject chosen by the...
2017-04-11
598 reads
This is the eighth part in the series: SQL Server and Continuous Integration. This post describes the set-up required for GitLab runners to...
2017-04-07 (first published: 2017-03-22)
8,110 reads
T-SQL Tuesday is a monthly event where SQL Server bloggers write a post based on a subject chosen by the...
2017-03-24 (first published: 2017-03-14)
1,869 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 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