Forum Replies Created

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

  • RE: Choosing values

    Never used Choose before, thanx.

    September 29, 2015 at 12:45 am

    #1830047

  • RE: LEADing Rows

    sknox (9/22/2015)

    Koen Verbeeck (9/22/2015)

    Even though I know what LEAD does, I still got it wrong because for some reason I was thinking from "right to left". Moar caffeine!

    LAG and LEAD...

    September 22, 2015 at 6:20 am

    #1828355

  • RE: LEADing Rows

    paul s-306273 (9/22/2015)

    Wow - got one right that Koen got wrong!

    Miracles do happen 😀 🙂 😉

    September 22, 2015 at 6:18 am

    #1828354

  • RE: CXPACKET

    Ed Wagner (9/21/2015)

    Great question. Here's some more reading material on the different waits and what they mean.

    http://www.sqlskills.com/blogs/paul/wait-statistics-or-please-tell-me-where-it-hurts/

    This is a vey useful link, thank u.

    September 22, 2015 at 1:11 am

    #1828283

  • RE: Head()

    Iwas Bornready (9/17/2015)

    Ed Wagner (9/17/2015)

    As one who doesn't use MDX, I had to look it up, so I learned something. Thanks.

    Me too.

    + 3 🙂

    September 20, 2015 at 2:08 am

    #1827930

  • RE: BimlScript Indicators

    porter.james (9/16/2015)

    typo i'm guessing?

    +1

    September 17, 2015 at 5:01 am

    #1827354

  • RE: Round

    Didn`t know it will result in this, had 2 test it 2 make sure, thanx 4 the good question.

    September 13, 2015 at 12:15 am

    #1826233

  • RE: Missing Indexes

    Steve Jones - SSC Editor (9/10/2015)

    SQL-DBA-01 (9/10/2015)

    Will the database be accessible if one of the files go offline?

    The filegroup is offline if any files are. If there is the primary...

    September 13, 2015 at 12:02 am

    #1826231

  • RE: Database Storage

    Windows Azure? Never used it b4.

    September 10, 2015 at 12:31 am

    #1825593

  • RE: Open Transactions

    Thanks for the question, I am using this sys table occassionally.

    September 6, 2015 at 1:12 am

    #1824847

  • RE: PINTABLE

    SQLRNNR (8/25/2015)

    TomThomson (8/25/2015)

    Nice simple question. No wrong answers yet. (Not many right ones, either).

    That changed fairly quickly.

    And now its tottaly the opposite as the correct answers are very...

    August 27, 2015 at 12:52 am

    #1822661

  • RE: PINTABLE

    SQLRNNR (8/26/2015)

    ygozudeli (8/25/2015)

    I guess the question has a little mistake in the correct answer options.

    When we use EXECUTE function, we have "Command(s) executed successfully" in stead of the default...

    August 27, 2015 at 12:42 am

    #1822659

  • RE: Detaching and Updating Databases

    Never used this parameter b4 while detaching a DB, though it`s arguable as it will take some considerable time 4 huge database.

    August 23, 2015 at 12:47 am

    #1821855

  • RE: Changing Schedules

    I got it right, but the explanation is wrong; as "the freq_subday_type needs to be updated to hours with the value of 8 NOT 4", beside the original value for...

    August 20, 2015 at 12:39 am

    #1821265

  • RE: columnstore index maxdop

    I am using this MAXDOP option occasionally 2 disable parallel plans 4 some of my long running & high CPU usage queries & SP`s. It`s useful sometimes, but never used...

    August 20, 2015 at 12:26 am

    #1821264

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