Forum Replies Created

Viewing 15 posts - 37,171 through 37,185 (of 49,552 total)

  • RE: I'm confused

    trackingraj (8/10/2009)

    expecting some useful reply for my question

    Was Gus's reply not useful?

    What do you enjoy doing? If you enjoy developing then don't look for a job as an administrator. While...

    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

    August 10, 2009 at 12:10 pm

    #1036950

  • RE: CLUSTERING

    http://www.google.com/search?q=windows+clustering

    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

    August 10, 2009 at 12:07 pm

    #1036948

  • RE: Msg 102, Level 15, State 1, Procedure Mon_Trigger, Line 24

    marwenG (8/10/2009)

    select @nbre_Part=count(*)

    from Inserted

    select @nbre_Part=count(*)

    from updated

    i

    There's no such thing as an 'updated' table. The two pseudo-tables visible in triggers are inserted and deleted.

    Inserted contains new rows, when the operation is...

    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

    August 10, 2009 at 10:06 am

    #1036879

  • RE: password polacy

    The username and password? It'll be stored in one of the hidden system tables. Offhand, no idea which one and it shouldn't be important. The relevent info is exposed through...

    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

    August 10, 2009 at 8:41 am

    #1036835

  • RE: Are the posted questions getting worse?

    jcrawf02 (8/10/2009)

    GilaMonster (8/10/2009)

    Gianluca Sartori (8/10/2009)

    Thanks Gail! I'm never patient when it's time to learn something new, especially from you!

    Please note I'm asking for an article review, either a technical review...

    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

    August 10, 2009 at 8:30 am

    #1036828

  • RE: Are the posted questions getting worse?

    jcrawf02 (8/10/2009)

    Suggestions for "very terse answers" -

    Unplug it.

    Quit your job.

    Run. Now.

    Ask Jeff.

    I've several times been tempted, when reading a really long question that's of the form 'Is it possible...'...

    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

    August 10, 2009 at 8:29 am

    #1036826

  • RE: Twenty tips to write a good stored procedure

    rja.carnegie (8/10/2009)

    ... because it's no longer the case that your use of the command has to be considered as possibly "SELECT column FROM gregory.table" and mine is "SELECT column 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

    August 10, 2009 at 8:28 am

    #1036825

  • RE: Are the posted questions getting worse?

    Grant Fritchey (8/10/2009)

    I meant cure as in, not give the patient a different form of terminal cancer, but as in, remove the cancer.

    RotFL

    Good one.

    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

    August 10, 2009 at 7:51 am

    #1036792

  • RE: Twenty tips to write a good stored procedure

    Wesley Brown (8/10/2009)

    Order of operation can help speed a little bit, since you stop checking once of the conditions is met, kinda like the EXISTS issue, but you would have...

    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

    August 10, 2009 at 7:48 am

    #1036790

  • RE: Twenty tips to write a good stored procedure

    rja.carnegie (8/10/2009)

    Is there a reason besides less typing, distinction between DML and variable operations, another issue that only existed in SQL Server 6.5, or maybe being less compatible with a...

    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

    August 10, 2009 at 7:41 am

    #1036785

  • RE: Are the posted questions getting worse?

    Grant Fritchey (8/10/2009)

    In my haste I even missed things, like using a WHILE loop as a cure for cursors... when will that die?

    Well, they are a cure for cursors. The...

    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

    August 10, 2009 at 7:38 am

    #1036781

  • RE: Twenty tips to write a good stored procedure

    ta.bu.shi.da.yu (8/10/2009)

    I'm curious... would the selectivity of an index influence the execution plan when an inequality predicate is used?

    Possibly. Selectivity's difficult with inequalities, especially when there's parameters or variables...

    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

    August 10, 2009 at 7:28 am

    #1036768

  • RE: Are the posted questions getting worse?

    GSquared (8/10/2009)

    I think a few of the responses were a bit abrupt (not from the usual crowd on The Thread). The guy obviously put some work into it, just...

    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

    August 10, 2009 at 7:23 am

    #1036763

  • RE: Twenty tips to write a good stored procedure

    ta.bu.shi.da.yu (8/10/2009)

    Strange as it may seem, if you run the Oracle Automatic Workload Repository ADDM report then you'll often get Oracle warning not to use the operator. It seems...

    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

    August 10, 2009 at 6:59 am

    #1036743

  • RE: Twenty tips to write a good stored procedure

    ta.bu.shi.da.yu (8/10/2009)

    But both of these are anti-semi-joins, which means that I don't actually think you need the top 1.

    What TOP 1?

    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

    August 10, 2009 at 6:44 am

    #1036734

Viewing 15 posts - 37,171 through 37,185 (of 49,552 total)