Viewing 15 posts - 16 through 30 (of 824 total)
Oh, and for all those who wrote in criticizing the article, give it a rest. The article is very basic, but as some have pointed out, there are people...
/*****************
If most people are not willing to see the difficulty, this is mainly because, consciously or unconsciously, they assume that it will be they who will settle these questions for the others, and because they are convinced of their own capacity to do this. -Friedrich August von Hayek
*****************/
March 2, 2010 at 11:50 am
Karen Lopez - InfoAdvisors (3/2/2010)
These tables...
/*****************
If most people are not willing to see the difficulty, this is mainly because, consciously or unconsciously, they assume that it will be they who will settle these questions for the others, and because they are convinced of their own capacity to do this. -Friedrich August von Hayek
*****************/
March 2, 2010 at 11:46 am
Steve Jones - Editor (1/14/2010)
/*****************
If most people are not willing to see the difficulty, this is mainly because, consciously or unconsciously, they assume that it will be they who will settle these questions for the others, and because they are convinced of their own capacity to do this. -Friedrich August von Hayek
*****************/
January 14, 2010 at 11:49 am
Man, that's enough to give even us one-time Oracle guys a bad name...geez, lighten up a bit! Not everything worth reading is confined to your narrow little world.
Steve, this...
/*****************
If most people are not willing to see the difficulty, this is mainly because, consciously or unconsciously, they assume that it will be they who will settle these questions for the others, and because they are convinced of their own capacity to do this. -Friedrich August von Hayek
*****************/
January 14, 2010 at 11:24 am
cmcc (1/6/2010)
In my generation (baby-boomers educated in the 70s) I saw the...
/*****************
If most people are not willing to see the difficulty, this is mainly because, consciously or unconsciously, they assume that it will be they who will settle these questions for the others, and because they are convinced of their own capacity to do this. -Friedrich August von Hayek
*****************/
January 6, 2010 at 10:45 am
If there previously were 40% and now are 20% it indicates that there's some bias at work. You can't say that women aren't interested, if that was the case, that...
/*****************
If most people are not willing to see the difficulty, this is mainly because, consciously or unconsciously, they assume that it will be they who will settle these questions for the others, and because they are convinced of their own capacity to do this. -Friedrich August von Hayek
*****************/
January 6, 2010 at 9:30 am
Bru Medishetty (11/22/2009)
tho.pfaff (11/21/2009)
/*****************
If most people are not willing to see the difficulty, this is mainly because, consciously or unconsciously, they assume that it will be they who will settle these questions for the others, and because they are convinced of their own capacity to do this. -Friedrich August von Hayek
*****************/
November 23, 2009 at 12:45 pm
No, according to the ANSI standard trailing blanks are never ignored for comparison. And as you found out, even turning the ANSI_Padding off doesn't affect how variable values are...
/*****************
If most people are not willing to see the difficulty, this is mainly because, consciously or unconsciously, they assume that it will be they who will settle these questions for the others, and because they are convinced of their own capacity to do this. -Friedrich August von Hayek
*****************/
August 4, 2009 at 7:53 am
I didn't see that Lynn had posted a solution, but in looking at it, that's pretty much the direction I was headed anyway...
/*****************
If most people are not willing to see the difficulty, this is mainly because, consciously or unconsciously, they assume that it will be they who will settle these questions for the others, and because they are convinced of their own capacity to do this. -Friedrich August von Hayek
*****************/
August 3, 2009 at 4:20 pm
When you have a nonclustered index seek that winds up being more expensive than an index scan you are probably also getting a Key Lookup. Which in turn means...
/*****************
If most people are not willing to see the difficulty, this is mainly because, consciously or unconsciously, they assume that it will be they who will settle these questions for the others, and because they are convinced of their own capacity to do this. -Friedrich August von Hayek
*****************/
August 3, 2009 at 4:17 pm
Sorry to tell you this, but I think you are in for creating a bunch of temp tables. You can't execute a stored procedure from within a function or...
/*****************
If most people are not willing to see the difficulty, this is mainly because, consciously or unconsciously, they assume that it will be they who will settle these questions for the others, and because they are convinced of their own capacity to do this. -Friedrich August von Hayek
*****************/
August 3, 2009 at 3:07 pm
If you are really tied to that table design, post the ddl and I'll see what I can come up with.
/*****************
If most people are not willing to see the difficulty, this is mainly because, consciously or unconsciously, they assume that it will be they who will settle these questions for the others, and because they are convinced of their own capacity to do this. -Friedrich August von Hayek
*****************/
August 3, 2009 at 2:59 pm
I'm sure you could write some pretty ugly sql to get this done, but just how married to this table schema are you? The design of this table makes...
/*****************
If most people are not willing to see the difficulty, this is mainly because, consciously or unconsciously, they assume that it will be they who will settle these questions for the others, and because they are convinced of their own capacity to do this. -Friedrich August von Hayek
*****************/
August 3, 2009 at 2:30 pm
This is one of those kind of weird things that you just have to keep in mind... ansi_padding is an option that controls this behavior, but it works a...
/*****************
If most people are not willing to see the difficulty, this is mainly because, consciously or unconsciously, they assume that it will be they who will settle these questions for the others, and because they are convinced of their own capacity to do this. -Friedrich August von Hayek
*****************/
August 3, 2009 at 2:26 pm
The EXCEPT function under the covers is doing the same thing as the NOT EXISTS, at least in my limited testing.
There is one major drawback to the EXCEPT function and...
/*****************
If most people are not willing to see the difficulty, this is mainly because, consciously or unconsciously, they assume that it will be they who will settle these questions for the others, and because they are convinced of their own capacity to do this. -Friedrich August von Hayek
*****************/
August 3, 2009 at 1:36 pm
Viewing 15 posts - 16 through 30 (of 824 total)