Viewing 15 posts - 1 through 15 (of 22 total)
Steve Jones - Editor (12/2/2007)
It's indicated in the registry keys, but it doesn't affect operation.
Steve,
Thanks - you wouldn't happen to know the exact key would you? I've looked through all...
December 3, 2007 at 3:51 am
Steve,
So, from a technical perspective (though obviously not a legal one) it doesn't make any difference what licence mode you select when you install SQL Server, because you can go...
November 29, 2007 at 9:18 am
Robin,
This may work in Management Studio (SQL 2005) but this features is not available in SQL Query Analyzer (from SQL 2000).
The clue's in the title of this thread! 😉
Adam
November 13, 2007 at 8:17 am
And when I revert to the original SQL, it goes off and finds the old cached version, and uses that again, and doesn't generate a new plan? I doubt it.
I've...
August 17, 2007 at 5:31 am
The performance of the query, when the varaibale passed to the SP is copied into a new local variable is fine - it takes less than a second.
I'm more concerned...
August 16, 2007 at 2:19 am
Sergiy,
Thanks - I'll give it a go.
Regards
Adam
August 15, 2007 at 9:30 am
Sergiy,
No, there are 68 records in tblPrompts, which have a LabelID of 27 in tblPromptLabels (which is a join table for a many-many join) that also don't appear in the...
August 15, 2007 at 5:42 am
Sergiy,
Yes, the Hash Tables version runs the fastest
tblPrompts has 15167 rows
tblPromptTranslations has 244783 rows
tblPromptLabels has 162010 rows
The result of the query has 68 rows.
Regards
Adam
August 15, 2007 at 4:36 am
Sergiy,
Here is the SQL for the two versions of the SP, the code used to call it, and the generated execution plans.
It is displaying exactly the same behaviour as shown...
August 15, 2007 at 4:15 am
Phil,
Thanks - that is useful.
I've found something very strange doing this. See the SQL and the execution plans below. It makes a big difference to the execution plan if I...
August 15, 2007 at 2:49 am
Steve,
I wondered if it was just creating a new plan, but I tried removing the new variable, and it reverted back to the old Execution Plan, so it really is...
August 14, 2007 at 8:46 am
Paul,
The way it stopped working (even though it was previously fine) is another symptom I noticed.
After I fixed this SP, I found another with the same problem, although several others...
August 14, 2007 at 7:45 am
Yes, and it doesn't make a difference.
Adam
August 14, 2007 at 6:18 am
But I tried all that, as I said in my original post
I ran 'ALTER PROCEDURE', I ran sp_recompile, I even dropped and recreated the SP, and this didn't make a...
August 14, 2007 at 6:04 am
Paul,
That works! Thank you 🙂
It makes no sense though - why should it make such a difference?
Thanks
Adam
August 14, 2007 at 5:18 am
Viewing 15 posts - 1 through 15 (of 22 total)