Forum Replies Created

Viewing 15 posts - 76 through 90 (of 264 total)

  • RE: CDC

    Raghavendra Mudugal (10/23/2013)There are only 10 types of people in the world, those who understand binary, and those who don't.

    Don't forget the NULLs.

    October 23, 2013 at 8:27 am

    #1660966

  • RE: CDC

    The interesting thing here (for those of us not particularly interested in CDC) was looking at the answer percentages. Many people seem unaware that Evaluation and Developer editions have the...

    October 23, 2013 at 2:34 am

    #1660817

  • RE: How to undo Drop Table Statement

    Alternatively, petition for the UNDROP TABLE command to be introduced in SQL Server 2016.

    Hope you found a way to get the table recreated from somewhere.

    October 18, 2013 at 7:16 am

    #1659697

  • RE: Parameter sniffing

    How nice not to see page on page of "Easy peasy" comments. 🙂

    Interesting question which opens up an area still uncharted for many developers.

    October 17, 2013 at 2:43 am

    #1659168

  • RE: Four Years Later

    fificito (10/16/2013)

    Speaking about the company I work for (for the last 8 years), we are very careful about "cloud". The CEO is very protective of the data we generate, and...

    October 16, 2013 at 10:10 am

    #1658991

  • RE: Using a column name in a COUNT function

    SQLMaister (10/15/2013)

    There is no benefit in using select count(1), Select Count(columnname) excludes NULL values, that is the intended purpose. Select count(*) is the most efficient and correct way.

    Welcome to the...

    October 16, 2013 at 5:14 am

    #1658842

  • RE: Transaction

    I also got the answer correct but, seeing that 1/3 of respondents hadn't, clicked on "Discuss" to see if there would be something in here other than half a dozen...

    October 14, 2013 at 2:49 am

    #1658200

  • RE: 70-461

    Koen Verbeeck (9/18/2013)

    The exam itself doesn't give a certification though, you also need 70-462 and 70-463 to get the MCSA certificate.

    Well, if it's your first one you DO become a...

    October 7, 2013 at 6:48 am

    #1656311

  • RE: SSIS - Input Excel file - updating Table - conditional split?

    Koen Verbeeck (9/15/2013)

    Finally, to make sure the temp table still exists before the data flow actually uses it, you need to put the property RetainSameConnection to true on the connection...

    September 16, 2013 at 7:50 am

    #1650448

  • RE: Declare Variable

    This isn't a "nice and simple" or "easy one" at all. Although the explanation is wrong the question illustrates a very subtle nuance with the way scripts are run. Logically...

    September 16, 2013 at 2:44 am

    #1650339

  • RE: wildcards

    In amongst all of the anguish over what the correct answer is we've missed the main issue here. It appears that Steve is a fan of Steppenwolf (either the band...

    September 11, 2013 at 8:45 am

    #1649350

  • RE: wildcards

    Secondly, and more importantly, I am a computer professional. I work in a world of absolutes. Compilers do not give you credit for the code you intended to...

    September 11, 2013 at 8:37 am

    #1649344

  • RE: wildcards

    Come on guys, it's pretty obvious what the point of the question was and knocking the last letter off of 'Steppenwolf' makes everything work as the OP intended.

    If you're...

    September 11, 2013 at 3:06 am

    #1649152

  • RE: Behavior of trigger

    I found some supporting documentation here. Seems a bit of a "hidden gem" though :crazy:

    September 10, 2013 at 2:55 am

    #1648759

  • RE: CTE and Group By

    It's the type of problem that's often easier if you look at it the other way round. If you can find one line of a PO that's not delivered then...

    August 23, 2013 at 8:35 am

    #1644417

Viewing 15 posts - 76 through 90 (of 264 total)