I thought of that as well, only there is not one index that will work best for ALL cases. There is a different index for all scenarios that works...
You will see my queries below. Query 1 uses the value of a varchar variable to determine what to filter using the WHERE clause. Query 2 is hard-coded...
I have a two queries in a stored procedure that both have Bookmark Lookups that take 50% of the query time. Is there any way to speed this up? Also...
The only clustered index is on the primary key (the UID field).
I am running the code below. The table "tblGU" has approximately 188k records in it. I have three indexes created that I feel are valid for this...
Yeah the reason I am concerned is because there is a performance issue with the stored proc. It takes about 10-13 seconds to execute for some...
I read in your recent article about hash joins and how if tables are indexed properly you should not see any hash joins. I have tried every...
The problem with specifying the ORDER BY in a "CASE" is that you have to have the order (ASC or DESC) outside of the case, and it cannot be based on...
Yes I also saw that in the BOL. Was just wondering how I could work-around it. The problem is we allow our users to change the sorting and a few...
After reading your newsletter today and finding out about the Table data type, I am attempting to convert one of my most used stored procedures to...
Separate names with a comma.
