Forum Replies Created

Viewing 15 posts - 2,716 through 2,730 (of 3,348 total)

  • RE: Keeping Fresh

    You make some good points, but there is a reverse side to this. If the developers who write the software know in advance that they'll have to maintain it, you...

    August 3, 2010 at 1:35 am

    #1201380

  • RE: Distinct clause in Select statement

    $partacu$ (8/2/2010)

    But while using 2 columns with DISTINCT can produce non unique rows (ateleast in one columm...:-))

    As long as there is a difference in at least one column, the rows...

    August 2, 2010 at 2:18 pm

    #1201239

  • RE: default schema trouble

    Good question. I read it twice, thinking it could not be this simple. Then I submitted my answer and found it wasn't.

    Thanks for teaching me something new!

    August 1, 2010 at 3:38 pm

    #1200801

  • RE: Views

    Tom.Thomson (7/27/2010)

    Hugo Kornelis (4/21/2010)

    I never understand that habit. The semicolon is a statement terminator, not a statement starter, so the logical place for it is at the end of a...

    August 1, 2010 at 3:32 pm

    #1200797

  • RE: Are we in all these cities?

    Tom.Thomson (7/26/2010)

    Incidentally, I was unpleasantly surprised by the introduction of mandatory semicolons into what should be a nice clean syntax that can be parsed unambiguously without these markers. I...

    August 1, 2010 at 3:24 pm

    #1200796

  • RE: Distinct clause in Select statement

    Carlo Romagnano (7/27/2010)

    Hugo Kornelis (7/26/2010)COUNT(*) returns the number of columns (regardless of values);

    That's false: COUNT(*) returns the number of ROWS regardless of of columns. :w00t:

    Yes, of course - I typed...

    August 1, 2010 at 3:16 pm

    #1200794

  • RE: Distinct clause in Select statement

    A good question, highlighting a very common misconception. I've seen so many people think that there is a way to limit DISTINCT to only some of the SELECTed columns -...

    July 26, 2010 at 2:05 pm

    #1198434

  • RE: NULL

    Hi Tom,

    I don't know the 1979 paper (never been able to find it online), but I don't think it matters much. In my opinion, academics tend to argue so...

    July 25, 2010 at 1:58 am

    #1197920

  • RE: Index Types

    magasvs (7/24/2010)

    It would be confusing to get this question on interview, is it? I wouldn't know what is the right answer, probably would give two answers 🙂

    I would consider it...

    July 24, 2010 at 11:25 am

    #1197879

  • RE: NULL

    Tom.Thomson (7/23/2010)

    Ameya- Ameyask (7/23/2010)

    Very good question indeed. NULL does not mean NULL.

    That erroneous view is a fairly natural consequence of treating NULL as a value which exists in all domains...

    July 23, 2010 at 2:49 pm

    #1197782

  • RE: Computed Columns

    jghali (7/21/2010)

    Sorry about the ambiguous answer.

    What I was trying to get to is...

    Retrieving data from a normal column is much faster then having to calculate the value...

    July 22, 2010 at 3:32 pm

    #1197223

  • RE: Index Types

    I'd call this question a good question, based on bad documentation. BOL is certainly not flawless, but it's the best we have, so let's accept it as a reliable resource...

    July 22, 2010 at 3:13 pm

    #1197216

  • RE: Generating SubTotals using GROUPING

    My final comment in this topic, and then I'll respect R.P.'s request.

    Jeff Moden (7/19/2010)

    Still, the order of run return is, in fact, documented in Books Online...

    ROLLUP

    Specifies that in addition...

    July 20, 2010 at 4:16 am

    #1195389

  • RE: Generating SubTotals using GROUPING

    Jeff Moden (7/19/2010)

    Hugo,

    The gain is that there is nothing you can naturally order by that will give you the correct original order. 😉

    Huh?

    USE AdventureWorks2008;

    SELECT TerritoryID, GROUPING(TerritoryID),

    ...

    July 19, 2010 at 2:40 pm

    #1195143

  • RE: VARCHAR datatype

    SanjayAttray (7/18/2010)

    Nice question.

    When the length is not specified in a data definition or variable declaration statement, the default length is 1 ----- Didn't knew this. used to give length...

    July 19, 2010 at 4:41 am

    #1194810

Viewing 15 posts - 2,716 through 2,730 (of 3,348 total)