Forum Replies Created

Viewing 15 posts - 22,501 through 22,515 (of 49,552 total)

  • RE: Investigating (and resolving) bad plans and dynamic SQL.

    allmhuran (11/5/2011)

    What about this specific situation, though? Any thoughts on how to prevent the client logic from messing up the optimizer so badly?

    This kind of thing will likely need...

    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

    November 5, 2011 at 4:54 am

    #1403596

  • RE: Investigating (and resolving) bad plans and dynamic SQL.

    allmhuran (11/5/2011)

    There was a PASS group in Sydney but last I checked the website was pretty dormant. All this makes me a sad panda.

    Dormant? Or just changed sites? http://www.sqlserver.org.au/

    Am mixing...

    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

    November 5, 2011 at 4:46 am

    #1403594

  • RE: Investigating (and resolving) bad plans and dynamic SQL.

    p.s. Schema-qualify tables to ensure that plans can be better reused. Without schema qualification the same table name may map to different tables for different users.

    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

    November 5, 2011 at 2:36 am

    #1403590

  • RE: Investigating (and resolving) bad plans and dynamic SQL.

    allmhuran (11/4/2011)

    2) What's the deal with having the column name paramaterized as well as the value being searched for (ie, those prepared statements of the form @0 = @1)? 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

    November 5, 2011 at 2:33 am

    #1403589

  • RE: How we can Improve the Performance of a Query WIthout creating Indexes

    Better suggestion. Post the query and the table and index definitions.

    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

    November 5, 2011 at 2:23 am

    #1403588

  • RE: SQL crash - debug help needed

    Jeff Moden (11/4/2011)

    I could be wrong but this looks like a bad memory chip.

    Bad memory is one possibility, also bug in a kernel driver (could be just about any 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

    November 5, 2011 at 2:23 am

    #1403587

  • RE: When is a scan cheaper than a seek?

    Jeff Moden (11/4/2011)

    bteraberry (11/3/2011)

    I agree with G^2. I would rather error on the side of reducing reads over picking the "fastest" time unless it is really disproportionate.

    I'd have 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

    November 5, 2011 at 2:17 am

    #1403586

  • RE: Database does backup

    Steve Jones - SSC Editor (11/4/2011)

    Can you run a backup manually?

    and if not, post any errors.

    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

    November 4, 2011 at 12:20 pm

    #1403445

  • RE: Errors attaching corrupt DB

    If it won't go into emergency mode, there's nothing you can do.

    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

    November 4, 2011 at 12:16 pm

    #1403441

  • RE: Are the posted questions getting worse?

    Jim Murphy (11/4/2011)

    Do you get any cash from the sales? [/QUOTe]

    No

    I want to buy a bunch of copies for employees and also presentation give aways.

    Please do. It's an excellent resource...

    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

    November 4, 2011 at 11:49 am

    #1403425

  • RE: constant variable

    A table that you create to store constants.

    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

    November 4, 2011 at 10:34 am

    #1403387

  • RE: constant variable

    Put it into a 'Consts' table

    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

    November 4, 2011 at 10:12 am

    #1403368

  • RE: order of criteria in where clause changes query palan

    Lowell (11/4/2011)

    well, the part i was trying to talk about was the screenshot below; see the difference for the "good enough plan found" vs the other that did not find...

    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

    November 4, 2011 at 9:58 am

    #1403356

  • RE: Are the posted questions getting worse?

    SQLRNNR (11/4/2011)

    Anybody have new ideas over here?

    Rebuild master, then once SQL's running, restore system backups or replace rebuild system database files with the old system files (ensuring that the directory...

    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

    November 4, 2011 at 8:47 am

    #1403289

  • RE: Are the posted questions getting worse?

    Cadavre (11/4/2011)

    Brandie Tarvin (11/4/2011)

    SQL Kiwi (11/4/2011)

    So, it depends

    Someone so needs to come up with an interview question where this is the exact answer that's needed.

    @=)

    Isn't that pretty much every interview...

    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

    November 4, 2011 at 8:45 am

    #1403286

Viewing 15 posts - 22,501 through 22,515 (of 49,552 total)