Viewing 15 posts - 121 through 135 (of 139 total)
Just one bummer about the solution above:
SQL Server won't let you alter the table because it is being published for replication. So you'll have to drop the table from...
December 2, 2005 at 9:28 am
This is a great article. One of those articles that will nudge a DBA like myself into looking at this info for our databases. Thanks for the great...
August 16, 2004 at 10:40 am
Yeah, inevidetably, I figured that out about five minutes after I posted. It also appears that if I get the hierarchy right, with the Location table below the SaleLocation...
March 15, 2004 at 3:10 pm
I tend to agree that it would probably be the first option. The only time I could see it being the 2nd option, is if your application is tremendously...
March 8, 2004 at 9:15 am
If a column needs an index, you should index it whether it's varchar or int, or whatever.
Even if it's not as efficient to use a varchar(55) than an int, it's...
May 2, 2003 at 8:25 am
Just a thought: is it possible the query using the substing(30) might cross a line from using RAM to using HDD for storage? I can't really see how that...
May 1, 2003 at 5:32 pm
I think I remember now. It was actually discussed at a session at the PASS conference in Seattle last year, with the 2 owners of this site debating indentities...
May 1, 2003 at 5:21 pm
quote:
In fact used to be that comparing Numeric values were faster than Char values and it was suggested to always use Numeric....
May 1, 2003 at 11:42 am
Thanks for the input guys. I figured it was a lot easier to get feedback from you guys, than to either figure out to do it myself in code,...
April 29, 2003 at 3:39 pm
quote:
There is a trace flag (257) that makes the output a little easier to work with.
April 21, 2003 at 9:29 am
Doing it with XML definitely sounds like your best bet. I highly recommend checking out the XML forums on this site rather than relying on the Books Online info,...
April 17, 2003 at 8:55 am
What about accepting the email text as a TEXT parameter, than parsing it into a series varchar's and referencing it as a pointer?
April 17, 2003 at 8:42 am
I figured I would have been better off just posting the example in the first place, since I knew people would want it...
In the following sample, XMLPost is a table...
April 3, 2003 at 10:27 am
Thanks TC, that info rocks.
Now I just have to remember where I was planning on using it orignally!
April 3, 2003 at 10:02 am
quote:
I have a Temp table like this. Candidate_Portions (Candidate_ID int Portion_ID int, Portion_XML Text). Now I have to retreive the data...
April 3, 2003 at 8:40 am
Viewing 15 posts - 121 through 135 (of 139 total)