Forum Replies Created

Viewing 15 posts - 10,216 through 10,230 (of 49,552 total)

  • RE: Backup Encryption options with SQL Server 2008 R2 SE?

    Sapen (1/27/2014)

    Thanks a lot for the inputs. My initial thought was to use the option MediaPassword while backing up a database and script out the database backup instead of using...

    Gail Shaw
    Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
    SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

    We walk in the dark places no others will enter
    We stand on the bridge and no one may pass

    January 28, 2014 at 9:07 am

    #1683984

  • RE: Mising table

    Sean Lange (1/28/2014)

    mike.conti (1/28/2014)

    sorry for the confusion: there is no syntax issue

    This works: SELECT top 10 * FROM ACTI**_**

    it does not appear in when i run this SELECT * FROM...

    Gail Shaw
    Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
    SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

    We walk in the dark places no others will enter
    We stand on the bridge and no one may pass

    January 28, 2014 at 9:00 am

    #1683979

  • RE: Are the posted questions getting worse?

    Greg Edwards-268690 (1/28/2014)

    GilaMonster (1/28/2014)

    Anyone got time and enthusiasm? (running low on the latter and it's almost time to go home)

    A trigger that doesn't work: http://www.sqlservercentral.com/Forums/Topic1532595-1292-1.aspx

    An IF statement that, well, ......

    Gail Shaw
    Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
    SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

    We walk in the dark places no others will enter
    We stand on the bridge and no one may pass

    January 28, 2014 at 8:55 am

    #1683976

  • RE: Triggers

    Sean Lange (1/28/2014)

    GilaMonster (1/28/2014)

    When there are multiple triggers for the same action (multiple insert for example), you can defined which one runs first and which one runs last, but that's...

    Gail Shaw
    Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
    SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

    We walk in the dark places no others will enter
    We stand on the bridge and no one may pass

    January 28, 2014 at 8:55 am

    #1683975

  • RE: Triggers

    Max number is more than you could ever need.

    When there are multiple triggers for the same action (multiple insert for example), you can defined which one runs first and which...

    Gail Shaw
    Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
    SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

    We walk in the dark places no others will enter
    We stand on the bridge and no one may pass

    January 28, 2014 at 8:18 am

    #1683945

  • RE: FizzBuzz

    I'm not saying that recursive CTEs are bad, wrong, terrible, never use. Just saying be aware of how they behave.

    Gail Shaw
    Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
    SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

    We walk in the dark places no others will enter
    We stand on the bridge and no one may pass

    January 28, 2014 at 7:34 am

    #1683923

  • RE: Are the posted questions getting worse?

    Anyone got time and enthusiasm? (running low on the latter and it's almost time to go home)

    A trigger that doesn't work: http://www.sqlservercentral.com/Forums/Topic1532595-1292-1.aspx

    An IF statement that, well, ... http://www.sqlservercentral.com/Forums/Topic1535345-1291-1.aspx

    Gail Shaw
    Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
    SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

    We walk in the dark places no others will enter
    We stand on the bridge and no one may pass

    January 28, 2014 at 7:31 am

    #1683919

  • RE: FizzBuzz

    chillw1nston (1/28/2014)

    not sure what your getting at. I guess because it runs recursively and relys on previous result set to generate next which is a more programmatical construct?

    Yup.

    Would you...

    Gail Shaw
    Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
    SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

    We walk in the dark places no others will enter
    We stand on the bridge and no one may pass

    January 28, 2014 at 7:26 am

    #1683914

  • RE: FizzBuzz

    No.

    How does a recursive CTE work?

    Gail Shaw
    Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
    SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

    We walk in the dark places no others will enter
    We stand on the bridge and no one may pass

    January 28, 2014 at 7:13 am

    #1683905

  • RE: FizzBuzz

    chillw1nston (1/28/2014)

    --Now scalable, set based and added a fizzbuzz!

    DECLARE @threshold int = 100

    ;WITH numbers ( seqnum )

    AS...

    Gail Shaw
    Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
    SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

    We walk in the dark places no others will enter
    We stand on the bridge and no one may pass

    January 28, 2014 at 7:07 am

    #1683901

  • RE: Data corruption error

    I can't tell from that what's going on. That 'May have Data Corruption' is an application error, could be anything triggering that. Without knowing the technical details, no way to...

    Gail Shaw
    Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
    SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

    We walk in the dark places no others will enter
    We stand on the bridge and no one may pass

    January 28, 2014 at 6:59 am

    #1683898

  • RE: If Statement

    Then the where clause you have matches no rows.

    Probably because of this:

    IF @ADR3 IS NULL

    SELECT ADR1, ADR2, POSTAL_CODE

    FROM PAT_NAMES_ADDRESS

    WHERE CURRENT_ONE = RTRIM(@CURRENT_ONE)

    AND ADR1 = RTRIM(@ADR1)

    AND ADR2 = RTRIM(@ADR2)

    AND ADR3 =...

    Gail Shaw
    Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
    SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

    We walk in the dark places no others will enter
    We stand on the bridge and no one may pass

    January 28, 2014 at 6:41 am

    #1683888

  • RE: Data corruption error

    When you say 'data corruption', what exactly do you mean? What errors, what symptoms, etc

    Gail Shaw
    Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
    SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

    We walk in the dark places no others will enter
    We stand on the bridge and no one may pass

    January 28, 2014 at 6:00 am

    #1683878

  • RE: If Statement

    SET @ADR3 = 'null'

    That's setting the variable to the string value n-u-l-l. If you want to check whether a variable has the string value "null", then you'd need IF...

    Gail Shaw
    Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
    SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

    We walk in the dark places no others will enter
    We stand on the bridge and no one may pass

    January 28, 2014 at 5:59 am

    #1683877

  • RE: Adding 2 COUNT statements results in heavy query

    Other way around.

    http://sqlinthewild.co.za/index.php/2009/04/14/on-counts/

    Gail Shaw
    Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
    SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

    We walk in the dark places no others will enter
    We stand on the bridge and no one may pass

    January 28, 2014 at 5:07 am

    #1683869

Viewing 15 posts - 10,216 through 10,230 (of 49,552 total)