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...
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...
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...
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.
