Forum Replies Created

Viewing 15 posts - 76 through 90 (of 136 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]

    What you don't know won't hurt you but what you know will make you plan to know better
  • 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.

    What you don't know won't hurt you but what you know will make you plan to know better
  • RE: @@DBTS

    steveb. (9/23/2009)


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

    Cudn't agree wif u more

    What you don't know won't hurt you but what you know will make you plan to know better
  • 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.

    What you don't know won't hurt you but what you know will make you plan to know better
  • RE: ISNULL

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

    What you don't know won't hurt you but what you know will make you plan to know better
  • RE: Substring comprehension

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

    What you don't know won't hurt you but what you know will make you plan to know better
  • RE: uniqueidentifier

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

    What you don't know won't hurt you but what you know will make you plan to know better
  • 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...

    What you don't know won't hurt you but what you know will make you plan to know better
  • RE: Identity Crisis

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

    What you don't know won't hurt you but what you know will make you plan to know better
  • 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...

    What you don't know won't hurt you but what you know will make you plan to know better
  • 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...

    What you don't know won't hurt you but what you know will make you plan to know better
  • 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)....

    What you don't know won't hurt you but what you know will make you plan to know better
  • RE: GETDATE

    What a refresher regarding the history of SQL.

    What you don't know won't hurt you but what you know will make you plan to know better
  • RE: System database logging recovery models

    Nice one

    What you don't know won't hurt you but what you know will make you plan to know better
  • RE: Concatenating Rows

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

    What you don't know won't hurt you but what you know will make you plan to know better

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