Forum Replies Created

Viewing 15 posts - 76 through 90 (of 135 total)

  • RE: data type precedence!

    CirquedeSQLeil (8/24/2009)


    Keep in mind the question asked for highest and lowest respectively. If construed differently than the highest possible and then the lowest possible datatypes; quote]

  • RE: Statistics

    Kevin Gill (5/21/2009)


    I wouldn't have had a clue, except that the question category gave it away somewhat :o)

    Nice guess.

  • RE: @@DBTS

    steveb. (9/23/2009)


    This question is badly written, .. B is the most correct answer

    Cudn't agree wif u more

  • RE: Statistics

    Kevin Gill (5/21/2009)


    I wouldn't have had a clue, except that the question category gave it away somewhat :o)

    Nice guess.

  • RE: ISNULL

    "The length of the value returned is always equal to or less than the field length of the checked expression"....

  • RE: Substring comprehension

    I chose the one closest to the answer and I seem to have got it right. Hihahhhhh

  • RE: uniqueidentifier

    Almost beaten but I remembered that you can't convert uniqueidentifiers

  • RE: Identity Crisis

    VM-723206 (10/30/2009)


    Damn, I knew how this would work, and noticed the increment 3 too. My mind kinda' swapped the DELETE and TRUNCATE. Chose 4.

    Welcome to the party. Not as easy...

  • RE: Identity Crisis

    Nice one, realised my mistake after running the qry on management studio.

  • RE: The Date Dimension in Analysis Services

    Hi Mike,

    Vincent is correct, the mentioned data is not sequential but sample data. As I said cycle1 is from the first of January to the 31st of December and cycle2...

  • RE: The Date Dimension in Analysis Services

    Thanks and that’s a good article but I have a question though.

    I have 2 dimensions stored in the same SQL table (data mart).

    Data for my date dimension is stored...

  • RE: File Groups

    GabyYYZ (10/19/2009)


    SanjayAttray (10/19/2009)


    Very good question. I was asked this question in an interview.

    Q). What's the easiest and fastest way to move data of a table from file1 to file2?

    A)....

  • RE: GETDATE

    What a refresher regarding the history of SQL.

  • RE: System database logging recovery models

    Nice one

  • RE: Concatenating Rows

    Jon, when I looked at the initial article is said no cursors...

Viewing 15 posts - 76 through 90 (of 135 total)