Forum Replies Created

Viewing 15 posts - 406 through 420 (of 716 total)

  • RE: WMI Alerts

    danrst171 (8/8/2014)

    I got it wrong by selecting the second correct answer.

    Sad 🙁

    we need our points back 😉

    Thanks & Best Regards,
    Hany Helmy
    SQL Server Database Consultant

    August 11, 2014 at 12:20 am

    #1736694

  • RE: WMI Alerts

    Koen Verbeeck (8/8/2014)

    Richard Warr (8/8/2014)

    I'm seeing 15% (13/85) for both at the moment.

    Odd.

    Now, it`s 80% wrong & only 20 % right!

    Thanks & Best Regards,
    Hany Helmy
    SQL Server Database Consultant

    August 11, 2014 at 12:14 am

    #1736692

  • RE: What was that field name?

    Easy, another fast way (but maybe not the fastest), just highlight the table then press Alt + F1 will give you all table structure, definition, columns names, data types, Identity...

    Thanks & Best Regards,
    Hany Helmy
    SQL Server Database Consultant

    August 6, 2014 at 12:27 am

    #1735493

  • RE: In-line variable assignment 1

    Thanx 4 the easy 2 pts.

    Thanks & Best Regards,
    Hany Helmy
    SQL Server Database Consultant

    August 5, 2014 at 1:14 am

    #1735015

  • RE: In-line variable assignment 1

    Carlo Romagnano (8/5/2014)

    Hugo, you always are the NUMBER ONE!

    😀

    WOW, another qotd with a special offer with "SUMMER POINTS"!

    😀

    🙂

    Thanks & Best Regards,
    Hany Helmy
    SQL Server Database Consultant

    August 5, 2014 at 1:13 am

    #1735014

  • RE: Is a foreign key constraint an index? If not, is an index automatically created in order to enforce it?

    BWFC (8/4/2014)

    Carlo Romagnano (8/4/2014)

    I read question and answers many times because of high score.

    I was searching for the swindle!

    But it's only a straightforward basic question.

    😀

    +1

    I thought I knew what...

    Thanks & Best Regards,
    Hany Helmy
    SQL Server Database Consultant

    August 5, 2014 at 12:50 am

    #1735006

  • RE: Is a foreign key constraint an index? If not, is an index automatically created in order to enforce it?

    twin.devil (8/4/2014)

    Nice question, surprisingly too many people still fall for it if you ask them in a interview 😀

    Thanks for sharing Phil.

    :w00t:

    Thanks & Best Regards,
    Hany Helmy
    SQL Server Database Consultant

    August 5, 2014 at 12:48 am

    #1735005

  • RE: Is a foreign key constraint an index? If not, is an index automatically created in order to enforce it?

    Gazareth (8/4/2014)

    I just thought the easy Q & high points was an attempt to improve everyone's Monday morning 🙂

    Can we do this every week?!

    + 1 🙂

    Thanks & Best Regards,
    Hany Helmy
    SQL Server Database Consultant

    August 4, 2014 at 4:14 am

    #1734777

  • RE: BCP results

    Stuart Davies (7/28/2014)

    Stewart "Arturius" Campbell (7/28/2014)

    Sean Pearce (7/28/2014)

    Your question is version specific. From SQL Server 2012 the file will be created.

    +1

    All in all, a good question, despite missing the specification...

    Thanks & Best Regards,
    Hany Helmy
    SQL Server Database Consultant

    July 28, 2014 at 4:56 am

    #1732749

  • RE: BCP results

    Roland C (7/27/2014)

    I am sorry, but I don't agree 🙂

    I executed the script in SSMS (SQL Server 2012). It returned "10 row(s) affected", the csv file was created, but was...

    Thanks & Best Regards,
    Hany Helmy
    SQL Server Database Consultant

    July 28, 2014 at 4:53 am

    #1732747

  • RE: BCP results

    rhythmk (7/28/2014)

    Got it wrong 🙁

    Same here but it`s because of the bad design of the question.

    Thanks & Best Regards,
    Hany Helmy
    SQL Server Database Consultant

    July 28, 2014 at 4:40 am

    #1732744

  • RE: Sub Query

    sknox (7/25/2014)

    At its heart, a correlated subquery is simply one that refers to data from the outer query.

    These are (non-correlated) subqueries:

    SELECT DB_NAME()

    , (SELECT count(*) FROM sys.objects) AS TotalObjects

    , (SELECT count(*)...

    Thanks & Best Regards,
    Hany Helmy
    SQL Server Database Consultant

    July 27, 2014 at 4:31 am

    #1732650

  • RE: Exit Stage Right

    Interesting.

    Thanks & Best Regards,
    Hany Helmy
    SQL Server Database Consultant

    July 27, 2014 at 4:17 am

    #1732648

  • RE: Collation, Unicode & Joins

    Raghavendra Mudugal (7/24/2014)

    Revenant (7/23/2014)

    ...

    I am just a bit skeptical that 58 percent of people got this right without running it...

    😀 Definitely I am not one of them; even though I...

    Thanks & Best Regards,
    Hany Helmy
    SQL Server Database Consultant

    July 27, 2014 at 4:15 am

    #1732647

  • RE: Collation, Unicode & Joins

    Nice question, thx 😀

    Thanks & Best Regards,
    Hany Helmy
    SQL Server Database Consultant

    July 27, 2014 at 4:12 am

    #1732646

Viewing 15 posts - 406 through 420 (of 716 total)