Viewing 15 posts - 6,826 through 6,840 (of 8,416 total)
WayneS (10/21/2009)
I really didn't see anything in the discussion that would make me feel between angry and depressed. Just my .02
Fair enough! It was the two guys saying...
October 21, 2009 at 6:58 am
Hey Steve,
I just want to say how much I enjoyed reading your article today (even if I don't necessarily agree with all the content!)
I have the greatest admiration for anyone...
October 21, 2009 at 2:01 am
Venting time. Feel free to skip this post if you're not in the mood to hear me whinge on... 🙂
So, this guy Steve McRoberts goes to all the trouble...
October 21, 2009 at 1:55 am
Anil-465177 (10/19/2009)
However, it consumes a lot of cpu cycles to read the xml data as SQL is not natively optimized for XML.
Nonsense. SQL Server contains many optimizations for generating...
October 21, 2009 at 1:41 am
Steve McRoberts-357330 (10/19/2009)
Please see the warning from Mauve, above, regarding its allocation of 1/8 of the available memory.
Two points, one quick, and one not so quick:
1. (The quick one)...
October 21, 2009 at 1:33 am
Barry, you're probably in the right area there. I agree that BCP is the fastest of the bulk tools available, at least in my experience. The core BCP...
October 18, 2009 at 10:17 pm
Hey Carlo...would you please define 'best' for me? 😀
October 18, 2009 at 12:11 am
Good response there Jeff - and Matt makes good points too.
I'm glad we are much closer in agreement on the CLR stuff than I suspected.
As far as extending T-SQL is...
October 18, 2009 at 12:07 am
8060 bytes is the maximum one row can consume on the top-level data page.
More than 8060 bytes of data can be stored in a row, either by using true LOB...
October 17, 2009 at 5:17 am
Jeff Moden (10/17/2009)
take any split function...
Ah right. It's really important to distinguish between storage and execution behaviour with MAX data types. The comments I made previously were exclusively...
October 17, 2009 at 4:12 am
Jeff Moden (10/17/2009)
October 17, 2009 at 1:06 am
Jeff,
A more generic XML solution, which doesn't suffer from the entitization problem is:
;WITH Drink (name, id)
AS (
...
October 16, 2009 at 10:10 pm
Hey Sam,
I have to say it, so I'll get it out of the way up front: doing data access from a function is rarely optimal. My preference would be...
October 16, 2009 at 6:34 pm
Jeff Moden (10/16/2009)
Heh... wouldn't a reasonable alternative be to only have SQL Server on the SQL Server box? 😉
On the face of it, yes. And, most of the time,...
October 16, 2009 at 5:42 pm
RBarryYoung (10/14/2009)
October 16, 2009 at 9:58 am
Viewing 15 posts - 6,826 through 6,840 (of 8,416 total)