Forum Replies Created

Viewing 15 posts - 41,206 through 41,220 (of 49,552 total)

  • RE: A Simple T-SQL question Regarding Nulls and Selects

    Then this should do it.

    WHERE Status = @status OR @status IS NULL

    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

    February 4, 2009 at 11:19 am

    #938217

  • RE: A Simple T-SQL question Regarding Nulls and Selects

    meichner (2/4/2009)

    I know there my be a better way to do this so that I don't have to repeat the Select Clause.

    There is, but it tends to have interesting...

    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

    February 4, 2009 at 9:40 am

    #938117

  • RE: Need strategy for disaster recovery

    Arun (2/4/2009)

    I was thinking that log shipping is just an automation of the normal transaction log backups and restores which we normally perform. but it didnt fail even after i...

    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

    February 4, 2009 at 9:30 am

    #938108

  • RE: Will you consider changing job in this economic tough time?

    Having just started a consulting job, I would recommend that you have at least 4 months income (if not more) saved up before making the move. Work doesn't come instantly...

    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

    February 4, 2009 at 9:25 am

    #938100

  • RE: SQL Injection

    NotManyPoints (2/3/2009)

    Do they just come to this site and their job with their DBA (specifically categorised role) blinkers fully welded into place. Until the shift whistle blows and they...

    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

    February 4, 2009 at 9:22 am

    #938092

  • RE: statement runs very slow what have I done wrong or what could I change to make it better

    twdavis (2/4/2009)

    Table definition Added

    Where?

    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

    February 4, 2009 at 9:19 am

    #938087

  • RE: Difference between varchar(max) and varchar(8000)

    charlesz (2/3/2009)

    The contents of Varchar(MAX), NVarchar(MAX), VarBinary(MAX), and XML fields are encoded using "Partially Length-Prefixed" (PLP in short). A PLP stream starts with total length (8 bytes), followed by current...

    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

    February 4, 2009 at 9:08 am

    #938069

  • RE: compilation error

    vikas bindra (2/4/2009)

    Hey Gail! Was this possible in SQL 2000 also?

    Try it and find out. My SQL 2000 instance is 400km away.

    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

    February 4, 2009 at 9:03 am

    #938063

  • RE: Number of columns in composite key

    There's a 16 column limit to index keys. As Kimberly Tripp is fond of saying, that's a limit, not a goal.

    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

    February 3, 2009 at 1:54 pm

    #937546

  • RE: Printing from CLR throws an exception

    Jonathan Kehayias (2/3/2009)

    If it does not have to do with validating/manipulating/reading/updating data it has no business in SQL server.

    I think you left a not out of that statement

    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

    February 3, 2009 at 1:41 pm

    #937533

  • RE: Tutorial/Tips on writing SPs that are fast and upto standards of development

    idrees.butt (2/3/2009)

    Actually I have been working in writing SPs...so I dont think I should get a book that just tells syntax etc... I need to get insight of pros and...

    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

    February 3, 2009 at 1:31 pm

    #937520

  • RE: SQL Injection

    ex__inferis (2/3/2009)

    Hmm, I guess my comment didn't come across the way I hoped. It made so much more sense in my head. Lets leave it at "you're right, I'm wrong...

    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

    February 3, 2009 at 1:06 pm

    #937485

  • RE: Are the posted questions getting worse?

    Bruce W Cassidy (2/3/2009)

    I'm still struggling with reading most of the questions. I think it's because I'm such a noob.

    Nah. You're not the only one. That's the original reason...

    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

    February 3, 2009 at 12:54 pm

    #937469

  • RE: Are the posted questions getting worse?

    Lynn Pettis (2/3/2009)

    Yea, a little involved in that one myself.

    Likewise, and I won't be surprised to get a couple harsh replies overnight.

    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

    February 3, 2009 at 12:36 pm

    #937454

  • RE: Are the posted questions getting worse?

    Michael Earl (2/3/2009)

    It's one of those days.

    That it is. So far arrogance, ignorance and a question so way out I don't know how to answer it

    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

    February 3, 2009 at 12:23 pm

    #937439

Viewing 15 posts - 41,206 through 41,220 (of 49,552 total)