Forum Replies Created

Viewing 15 posts - 226 through 240 (of 716 total)

  • RE: COUNT NULLs

    Thanx 4 the ez question, which is on the contrary of the 1st Count question.

    Thanks & Best Regards,
    Hany Helmy
    SQL Server Database Consultant

    January 21, 2015 at 3:47 am

    #1771737

  • RE: The Identity Limit

    Steve Jones - SSC Editor (1/20/2015)

    Apologies. Not sure why I had numeric as 17 and not 38 for the scale.

    Points awarded back, answers changed.

    Well, thanx anyway, I am sure...

    Thanks & Best Regards,
    Hany Helmy
    SQL Server Database Consultant

    January 21, 2015 at 3:31 am

    #1771733

  • RE: IMPLICIT_TRANSACTIONS vs BEGIN TRAN

    Very good question & explanation, thanx.

    Thanks & Best Regards,
    Hany Helmy
    SQL Server Database Consultant

    January 20, 2015 at 1:05 am

    #1771306

  • RE: Maximum number of supported Partitions in SQL 2014

    Michael_Garrison (1/16/2015)

    Good question. What I am trying to figure out is how Koen is ALWAYS the first to reply to QoD discussions?

    +1, Same catch 🙂

    Thanks & Best Regards,
    Hany Helmy
    SQL Server Database Consultant

    January 18, 2015 at 3:22 am

    #1770984

  • RE: Counting values

    Stewart "Arturius" Campbell (1/14/2015)

    COUNT(*) returns total number of rows, irrespective of the contents.

    +1

    Thanks & Best Regards,
    Hany Helmy
    SQL Server Database Consultant

    January 14, 2015 at 4:01 am

    #1770055

  • RE: Identity Data Types

    I was between option 4 & 5, then figured out that there is nothing wrong with tinyint & smallint data types to be set as identity columns, thanx for the...

    Thanks & Best Regards,
    Hany Helmy
    SQL Server Database Consultant

    January 13, 2015 at 11:10 pm

    #1770011

  • RE: IMPLICIT_TRANSACTIONS & BEGIN TRAN

    Nice question & informative explanation, thanx.

    Thanks & Best Regards,
    Hany Helmy
    SQL Server Database Consultant

    January 11, 2015 at 12:23 am

    #1769281

  • RE: Filestream files

    Steve Jones - SSC Editor (1/9/2015)

    Hugo Kornelis (1/9/2015)

    Good question.

    What I missed in the explanation is that the filestream filegroup does have a physical path, but this is to a directory,...

    Thanks & Best Regards,
    Hany Helmy
    SQL Server Database Consultant

    January 10, 2015 at 11:02 pm

    #1769278

  • RE: Error messages

    Stewart "Arturius" Campbell (1/8/2015)

    Interesting question

    It has to be read carefully.

    Then remember whether the PK violation is a batch terminating error or not.

    I think the crux of the question is what...

    Thanks & Best Regards,
    Hany Helmy
    SQL Server Database Consultant

    January 10, 2015 at 10:45 pm

    #1769277

  • RE: NULL Aggregates

    Good back to basics question, thanx.

    Thanks & Best Regards,
    Hany Helmy
    SQL Server Database Consultant

    January 6, 2015 at 10:54 pm

    #1768325

  • RE: Problems with partitioned views

    Since the beginning, I just don`t like too long questions/stories 🙂

    Thanks & Best Regards,
    Hany Helmy
    SQL Server Database Consultant

    January 6, 2015 at 4:05 am

    #1768017

  • RE: What's Today?

    +4, thanx 2 google & wikipedia 🙂

    Thanks & Best Regards,
    Hany Helmy
    SQL Server Database Consultant

    January 6, 2015 at 12:13 am

    #1767967

  • RE: July 4

    +7 🙂

    Thanks & Best Regards,
    Hany Helmy
    SQL Server Database Consultant

    January 6, 2015 at 12:06 am

    #1767964

  • RE: Happy Holidays

    Hurray, got 7 pts for guessing this 😛

    Thanks & Best Regards,
    Hany Helmy
    SQL Server Database Consultant

    January 6, 2015 at 12:04 am

    #1767963

  • RE: Question of the Day for 21 Dec 2009

    Nice, +7 😀

    Thanks & Best Regards,
    Hany Helmy
    SQL Server Database Consultant

    January 5, 2015 at 11:56 pm

    #1767962

Viewing 15 posts - 226 through 240 (of 716 total)