The June Energy Update (2007)
Steve Jones takes a look at energy news and how Google and Microsoft are looking to lower their dependence on the grid and advance alternative energy use.
2007-06-27
8 reads
Editorials
The May Car Update (2007)
Steve Jones takes a look at the world of automobiles and specifically his new Prius hybrid.
2007-05-29
33 reads
Where Did The Women Go?
A guest editorial today from Atieh Jones wondering where are all the women in IT?
2007-02-14
119 reads
Would I encourage my daughter to pursue a career in IT?
A guest editorial today from Lynda Rab, PASS board member and new mother.
2007-02-13
38 reads
The Old Boys Club
Steve Jones looks at some of the issues with gender in the workplace and reminds everyone that they need to respect each other.
2007-02-12
17 reads
The Certification Debate
Steve Jones talks about the ne value of the new certification program from Microsoft.
2006-11-20
573 reads
The Test of Time
A change here at SQLServerCentral.com and Steve Jones gives some thoughts on the impact of this for the future.
2006-11-13
106 reads
Zap World
Steve Jones brings us a car update that talks about a new car that doesn't need gasoline to run.
2006-11-01
42 reads
2006-10-06
175 reads
Blogs
Microsoft MVP 2025: Continuing the Data Platform Journey
I am honored to announce that I have been renewed as a Microsoft MVP...
What is KTLO? Keep The Lights On vs Project Work in Agile
By Rohit Garg
🔍 Demystifying KTLO: A Deep Dive into Keep The Lights On Work in IT...
The PASS Summit on Tour in Dallas
By Steve Jones
The PASS Summit goes on tour this year, with a September stop in Dallas....
Forums
How a Legacy Logic Choked SQL Server in a 30-Year-Old Factory
Comments posted to this topic are about the item How a Legacy Logic Choked...
Formatting Dates and Times: The SQL Dialect Divide
Comments posted to this topic are about the item Formatting Dates and Times: The...
Query Plan Regressions --
Comments posted to this topic are about the item Query Plan Regressions --
Question of the Day
Query Plan Regressions --
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