Forum Replies Created

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

  • RE: Choosing values

    Never used Choose before, thanx.

    Thanks & Best Regards,
    Hany Helmy
    SQL Server Database Consultant

    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...

    Thanks & Best Regards,
    Hany Helmy
    SQL Server Database Consultant

    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 😀 🙂 😉

    Thanks & Best Regards,
    Hany Helmy
    SQL Server Database Consultant

    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.

    Thanks & Best Regards,
    Hany Helmy
    SQL Server Database Consultant

    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 🙂

    Thanks & Best Regards,
    Hany Helmy
    SQL Server Database Consultant

    September 20, 2015 at 2:08 am

    #1827930

  • RE: BimlScript Indicators

    porter.james (9/16/2015)

    typo i'm guessing?

    +1

    Thanks & Best Regards,
    Hany Helmy
    SQL Server Database Consultant

    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.

    Thanks & Best Regards,
    Hany Helmy
    SQL Server Database Consultant

    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...

    Thanks & Best Regards,
    Hany Helmy
    SQL Server Database Consultant

    September 13, 2015 at 12:02 am

    #1826231

  • RE: Database Storage

    Windows Azure? Never used it b4.

    Thanks & Best Regards,
    Hany Helmy
    SQL Server Database Consultant

    September 10, 2015 at 12:31 am

    #1825593

  • RE: Open Transactions

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

    Thanks & Best Regards,
    Hany Helmy
    SQL Server Database Consultant

    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...

    Thanks & Best Regards,
    Hany Helmy
    SQL Server Database Consultant

    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...

    Thanks & Best Regards,
    Hany Helmy
    SQL Server Database Consultant

    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.

    Thanks & Best Regards,
    Hany Helmy
    SQL Server Database Consultant

    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...

    Thanks & Best Regards,
    Hany Helmy
    SQL Server Database Consultant

    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...

    Thanks & Best Regards,
    Hany Helmy
    SQL Server Database Consultant

    August 20, 2015 at 12:26 am

    #1821264

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