Add-In for searching object in SSMS without touching mouse
I was using various “quick find” SSMS add-ins which give you ability to get your tables, stored procedures, functions and...
2011-11-07
1,010 reads
I was using various “quick find” SSMS add-ins which give you ability to get your tables, stored procedures, functions and...
2011-11-07
1,010 reads
Hi,
new, second version of SQL Treeo productivity add-in was released.
For little reminder, here are main features of this add-in:
Create...
2011-11-06
2,418 reads
SQL Server 2011 “Denali” CTP3 introduced couple of new Dynamic Management Views (DMV). However, documentation says that some of them...
2011-09-14
732 reads
SQL Server DMV Views might be very helpful. Let’s imagine that you have a couple of nested stored procedures and...
2011-09-08
1,775 reads
Microsoft SQL Server guys extended periods for Denali’s feedback on Microsoft Connect. And they motivates with really nice gifts for...
2011-09-05
638 reads
Few weeks ago I released my SSMS productivity add-in and it has already almost 200 downloads. Responses are quite warm...
2011-08-29
834 reads
Writing data from within user-defined function is not permitted. You cannot use any INSERT/UPDATE/DELETE/MERGE statement because they’re “side-effecting” for SQL...
2011-08-28
1,224 reads
SQL Server 2011 “Denali” is quite rich for new functions which have really good practical use in T-SQL. I’ve read...
2011-08-14
648 reads
I’ve just finished promised SSMS add-in which enables creating of custom folders directly in SSMS Object Explorer. Idea for add-in...
2011-08-08
3,138 reads
SQL Server 2011 “Denali” introduces couple of new procedures which enable you to read query metadata without executing it. Previous...
2011-08-03
1,014 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