Forum Replies Created

Viewing 15 posts - 466 through 480 (of 716 total)

  • RE: Resource Governor pools

    Still working on 2012 & 2008 R2, didn't have the time or resources to start working on 2014 🙂

    Thanks & Best Regards,
    Hany Helmy
    SQL Server Database Consultant

    June 11, 2014 at 12:09 am

    #1720624

  • RE: Status and Name Please

    Great question, I liked this one, definitly learnt somthing new 2day about those SUSER_SNAME() & USER_NAME() functions, Thanx Andy.

    Thanks & Best Regards,
    Hany Helmy
    SQL Server Database Consultant

    June 11, 2014 at 12:02 am

    #1720622

  • RE: Dropping a Memory-optimized filegroup

    {In the first release...}, so that means it has been updated in later releases of Hekaton to ALTER the database.

    Thanks & Best Regards,
    Hany Helmy
    SQL Server Database Consultant

    June 9, 2014 at 3:17 am

    #1720022

  • RE: Files for memory-optimized tables

    TomThomson (6/5/2014)

    Te trouble with this question is that 2 3 things store the data for these tables: data, delta, and log. If I destroy the log when the...

    Thanks & Best Regards,
    Hany Helmy
    SQL Server Database Consultant

    June 9, 2014 at 3:11 am

    #1720021

  • RE: Files for memory-optimized tables

    Revenant (6/4/2014)

    Nice question, wrong answer... :angry:

    Thanks, Steve!

    + 1 :w00t:

    Thanks & Best Regards,
    Hany Helmy
    SQL Server Database Consultant

    June 9, 2014 at 3:11 am

    #1720020

  • RE: Restore

    I never used this "Piecemeal Restore" before, so it was interesting question for me, thanx.

    Thanks & Best Regards,
    Hany Helmy
    SQL Server Database Consultant

    June 9, 2014 at 3:05 am

    #1720018

  • RE: Fastest way to convert strings 'TRUE' and 'FALSE' to bit-values 1 and

    Clive Strong (6/5/2014)

    I did pick the right option. However, all 3 could be the easiest, depending on your coding style.

    Alternatively, you don't need the CAST.

    SET @Boolean = @TrueFalse

    works just fine,...

    Thanks & Best Regards,
    Hany Helmy
    SQL Server Database Consultant

    June 5, 2014 at 7:38 am

    #1719220

  • RE: Access Granted or Not?

    Great question & explanation, thanx Andy 🙂

    Thanks & Best Regards,
    Hany Helmy
    SQL Server Database Consultant

    June 5, 2014 at 4:26 am

    #1719137

  • RE: Keyboard key to Toggle between query and results pane

    Nice question, thanx! always liked those questions about using SSMS GUI.

    Thanks & Best Regards,
    Hany Helmy
    SQL Server Database Consultant

    May 31, 2014 at 2:39 am

    #1718009

  • RE: SSIS and the TOKEN function

    Ed Wagner (5/28/2014)

    I had never heard of it either, so I learned something new.

    Me neither 😎

    Thanks & Best Regards,
    Hany Helmy
    SQL Server Database Consultant

    May 28, 2014 at 6:06 am

    #1716979

  • RE: Get User In Reporting Services

    Mighty (5/26/2014)

    Not really happy with the wording of the answers.

    I left the first option out, because the second option seemed "supersede" the first option.

    +1 Agree, @ least I got 2...

    Thanks & Best Regards,
    Hany Helmy
    SQL Server Database Consultant

    May 27, 2014 at 4:54 am

    #1716644

  • RE: Shortcut for SQL server configuration manager

    SQLServerManager11.msc for SS 2012

    Thanks & Best Regards,
    Hany Helmy
    SQL Server Database Consultant

    May 26, 2014 at 3:41 am

    #1716459

  • RE: Temp table limitations

    SQLRNNR (5/23/2014)

    Steve Jones - SSC Editor (5/23/2014)

    Question changed and points awarded back as you can apparently partition a temp table: http://www.sqlservercentral.com/blogs/sqlrnnr/2014/05/23/can-you-partition-a-temporary-table/

    Thanks Steve.

    And by the way - thanks for continuing this...

    Thanks & Best Regards,
    Hany Helmy
    SQL Server Database Consultant

    May 24, 2014 at 8:15 am

    #1716315

  • RE: Temp table limitations

    SQLRNNR (5/23/2014)

    I disagree that this is an easy question. There may be two obviously correct options but there is a third option that is correct.

    Temp tables can be partitioned....

    Thanks & Best Regards,
    Hany Helmy
    SQL Server Database Consultant

    May 24, 2014 at 8:06 am

    #1716314

  • RE: Temp table limitations

    TomThomson (5/23/2014)

    Nice easy question. I was quite surprised to see that more than twice as many thought constraints were not allowed as thought indexes were not allowed,...

    Thanks & Best Regards,
    Hany Helmy
    SQL Server Database Consultant

    May 24, 2014 at 7:54 am

    #1716311

Viewing 15 posts - 466 through 480 (of 716 total)