TSQL Snippet for viewing basic info on database principals and their permissions
Quick snippet I put together for reviewing basic info on database users/principals, permissions, and members if the principal is a...
2013-05-31
1,522 reads
Quick snippet I put together for reviewing basic info on database users/principals, permissions, and members if the principal is a...
2013-05-31
1,522 reads
Msg 402, Level 16, State 1, Line 67
The data types varchar and void type are incompatible in the add...
2013-05-30
1,368 reads
For sake of future generations, let’s begin to reduce typing and reuse code we’ve built. I think we can all...
2013-05-22
1,296 reads
Snippet to quickly view computed column information. You can also view this by doing a “create table” script. This however,...
2013-05-22
569 reads
If you want to audit your enviroment to look at all your synonyms and see where they are pointing, you...
2013-05-21
807 reads
SQL Server Management Studio (SSMS) is not offered as a standalone download on MSDN.
Installation requires the user to download the...
2013-05-07 (first published: 2013-04-30)
26,598 reads
Handling dates is always a fun challenge in T-SQL! Finding the current end of month and next months beginning of...
2013-05-01
2,217 reads
Snippet to designate a certain time of the day to evaluate in the current day. If you need to limit a...
2013-04-23
351 reads
Intellisense can be a boon to adding quick development. Quick hints on scope specific variables, syntax suggestions, function descriptions and...
2013-04-22
913 reads
Dynamic SQL can be helpful, but a pain to debug. I spent hours today working on figuring out why my...
2013-04-18
429 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 SQL Server 2022 Clusterless Distributed...
Comments posted to this topic are about the item Navigating Multi Platform Realities in...
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