Viewing 15 posts - 17,341 through 17,355 (of 19,564 total)
gaurav.kothari (2/15/2010)
Thanks to all who have responded.This indeed helped me and hope that this discussion ahead will help a lot like me.
--Gaurav
You're welcome.
February 15, 2010 at 9:45 am
jcrawf02 (2/15/2010)
Derek Dongray (2/15/2010)
jcrawf02 (2/12/2010)
February 15, 2010 at 9:43 am
Thanks Ron for posting that info.
February 14, 2010 at 8:31 pm
Lutz, It would definitely be better to let SQL determine what data got cached. That was one of the points made in the article I referenced. Another point...
February 14, 2010 at 8:28 pm
I think you might find this thread to be an interesting read.
It is suggested to use Global temp tables there. However, temp tables are not stored entirely in memory.
February 14, 2010 at 3:57 pm
I have seen examples of people doing it. They build a pretty good case for it and without performance problems.
I don't do it that way myself.
The answer to the...
February 14, 2010 at 3:51 pm
d'oh
I missed this question due to going with documentation stating that 0 is the value that should be set.
Most people have missed it so far - and that is kind...
February 14, 2010 at 3:41 pm
Jeff - nice followup
sandhyarao49 - you're welcome.
February 14, 2010 at 3:32 pm
GilaMonster (2/14/2010)
CirquedeSQLeil (2/13/2010)
February 14, 2010 at 1:44 am
Please read the article by Gail Shaw in my signature block.
February 14, 2010 at 12:25 am
You may need to check your collation settings. Not the same issue - but similar and with their solution
February 14, 2010 at 12:18 am
Viewing 15 posts - 17,341 through 17,355 (of 19,564 total)