Forum Replies Created

Viewing 15 posts - 121 through 135 (of 716 total)

  • RE: Column manipulation with ALTER TABLE

    Ez question 4 me, as I am doing this staff a lot in my environment.

    Thanks & Best Regards,
    Hany Helmy
    SQL Server Database Consultant

    June 16, 2015 at 5:54 am

    #1805710

  • RE: What will happen with below code???

    Nice tricky question, thanx.

    Thanks & Best Regards,
    Hany Helmy
    SQL Server Database Consultant

    June 14, 2015 at 5:50 am

    #1805341

  • RE: Insert without a PK

    Now we all agree that the 1st row will be inserted & there is absolutely nothing in the code will disable the indexes, so the next question is: "When we...

    Thanks & Best Regards,
    Hany Helmy
    SQL Server Database Consultant

    June 10, 2015 at 5:25 am

    #1804275

  • RE: Insert without a PK

    Mauricio_ (6/10/2015)

    I wanted to have all green checks in my QOTD list and now I've got a red cross!

    You will get used to this 😛

    Thanks & Best Regards,
    Hany Helmy
    SQL Server Database Consultant

    June 10, 2015 at 5:20 am

    #1804270

  • RE: Database Engine Microsoft SQL Server 2014

    Good 2 know that, thanx.

    Thanks & Best Regards,
    Hany Helmy
    SQL Server Database Consultant

    June 10, 2015 at 5:00 am

    #1804261

  • RE: Filtered Indexes 2

    Another good practice on Filtered Index, thanx.

    Thanks & Best Regards,
    Hany Helmy
    SQL Server Database Consultant

    June 8, 2015 at 2:21 am

    #1803592

  • RE: Disabling Indexes

    ArnoKwetters (6/8/2015) How can you see then that the primairy key index has been disabled ?

    In the Message pane when you execute the Index disable code.

    Thanks & Best Regards,
    Hany Helmy
    SQL Server Database Consultant

    June 8, 2015 at 2:18 am

    #1803590

  • RE: Disabling Indexes

    Good question & good information, thanx.

    Thanks & Best Regards,
    Hany Helmy
    SQL Server Database Consultant

    June 7, 2015 at 1:10 am

    #1803535

  • RE: Default Constraint Script

    TjhomasH6610 (6/3/2015)

    On SQL 2012 I get script B before and after inserting the data.

    Same here.

    Thanks & Best Regards,
    Hany Helmy
    SQL Server Database Consultant

    June 4, 2015 at 2:17 am

    #1802906

  • RE: TIME Datatype

    Thanx 4 the ez question, the options made it more easier.

    Thanks & Best Regards,
    Hany Helmy
    SQL Server Database Consultant

    June 2, 2015 at 11:55 pm

    #1802499

  • RE: Pounds of Formatting Fun

    Nice question, I don`t remember I had the need to use FORMAT before, thanx.

    Thanks & Best Regards,
    Hany Helmy
    SQL Server Database Consultant

    June 2, 2015 at 12:50 am

    #1802223

  • RE: Command Prompt Utility

    I have no idea about this, never used this utility before, so learned somthing new today, thanx.

    Thanks & Best Regards,
    Hany Helmy
    SQL Server Database Consultant

    June 1, 2015 at 11:59 pm

    #1802219

  • RE: DBCC InputBuffer Permissions

    Guessed it right, thanx 4 the question.

    Thanks & Best Regards,
    Hany Helmy
    SQL Server Database Consultant

    May 31, 2015 at 1:14 am

    #1801856

  • RE: Try Catch Throw

    OK, the author should have (like all other QotD) mention to select 2 answers, still it`s a very good question.

    Thanx.

    Thanks & Best Regards,
    Hany Helmy
    SQL Server Database Consultant

    May 26, 2015 at 1:58 am

    #1800490

  • RE: Global Cursors

    TomThomson (5/22/2015)

    Good question. But the answer doesn't seem to cover all the places a global cursor is available where a local one wouldn't be.

    + 1

    Thanks & Best Regards,
    Hany Helmy
    SQL Server Database Consultant

    May 25, 2015 at 12:08 am

    #1800329

Viewing 15 posts - 121 through 135 (of 716 total)