Jumping the Gun - Why Did I Write This?
Why did I write this? I got challenged by Andy Warren
to write a bit about why I wrote something. I...
2008-10-02
332 reads
Blog Posts
Never say 'never' to the WHILE loop.
/* download the test text file Moby-Dyck.zip here */
/* You might notice that I refer to Moby **** in this blog. This is because the busybodyish...
2008-10-02
2,209 reads
A Focus on Novice DBAs: My Upcoming PASS Presentations
The PASS Community Summit 2008 is coming up fast (November 18-21, 2008), and if you are attending and you are...
2008-10-01
599 reads
Managing My Todo List
I think everyone struggles with keeping track of things they need to do, and it's all too easy to get...
2008-10-01
476 reads
Reminder - MVP Andy Leonard Midlands PASS!
Speaker: SQL Server MVP Andy Leonard
Midlands PASS Chapter - October 2, 2008 Meeting
The Midlands PASS chapter will hold our normally scheduled...
2008-10-01
917 reads
When Will You Begin Implementing SQL Server 2008?
As I have been talking to DBAs around the country, I have noticed a trend that many, if not most,...
2008-10-01
366 reads
Notes from the Sep 24, 2008 Orlando .Net User Group Meeting
I don't seem to find the time often, but recently I was able to fit in another visit to the...
2008-09-30
1,373 reads
Returning Stuff to Amazon
I've used Amazon for years for the sheer convenience, and recently was the first time I ever needed to return...
2008-09-29
1,455 reads
SQL Saturday Orlando
Make sure you make it to the next SQL Saturday event that I will be speaking at October 25, 2008...
2008-09-29
1,297 reads
Technical Difficulties
Always something going wrong around here with the podcasts. Today I was editing a couple, or attempting to, and couldn't...
2008-09-29
1,440 reads
Blogs
Time to Revive our YouTube Channel
It’s been forgotten about and neglected for few years but I’ve decided to dust...
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...
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...
Navigating Multi Platform Realities in My Database Life
Comments posted to this topic are about the item Navigating Multi Platform Realities in...
Import/Export SSMS Settings issue
I have tried a number of times to export and then import my SSMS...
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