Forum Replies Created

Viewing 15 posts - 196 through 210 (of 716 total)

  • RE: Remove data from tables

    Jostein Saethern (3/4/2015)


    The "delete table BBB;" statement in d) will fail.

    Its just a typo.

    Thanks & Best Regards,
    Hany Helmy
    SQL Server Database Consultant

  • RE: BREAK

    Jeff Moden (3/4/2015)


    Heh... the correct answer is @j-2. 😛

    Great question, BTW.

    + 1 😀

    Thanks & Best Regards,
    Hany Helmy
    SQL Server Database Consultant

  • RE: Creating schemas

    Gr8 question, guessed it correctly by logical thinking,

    Thanx Steve.

    Thanks & Best Regards,
    Hany Helmy
    SQL Server Database Consultant

  • RE: XML Indexes

    Ok, that was new 4 me, thanx.

    Thanks & Best Regards,
    Hany Helmy
    SQL Server Database Consultant

  • RE: Maximum number of databases per instance

    Good 2 know that limitation, thanx.

    Thanks & Best Regards,
    Hany Helmy
    SQL Server Database Consultant

  • RE: Maximum number of databases per instance

    patricklambin (2/27/2015)


    Hi Nakul ,

    Maybe a database is surely the object which "owns" the most important count of child objects ( 1 datafile , 1 logfile , a table with...

    Thanks & Best Regards,
    Hany Helmy
    SQL Server Database Consultant

  • RE: The answer to life, the universe and prime numbers

    Not sure about this, had to run the code, never encountered such case before, so it is interesting question, thanx.

    Thanks & Best Regards,
    Hany Helmy
    SQL Server Database Consultant

  • RE: Creating certificates

    I was sure about the assembly also it cannot be the only way to create certifactes, so picking the correct answer was quite easy, thanx 🙂

    Thanks & Best Regards,
    Hany Helmy
    SQL Server Database Consultant

  • RE: Signing options

    Steve Jones - SSC Editor (2/24/2015)


    Hany Helmy (2/23/2015)


    In the daily newsletter email I recieved, the answer for that question was: "You can use certificates, asymmetric keys, or passwords" while the...

    Thanks & Best Regards,
    Hany Helmy
    SQL Server Database Consultant

  • RE: Drop Database

    Easy 4 me, had previous experience with it 🙂

    Thanks & Best Regards,
    Hany Helmy
    SQL Server Database Consultant

  • RE: ColumnStore index

    I hope 1 day that my company will ever consider upgrading to SQL 2014 so our databases will get benefit from all the nice new performance features 🙂

    Thanks & Best Regards,
    Hany Helmy
    SQL Server Database Consultant

  • RE: Signing options

    In the daily newsletter email I recieved, the answer for that question was: "You can use certificates, asymmetric keys, or passwords" while the answer on the website is: "You can...

    Thanks & Best Regards,
    Hany Helmy
    SQL Server Database Consultant

  • RE: Signing options

    Ok, got it wrong, but @ least learned somthing new 2day, thanx.

    Thanks & Best Regards,
    Hany Helmy
    SQL Server Database Consultant

  • RE: Not Again!

    Learned somthing new for me today, thanx!

    Thanks & Best Regards,
    Hany Helmy
    SQL Server Database Consultant

  • RE: Recompile in a stored procedure?

    Good to know that, thanx.

    Thanks & Best Regards,
    Hany Helmy
    SQL Server Database Consultant

Viewing 15 posts - 196 through 210 (of 716 total)