Forum Replies Created

Viewing 15 posts - 391 through 405 (of 716 total)

  • RE: DBCC CHECKDB<!-- 864 -->

    SQLRNNR (8/20/2014) For good measure, the document is nearly the same for SQL 2014 (other areas changed but those statements were not).

    http://msdn.microsoft.com/en-us/library/ms176064(v=sql.120).aspx

    That helped, thx

    Thanks & Best Regards,
    Hany Helmy
    SQL Server Database Consultant

    August 21, 2014 at 12:20 am

    #1739770

  • RE: declarations

    Easy, thx 🙂

    Thanks & Best Regards,
    Hany Helmy
    SQL Server Database Consultant

    August 19, 2014 at 12:33 am

    #1739086

  • RE: Virtual Machines

    TomThomson (8/18/2014)

    Oh dear! "all Hardware"???

    Soundcard? Joystick? USB devices?

    Or am I answering the wrong question?

    See this MSDN library page.

    Or am I just a couple of years...

    Thanks & Best Regards,
    Hany Helmy
    SQL Server Database Consultant

    August 19, 2014 at 12:08 am

    #1739082

  • RE: Which query will give an error?

    Had to try this as I have no hands-on experience on XML part in SQL Server.

    This question reminds me of the 70-461 exam questions 🙂

    Thanks & Best Regards,
    Hany Helmy
    SQL Server Database Consultant

    August 17, 2014 at 3:07 am

    #1738664

  • RE: Which query will give an error?

    sestell1 (8/15/2014)

    XML... yuck. :sick: :laugh:

    Definitly yuck 🙂

    Thanks & Best Regards,
    Hany Helmy
    SQL Server Database Consultant

    August 17, 2014 at 1:06 am

    #1738658

  • RE: Phantoms and isolation

    david.gugg (8/14/2014)

    It would have been helpful know the number of correct answers to choose.

    Agree, though you can get it right by just reading the answers sequence and deduce the...

    Thanks & Best Regards,
    Hany Helmy
    SQL Server Database Consultant

    August 17, 2014 at 12:51 am

    #1738657

  • RE: Phantoms and isolation

    Raghavendra Mudugal (8/15/2014)

    Thank you Tom, very interesting one.

    (I used only READ UNCOMMITTED, and others I have just read them but never had any practical experience on them, so had really...

    Thanks & Best Regards,
    Hany Helmy
    SQL Server Database Consultant

    August 17, 2014 at 12:43 am

    #1738656

  • RE: Phantoms and isolation

    I am one onf the luckiest 20 % 🙂

    Thanks & Best Regards,
    Hany Helmy
    SQL Server Database Consultant

    August 17, 2014 at 12:38 am

    #1738655

  • RE: sp_rename and the procedure definition

    Koen Verbeeck (8/13/2014)

    Great question, and a fine example of why sp_rename should be avoided.

    Yeah, that`s why I prefer to Drop & re-create the SP instead of using sp_rename.

    Thanks & Best Regards,
    Hany Helmy
    SQL Server Database Consultant

    August 14, 2014 at 12:30 am

    #1737913

  • RE: sp_rename and the procedure definition

    Welcome back tricky questions 🙂

    Thanks & Best Regards,
    Hany Helmy
    SQL Server Database Consultant

    August 13, 2014 at 11:10 pm

    #1737907

  • RE: sp_rename and the procedure definition

    Good question, didn`t touch sp_rename since ages 🙂

    Thx.

    Thanks & Best Regards,
    Hany Helmy
    SQL Server Database Consultant

    August 13, 2014 at 12:15 am

    #1737443

  • RE: Implicit transaction mode

    Easy 🙂

    Thanks & Best Regards,
    Hany Helmy
    SQL Server Database Consultant

    August 13, 2014 at 12:06 am

    #1737442

  • RE: Implicit transaction mode

    Iulian -207023 (8/12/2014)

    OK I got it, so the key is in SET IMPLICIT_TRANSACTIONS ON ... interesting. Thank you for the question.

    + 1

    Thanks & Best Regards,
    Hany Helmy
    SQL Server Database Consultant

    August 13, 2014 at 12:05 am

    #1737440

  • RE: In-line variable assignment 2

    Easy but good one, thx Hugo.

    Thanks & Best Regards,
    Hany Helmy
    SQL Server Database Consultant

    August 11, 2014 at 12:35 am

    #1736698

  • RE: WMI Alerts

    Question says: "what items do I need to provide apart from the name?", but still in the answer you have to choose the Namespace :w00t:

    Thanks & Best Regards,
    Hany Helmy
    SQL Server Database Consultant

    August 11, 2014 at 12:24 am

    #1736695

Viewing 15 posts - 391 through 405 (of 716 total)