Viewing 15 posts - 12,211 through 12,225 (of 18,923 total)
Or in a query :
where MyColum like @Letter + '%'
November 15, 2005 at 10:47 am
How about using the correct design and creating a third table?
November 15, 2005 at 5:00 am
Didn't mean to insult you in any way!
What did I say wrong?
November 15, 2005 at 4:57 am
Now that you're all vented away
..
Search this site for parameter sniffing and how it affects procs just like you described. Basically you...
November 14, 2005 at 8:35 pm
Why not just Q.year, ...?
November 14, 2005 at 4:48 pm
Can you show us a few exemples on the questionable keys in their tables?
November 14, 2005 at 2:29 pm
Check the permissions of the users accessing the objects.
November 11, 2005 at 6:59 pm
Number of posts. The incrememnts are very low at the beginning. (like 10, 25, 50, 75, 100...) While I don't remember them all I know it finally...
November 11, 2005 at 8:34 am
A deterministic function could be used for this. Just send the identity as the input parameter and you're golden. No impact on inserts or updates. However the...
November 11, 2005 at 7:51 am
Check the books online. You need to convert the data to the ainsi complient format (112 I think). That will make the column deterministic so you can index...
November 10, 2005 at 10:50 am
You wouldn't see any boost in performance in the computed column solution unless it was indexed as well...
November 10, 2005 at 8:48 am
You only need to use it with the order by clause. It has something to do with getting the best execution plan possible... but I can't elaborate much more...
November 10, 2005 at 7:58 am
HTH.
November 9, 2005 at 11:11 pm
Can you convert the sp into a function so you can use it in a select?
November 9, 2005 at 2:56 pm
It is considered a best pratice to ALWAYS specify the owner of the object (any object). This is one of the many reasons. Also I think you can...
November 9, 2005 at 12:38 pm
Viewing 15 posts - 12,211 through 12,225 (of 18,923 total)