Viewing 15 posts - 21,661 through 21,675 (of 22,189 total)
Actually, I can add one more bit of info:
http://www.simple-talk.com/sql/performance/sql-server-performance-crib-sheet/
October 15, 2007 at 5:55 am
Jeff Moden (10/14/2007)
October 15, 2007 at 5:46 am
Jeff Moden (10/13/2007)
October 15, 2007 at 5:42 am
No, we're not searching against it. We simply return it as XML. I have looked into using the XML indexes, but that nine times data storage that I keep reading...
October 12, 2007 at 9:32 am
We are using it in some places. The purpose is pretty much self-explanatory, we want to persist XML data and having an XML data type for storage ensures that we're...
October 12, 2007 at 8:34 am
I can't replicate the behavior. I tried using trusted connections & sql connections and unchecking the "remember password" on the connection window. Once I'm connected to a server, every time...
October 12, 2007 at 6:19 am
Correct me if I'm wrong, but doesn't the black box trace only keep a rolling set of data? You'll need to set up an actual trace. Make it to file...
October 12, 2007 at 6:09 am
I have to agree. The inner join seems like the most logical approach.
Using the same temp tables above:
UPDATE #TableA
SET Col3 = b.ColC ,
Col4 = b.ColD,
Col5 = b.ColE
FROM #TableA a
INNER JOIN...
October 12, 2007 at 5:53 am
I'm not sure I have the precise answer, but I was just reading how certain errors can't be trapped at the moment of execution, but can be at a level...
October 11, 2007 at 11:58 am
Nothing there, you may want to repost.
However, assuming the XML is well formed, you have multiple options for importing it.
October 11, 2007 at 11:48 am
Definitely go for the varchar(max). The only down sides are disk space, but that's easily monitored.
October 11, 2007 at 11:37 am
I wasn't going to comment on the Tuning Advisor, but since the gate is now open... I haven't had good experiences with the Advisor either. I haven't had it ruin...
October 11, 2007 at 7:19 am
Oh, and, I'd offer to help her work on her performance issues in order to clean up her system enough so that you can connect to it.
October 11, 2007 at 7:03 am
Steve's correct. Further, some degree of processing will occur on both of the servers, no matter what. Bare minimum, depending on what kind of server you're linking to and how...
October 11, 2007 at 6:59 am
Viewing 15 posts - 21,661 through 21,675 (of 22,189 total)