XML Attribute VS Element Assignment when working with SQL
XML handling with aliases
I find it interesting the difference in behavior with querying XML between column assignment, and quoted alias...
2015-09-21
301 reads
XML handling with aliases
I find it interesting the difference in behavior with querying XML between column assignment, and quoted alias...
2015-09-21
301 reads
XML handling with aliases
I find it interesting the difference in behavior with querying XML between column assignment, and quoted alias...
2015-09-21
189 reads
Split personality text editing in SSMS with Sublime Text 3
My preview post showed a demonstration of the multi-cursor editing power...
2015-09-14
199 reads
Split personality text editing in SSMS with Sublime Text 3
My preview post showed a demonstration of the multi-cursor editing power...
2015-09-14
1,088 reads
Yes… multicursor editing is epic No… SSMS doesn’t support multi-cursor editing the way it should. Yes… you can do some...
2015-09-10
2,248 reads
- Yes… multicursor editing is epic
- No… SSMS doesn’t support multi-cursor editing the way it should.
- Yes… you can do some...
2015-09-09
162 reads
It was entertaining to listen to a technical wizard fighting the obsession with waiting to eat chocolate with 3k viewers...
2015-08-27
301 reads
It was entertaining to listen to a technical wizard fighting the obsession with waiting to eat chocolate with 3k viewers...
2015-08-27
201 reads
Monitoring SQL Server on a budget
Cheap ain’t easy
There’s a lot of tools out there, and very few that are polished,...
2015-08-18
314 reads
Monitoring SQL Server on a budget
Cheap ain’t easy
There’s a lot of tools out there, and very few that are polished,...
2015-08-18
391 reads
Ivan Jelić, Group CEO at Joyful Craftsmen, reflects on what separates AI success from...
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,...
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