Can you open it with Profiler?

You're welcome.

jcrawf02 (2/15/2010)

---

Derek Dongray (2/15/2010)

---

jcrawf02 (2/12/2010)

---

Speaking of psychological response interview questions, anyone watch "the Middle"? favorite interview of all time now is "If you could be any color, what color would...

Thanks Grant

Thanks Ron for posting that info.

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

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.

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

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

Jeff - nice followup

sandhyarao49 - you're welcome.

GilaMonster (2/14/2010)

---

CirquedeSQLeil (2/13/2010)

---

The default behavior of SQL server is to apply a Clustered Index to the Primary Key. You may or may not already have on index on that...

Goal review time

Please read the article by Gail Shaw in my signature block.

Article from Microsoft

http://msdn.microsoft.com/en-us/library/ms190954.aspx

You may need to check your collation settings. Not the same issue - but similar and with their solution

http://stackoverflow.com/questions/119477/sql-server-2005-xml-stored-proc-unicode-to-ascii-exception-0xc00ce508