Viewing 14 posts - 16 through 29 (of 29 total)
What your server seutp like?
If I remember correctly...
temp tables are created as full tables and involve disk access
var tables are created in memory (Memory permitting)
So, if your machine has fast...
October 8, 2003 at 3:03 am
Nope, SQL 2000 only supports T-SQL as the language for stored procedures.
Next release aparantly has full integration with the .NET framework so in theory and .NET language can be used...
October 8, 2003 at 3:00 am
Using CHARINDEX can cause major problems with false positives...
If you have a value in the db of 1 and your are check using CHARINDEX against a list of say 10,11,12,13...
October 8, 2003 at 2:44 am
ok, alot of comments here and no one is 100% correct as this is a subjective issue.
The article was titled "Is XML the Answer...". The answer to what? I...
October 7, 2003 at 8:44 am
I think the main issue here may be the way you are going around getting your data out.
There may be a better way of achieving what you want. Can you...
October 7, 2003 at 5:28 am
Can you post more code?
In particular where you are setting the object '@ObjXMLHTTP' up.
October 7, 2003 at 5:26 am
I do a lot of imports this way working with xml files which are several mb...
I have a VBS file that opens the xml document into a local variable...
--------------------- SNIP...
October 7, 2003 at 5:20 am
quote:
How can a hierarchical xml file store complex relational sets?
Because it is doing what XML...
October 7, 2003 at 4:35 am
I think you have missed one of the main benefits of XML. Its not an ideal storage medium, its not a lean storage medium either...
Where it does excel is...
October 7, 2003 at 2:50 am
Hi,
I have done something very similar for a large CMS here. It isn't for phone numbers, but for other content that relates to one of 2 different types of...
September 17, 2003 at 2:28 am
Seems to be a trend lately in the poor quality of questions! They seem to be more and more open ended and vague. I havnt bothered answering many...
September 1, 2003 at 2:32 am
Yes, I think it was something to do with the stream objects. I changed from using a XMLreader to a Textreader and then passing that through my XSL and...
August 26, 2003 at 2:16 am
I tend to use WinRar. Lets you split the archive easily and seems to compress slightly better than winzip.
Dan
August 13, 2003 at 2:23 am
Viewing 14 posts - 16 through 29 (of 29 total)