I'm presenting at 24 Hours of Pass!!
Woohoo! I have been selected to present my SSIS Tips & Tricks presentation at this year's 24 Hours of Pass. I am...
2012-03-04
503 reads
Woohoo! I have been selected to present my SSIS Tips & Tricks presentation at this year's 24 Hours of Pass. I am...
2012-03-04
503 reads
I've been asked on several occassions to provide an example of the custom sources I use in my "SSIS Tips&Tricks"...
2012-02-21
1,340 reads
I've been asked on several occassions to provide an example of the custom sources I use in my "SSIS Tips&Tricks" presentations. I had to build one moments ago and...
2012-02-21
7 reads
I've been asked on several occassions to provide an example of the custom sources I use in my "SSIS Tips&Tricks" presentations. I had to build one moments ago and...
2012-02-21
4 reads
I'll be giving a presentation tomorrow, Tuesday 2/21/2012 at 12PM EST on my Enhanced Threading Framework design. Here is the...
2012-02-21
407 reads
I built a small ruby program a while back to help with two things:
Quickly identify what tables have the highest...
2012-02-16
566 reads
I built a small ruby program a while back to help with two things:
1. Quickly identify what tables have the highest IO in a particular
...
2012-02-16
3 reads
I built a small ruby program a while back to help with two things:
Quickly identify what tables have the highest IO in a particular query
Learn a new language (Ruby)
The...
2012-02-16
2 reads
The other day I was building a simple data import package when I ran into a common situation; invalid conversions...
2012-02-01
727 reads
The other day I was building a simple data import package when I ran into a
common situation; invalid conversions in a Derived Column. The conversion
was taking an ISBN13...
2012-02-01
12 reads
By Rohit Garg
Demystifying KTLO: A Deep Dive into Keep The Lights On Work in IT...
By Steve Jones
The PASS Summit goes on tour this year, with a September stop in Dallas....
By Kevin3NF
Settings That Could Be Hurting Your Performance If you’ve ever created a new SQL...
Comments posted to this topic are about the item How a Legacy Logic Choked...
Comments posted to this topic are about the item Formatting Dates and Times: The...
Comments posted to this topic are about the item 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