Forum Replies Created

Viewing 15 posts - 361 through 375 (of 454 total)

  • RE: backup database

    Dave62 (9/22/2010)

    cengland0 (9/22/2010)

    Dave62 (9/22/2010)

    I think the proper way to "rollback" a backup is to do a restore. 😉

    No, because that will bring the database back to a previous state....

    September 22, 2010 at 8:29 am

    #1225637

  • RE: backup database

    Toreador (9/22/2010)

    ...I'm not sure what the question was supposed to teach us though - would anybody really try doing a backup inside a transaction?!

    Perhaps not intentionally, but indirectly: how many...

    September 22, 2010 at 7:20 am

    #1225561

  • RE: HAVING EXISTS

    Tony Bater (9/8/2010)

    In a recent blog, Kalen Delaney said she is frequently asked why is there a need to understand the internals of SQL Server. I think this question illustrates...

    September 8, 2010 at 10:18 am

    #1218081

  • RE: Parsing an ADO result set into a comma separated string in SSIS

    This is a good article, and your explanation as to why you did this in SSIS is a great example of how "best" practices sometimes are NOT the best solution...

    September 1, 2010 at 7:23 am

    #1214940

  • RE: How many rows?

    hardik.doshi (8/27/2010)

    ISNUMERIC is returing 0 so implicit conversation is not converting BLANK to ZERO. Therefore the reason behind this is something else.

    Not so. You can easily prove that SQL Server...

    August 27, 2010 at 6:19 am

    #1212879

  • RE: Auditing Events

    bbop1322 (7/30/2010)

    ... I now know where to create them at both the Server and Database level but cannot determine where to configure the synchronicity at. Can someone point me in...

    July 30, 2010 at 7:56 am

    #1200337

  • RE: REPLACE() and NULL

    webrunner (7/12/2010)

    I guess my question is why does the REPLACE function replace anything if the string pattern (second parameter) isn't in the string expression (first parameter)?

    It doesn't. It checks for...

    July 12, 2010 at 12:57 pm

    #1191656

  • RE: "SELECT @local_variable"

    OCTom (6/25/2010)

    An unsupported technique? I have seen this used and have been encouraged to use this technique by an experienced consulted. I'll be sending him the link to this discussion....

    June 25, 2010 at 7:37 am

    #1184987

  • RE: Access variables values from Trigger

    simon.ellistonball (6/9/2010)

    A nice idea, but your trigger relies on the fact that you would only ever delete one product at a time.

    No, it doesn't. It does rely on having only...

    June 9, 2010 at 6:57 am

    #1177946

  • RE: SQL Server Trace Flags

    204 A backward compatibility switch that enables non-ansi standard behavior. E.g. previously SQL server ignored trailing blanks in the like statement and allowed queries that contained aggregated functions to have...

    June 8, 2010 at 9:31 am

    #1177529

  • RE: HAVING

    jlennartz (6/7/2010)

    Okay if any one of the rows returned by the where clause, when checked by the having clause, evaluates to true then they all are considered true? ...

    June 7, 2010 at 11:13 am

    #1177156

  • RE: HAVING

    Hugo Kornelis (6/6/2010)

    Thanks, UMG!

    And you are right, that would have been a better distractor. I'm not sure why I included the "one row, value 2" option. It's a while back...

    June 7, 2010 at 6:48 am

    #1177057

  • RE: case statement puzzle

    F1Droid (5/26/2010)

    Good question that in its simplicity makes you question what seems the obvious answer and think about it more deeply.

    According to SQL Books Online, the parser actually checks all...

    May 26, 2010 at 12:57 pm

    #1172977

  • RE: What will this return?

    Hugo Kornelis (5/24/2010)

    The reason I cheated is that the expressions used to set the two datetime variables are way too complex to understand. Especially with their (lack of) formatting. Having...

    May 24, 2010 at 8:54 am

    #1171610

  • RE: Intersect, Except, Union, All and Any

    Jeff Moden (7/27/2009)

    phickey (7/27/2009)

    EXCEPT and INTERSECT are especially useful for comparing multiple columns of data where (a) there is no primary key or (b) having the same primary key does...

    May 21, 2010 at 8:06 am

    #1170849

Viewing 15 posts - 361 through 375 (of 454 total)