Forum Replies Created

Viewing 15 posts - 1 through 15 (of 29 total)

  • Reply To: The Rank Window II

    SADSAC wrote:

    I'm afraid the given answer is not correct. using the SalesDate as part of the SELECT will deliver 10 unique rows. Removing the date then does indeed provide 8...

  • Reply To: The Rank Window II

    I'm afraid the given answer is not correct. using the SalesDate as part of the SELECT will deliver 10 unique rows. Removing the date then does indeed provide 8 unique...

  • Reply To: Logging Event Permissions

    Agree with Jeff. from BOL:

    Requires membership in the sysadmin fixed server role or membership in the public fixed database role in the master database with EXECUTE permission...

    • This reply was modified 5 years, 1 month ago by SADSAC.
  • Reply To: Backing Up Some Log

    I'm afraid none of the answers are correct.

    as it stands, it would only work if there was a database with the date as part of the name, which would write...

  • Reply To: More Delays

    There are actually 2 different, but related, errors:

    The date is included in the literal;

    the time contains a letter "p" that is not recognised;

    therefore, answers 2 and 3 are equally valid

  • Reply To: Sorting the Data Frame

    The 2nd and 4th answers appear to be the same?

  • Reply To: Filtered Statistics

    Methinks there is a minor fail.

    no options correct?

    Good question, execution not so much

  • RE: The Extra Table

    Nice question, thanks Kendra
    Had to field something similar fairly recently.
    A developer wrote all his tables, views & procs im model, but could not understand why new databases contained...

  • RE: Linux Filesystems

    Nice question, thanks, Steve

  • RE: Variable assignments

    Brilliant..
    Nice one to start the week on, thanks Evgeny

  • RE: STRING_SPLIT()

    and here i thought - am i losing my marbles?
    the space after the coma in the delimiter will surely cause an error...
    glad i'm not the only one who...

  • RE: Importing Tricky CSV Files with PowerShell

    This is great, exactly what I was looking for....

  • RE: All the memory

    Trying to explain this to a junior dba who believes he knows everything about everything.
    talk about an uphill battle - he believes that because the server only hosts one...

  • RE: Where conditions

    Nice one, thanks Evgeny

  • RE: The Current Date

    Nice one, thanks Steve
    Learned something new

Viewing 15 posts - 1 through 15 (of 29 total)