Hi satya!<br /><br />I did a search with Chang's name as my key and one of the results was a thread wherein you are a subscriber and you gave a link...
Hi, Can someone point me to a site with an article ofone or two that explains how to read the result of an execution plan? If I have for example a...
That did it, I tried using with 00:00:00 date using my posted format and it didn;t worked also. I was wondering why SQL QA only accepts the format...
Still not working
When debugging stored procs, what should be the format for the value of a date parameter? I've tried the following but it's not accepting the value:...
Does bulk copy activate a trigger? Kindly explain if it does. Thanks.
Well, good things there is SQLXML 3.0 Bulk Load component. Also I believe we can use DTS ActiveX Script & SQLXML 3.0 Bulk Load. I hope this is what...
Sorry guys, just found out that I need to map elements into sql objects. I just need to find a way how I can do it using dataset in .net. Thanks.
I have this xml schema <pre id="code"><font face="courier" size="2" id="code"><?xml version="1.0" standalone="yes"?><br /><xs<img...
Can someone give me an example of an xml mapping schema? I found an article talking about loading an xml into sql using bulk insert and then I...
That's a really good advice. Until that advice came I was really lost in deciding which way to go best; having a single sproc with different paths or...
Hi Twan! It's good to hear that no re-compilation will be done and performance is the same for all paths. I think I have read somewhere that I might...
I think I have asked this question before but I could not find the thread so I can post additional questions there. So please forgive me if I have to...
Sorry that this is a late reply. I'm still having issues with this solution. I tried the suggested solution but the length of execution time did not...
Is it possiblt to span a DB to multiple machines? Can you give some good URLs explaining this in concept and if possible how to do it? Or can...
Hi! What would be the best approach for this: --Table X Code PriceType1 Price1 PriceType2 Price2 PriceType3 Price3 --Table Y CodeY CodeX PriceType...
Hi Twan, Yes the "some codes" is outside the if-expression. I take it that splitting the sproc is ok performance wise. How about considering the...
Hi thanks for the replies! If I break it up to 3 sprocs would there be any difference then on the performance since each path will call the 3rd...
Is there any "big" difference on the performance of an sproc between one with multiple if-statments and one with none. Suppose I have this: --sproc1...
Hi! Thank you all for the replies. I have solved the problem before going back here and BOL was a great help for me. I just wanted to inform you all...
Separate names with a comma.
