Forum Replies Created

Viewing 15 posts - 25,441 through 25,455 (of 49,552 total)

  • RE: How to avoid convert function in the where clause???

    What's the data type of a.ProcessDate?

    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

    June 17, 2011 at 2:17 am

    #1340227

  • RE: Any special configurations/Known issues for Trace Flag 1222 ?

    No, just deadlocks. If it reported blocking your error log would have more like 500 entries than 5.

    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

    June 17, 2011 at 2:13 am

    #1340226

  • RE: Any special configurations/Known issues for Trace Flag 1222 ?

    I used to run a major production server with that traceflag permanently enabled. It can't cause blocking (thing to block)

    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

    June 17, 2011 at 1:39 am

    #1340219

  • RE: High CPU, Low Reads

    Without seeing the code, no.

    Was parameter sniffing a problem? If not, you shouldn't disable 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

    June 17, 2011 at 1:30 am

    #1340216

  • RE: Altering procedures while being executed

    If you alter a proc while it's running, the currently executing one uses the original definition, any new execution uses the new.

    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

    June 17, 2011 at 1:29 am

    #1340215

  • RE: What is the output if used more than one DML command on same object at the same time?

    Depends which runs first. SQL will take locks so that they can't run simultaneously if they affect the same data.

    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

    June 17, 2011 at 1:28 am

    #1340214

  • RE: temp table in user database?

    Suresh B. (6/17/2011)

    P(Don't add more than 8 data files to tempdb. More than 8 files is counter productive)

    Not true. It can in cases be necessary to add way, way more.

    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

    June 17, 2011 at 1:25 am

    #1340212

  • RE: kinly give reply as early as possible

    Please post table definitions, sample data and desired output. Read this to see the best way to post this to get quick responses.

    http://www.sqlservercentral.com/articles/Best+Practices/61537/

    nsaireddymca (6/17/2011)

    kindly solve it and send me...

    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

    June 17, 2011 at 1:17 am

    #1340210

  • RE: Are the posted questions getting worse?

    Steve Jones - SSC Editor (6/16/2011)

    GilaMonster (6/16/2011)

    Go watch this:

    http://channel9.msdn.com/Events/TechEd/NorthAmerica/2011/DPR201

    TechEd North America presentation titled "The Architect". Fantastic and so funny in so many places

    Downloading now. Bandwidth appears to be tight now...

    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

    June 17, 2011 at 1:15 am

    #1340209

  • RE: Question about forums and individual statuses

    If you look, so are we. The only people who aren't are Steve and Brian, who are forum moderators.

    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

    June 17, 2011 at 1:14 am

    #1340208

  • RE: temp table in user database?

    Since this is an IO contention issue (PageIOLatch) you will need to put each of those files on a separate physical drive, or you will have little to no effect...

    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

    June 17, 2011 at 1:13 am

    #1340207

  • RE: Update stats question

    Um...

    Sure, if you don't mind that SQL is only reading half the table (a random half) to compute the statistics. Half the table != the entire 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

    June 16, 2011 at 4:20 pm

    #1340118

  • RE: When is shrinking a data file acceptable?

    Ninja's_RGR'us (6/16/2011)

    Ya but to pick only the used pages you must scan all pages (even if only the header). So that's an extra 200 - 900GB??? to extract 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

    June 16, 2011 at 3:42 pm

    #1340104

  • RE: Update stats question

    The fullscan reads the entire table. The sampling 50% reads around 50% of the table (a sample)

    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

    June 16, 2011 at 2:48 pm

    #1340081

  • RE: Are the posted questions getting worse?

    Go watch this:

    http://channel9.msdn.com/Events/TechEd/NorthAmerica/2011/DPR201

    TechEd North America presentation titled "The Architect". Fantastic and so funny in so many places

    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

    June 16, 2011 at 1:49 pm

    #1340061

Viewing 15 posts - 25,441 through 25,455 (of 49,552 total)