Help with Learning Powershell
If you’re not reading Buck Woody’s blog, why not? Today he posted a helpful hint for getting performance counters directly...
2010-02-26
1,390 reads
If you’re not reading Buck Woody’s blog, why not? Today he posted a helpful hint for getting performance counters directly...
2010-02-26
1,390 reads
What the heck is wrong with you?
Still interested? Fine. I’ll tell you my take on this whole business. I’m only...
2010-02-19
697 reads
I realize I’m prejudiced, being one of those evil DBA’s & all, but I can’t help but agree with him. It’s...
2010-02-16
776 reads
I’m getting my first look at a full-fledged nHibernate database developed by consultants for our company. I thought I’d share...
2010-02-15
1,286 reads
Today we have a guest editorial from Grant Fritchey that discusses the idea of rules based on certain types of measurements. Are they worth following? Or do we need to develop our own measures.
2010-02-08
361 reads
Whew!
It’s over. New England Data Camp v2, aka, SQL Saturday #34, was completed on Saturday. Going in we had maxed...
2010-02-01
579 reads
The event is this Saturday. Take a look at our sponsors, speakers and the program. It’s going to be a...
2010-01-27
586 reads
Phil Factor’s most recent guest editorial over at SQL Server Central has, to a degree, pointed out that the emporer’s...
2010-01-25
801 reads
I needed to create an identical index on a bunch of tables within one of my projects (yes, I know...
2010-01-21
1,804 reads
Buck Woody recently asked a question; how do you design a database. He outlined the process he followed and asked...
2010-01-18
1,909 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