Forum Replies Created

Viewing 15 posts - 61 through 75 (of 716 total)

  • RE: Index Scan: Ordered or not?

    As usual very informative question from Hugo, Thanx 🙂

    Thanks & Best Regards,
    Hany Helmy
    SQL Server Database Consultant

    November 9, 2015 at 10:34 pm

    #1838747

  • RE: Risks of NOLOCK, part 2

    Thanx Hugo 4 those 2 very useful questions, NoLock=NoDoubt 😉

    Thanks & Best Regards,
    Hany Helmy
    SQL Server Database Consultant

    November 3, 2015 at 11:09 pm

    #1837522

  • RE: Create Procedure

    @ the time of posting this, I was the only 1 who got it right out of 9 attempts 😛

    EZ question, sp_*** for system SP`s.

    Thanks & Best Regards,
    Hany Helmy
    SQL Server Database Consultant

    November 3, 2015 at 10:16 pm

    #1837519

  • RE: Risks of NOLOCK, part 1

    Gr8 question, only the Constraints Violation part I was not sure about, thanx.

    Thanks & Best Regards,
    Hany Helmy
    SQL Server Database Consultant

    November 3, 2015 at 1:16 am

    #1837272

  • RE: DIFFERENCE BETWEEN NOLOCK VS WITH(NOLOCK) IN SQL SERVER 2008

    GilaMonster (1/9/2014)

    The first is deprecated, the second is not, both can result in incorrect results, duplicate rows and missing rows, so neither is the best to use. Best is to...

    Thanks & Best Regards,
    Hany Helmy
    SQL Server Database Consultant

    November 1, 2015 at 3:56 am

    #1836923

  • RE: To view or not to view, that is the question.

    NICE VU 😀

    Thanks & Best Regards,
    Hany Helmy
    SQL Server Database Consultant

    October 29, 2015 at 4:44 am

    #1836296

  • RE: More wildcard searches

    EZ 🙂

    Thanks & Best Regards,
    Hany Helmy
    SQL Server Database Consultant

    October 28, 2015 at 8:49 am

    #1836091

  • RE: SQLCMD connection switching

    Good question, I like it 🙂

    Thanks & Best Regards,
    Hany Helmy
    SQL Server Database Consultant

    October 27, 2015 at 4:41 am

    #1835710

  • RE: The TOP 10 Count

    Correct, I guessed it right, thanx for the question.

    Thanks & Best Regards,
    Hany Helmy
    SQL Server Database Consultant

    October 24, 2015 at 11:44 pm

    #1835390

  • RE: Finding Azure SQL Database

    That was ez & clear enough 4 me, thanx 4 the question.

    Thanks & Best Regards,
    Hany Helmy
    SQL Server Database Consultant

    October 17, 2015 at 11:53 pm

    #1833953

  • RE: Composite foreign key

    Basic question, but yet very good & useful, thanx Igor.

    Thanks & Best Regards,
    Hany Helmy
    SQL Server Database Consultant

    October 6, 2015 at 11:21 pm

    #1831911

  • RE: Filetable Trivia

    I was sure of the 1st option, but the 2nd was tricky and even hard to find upon searching.

    Thanks & Best Regards,
    Hany Helmy
    SQL Server Database Consultant

    October 6, 2015 at 10:57 pm

    #1831905

  • RE: Nulls in the FileTable

    Never used "FileTable" b4, so learned somthin new 2day, thanx Andy.

    Thanks & Best Regards,
    Hany Helmy
    SQL Server Database Consultant

    October 1, 2015 at 2:37 am

    #1830667

  • RE: Restore

    Hugo Kornelis (9/30/2015)

    None of these answers are fully correct. To ensure minimal data loss, one should always start by a tail-log backup. (Which will fail if the log file is...

    Thanks & Best Regards,
    Hany Helmy
    SQL Server Database Consultant

    September 30, 2015 at 1:47 am

    #1830349

  • RE: Backup log with norecovery

    I am using this a lot lately.

    Thanks & Best Regards,
    Hany Helmy
    SQL Server Database Consultant

    September 29, 2015 at 1:24 am

    #1830054

Viewing 15 posts - 61 through 75 (of 716 total)