Viewing 15 posts - 136 through 150 (of 178 total)
Luis Cazares (9/10/2012)
CELKO (9/9/2012)
The correct terms are "preserved table " and "unpreserved table" ...Can you explain us these terms? I can't find any reference on the web.
While I'm sure Joe...
September 11, 2012 at 8:09 am
adamg 27214 (9/10/2012)
Using a function on a column in a where clause will not allow your query to use an index. That is why instead of isnull you want...
September 10, 2012 at 3:00 pm
I really learned from this article! I've been working with SQL Server for 7 years now and I had no idea the results were different if I took a...
September 10, 2012 at 10:04 am
Deleted by author (I neglected to read the first post before posting).
July 20, 2012 at 7:34 am
dadam (4/26/2012)
If you're confused by any of this .... try putting the same CASE statement in the query as a column so you can see what's going on.
GENIUS!!
BRILLIANT!!
I'm seriously reflecting...
April 26, 2012 at 9:33 am
Stan Kulp-439977 (3/15/2012)
March 16, 2012 at 8:28 am
Stan Kulp-439977 (3/15/2012)
I got the data file from EODDATA.You will have to ask them.
As far as I know the S&P may only track 499 and use "500" because...
March 15, 2012 at 3:00 pm
This is a silly question but curiousity is getting the best of me. Am I the only one that got 499 results? Since we're talking about the S&P...
March 15, 2012 at 10:58 am
I've been coming to these forums long enough to know that Joe Celko was going to respond to this one. I recall Joe discussing the TOP clause in another...
October 25, 2011 at 6:25 am
I finally read this article (and amazingly, all 70 posts...something I NEVER do). Very good article and like several others have pointed out your responses in these discussions are...
July 28, 2011 at 9:24 am
OMG, I didn't realize that was referring to Windows and not SQL...UGH. I just reinstalled this thing 4 or 5 times and assumed I was doing something wrong because...
June 19, 2011 at 11:07 am
SQLZ (5/31/2011)
If it weren't for non-standard requirements, we'd all be out of a job. 😛
I'll drink to that! Gotta love job security.
May 31, 2011 at 8:21 am
thisisfutile (4/27/2011)
On my workstation, the Options > Source Control only has "Plug-in Selection" under it in the tree menu so file association through SSMS isn't an option on my install.
So...
April 27, 2011 at 7:29 am
On my workstation, the Options > Source Control only has "Plug-in Selection" under it in the tree menu so file association through SSMS isn't an option on my install.
I know...
April 27, 2011 at 7:12 am
nadabadan (1/27/2011)
...you will get 11 rows instead of the expect 10.
In the article, Jeff stated "I don't really care where the line "wraps", nor do I care about trailing spaces"....
January 27, 2011 at 10:01 am
Viewing 15 posts - 136 through 150 (of 178 total)