Forum Replies Created

Viewing 15 posts - 9,496 through 9,510 (of 49,552 total)

  • RE: corrupted mdf file

    Steve Jones - SSC Editor (3/30/2014)

    NOTE that DBCC DBREPAIR is not recommended. I would be very careful about using any of these tools.

    More drive-by spam. This stuff gets posted on...

    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

    March 30, 2014 at 2:22 pm

    #1701441

  • RE: TEMPDB issue

    poratips (3/28/2014)

    Only my concern is that it might cause corruption, right?

    Shrinking TempDB can, but since that's the opposite of what you need to do (make it bigger, give it 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

    March 30, 2014 at 6:55 am

    #1701417

  • RE: Clustered Index Scan

    INT has a higher precedence than string, the string will convert to int, so if that is an int column (which we don't know), then the query will be essentially

    SELECT...

    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

    March 28, 2014 at 3:25 pm

    #1701333

  • RE: Clustered Index Scan

    Eirikur Eiriksson (3/28/2014)

    SELECT @ProductID= ProductID FROM Product WITH (NOLOCK) WHERE SalesID= '@salesId' and Product = 'Clothes '

    Apart from not being SARGable...

    All the predicates in that query are SARGable. They're all...

    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

    March 28, 2014 at 2:55 pm

    #1701325

  • RE: Log file is filling up

    I wrote an article on server-side trace?

    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

    March 28, 2014 at 2:44 pm

    #1701319

  • RE: TEMPDB issue

    Shrinking (making smaller) a full file (too small) is a little counter-productive. It's like reducing the speed you're driving at because it's taking too long to get where you're going.

    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

    March 28, 2014 at 2:40 pm

    #1701317

  • RE: Are the posted questions getting worse?

    Jack Corbett (3/28/2014)

    I call myself a Database Developer, but I've used programmer in the past. MY current title is Data Software Development Lead. If you can...

    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

    March 28, 2014 at 2:39 pm

    #1701316

  • RE: Are the posted questions getting worse?

    Ed Wagner (3/28/2014)

    Grant - You have booth babes??? :w00t:

    Grant *is* the booth 'babe' 🙂

    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

    March 28, 2014 at 9:16 am

    #1701176

  • RE: Log file is filling up

    What is the recovery model?

    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

    March 28, 2014 at 7:44 am

    #1701093

  • RE: Duplicate key issue ... again ... and again ...

    Can you post the table definition and the procedure?

    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

    March 28, 2014 at 7:02 am

    #1701074

  • RE: Are the posted questions getting worse?

    Ed Wagner (3/28/2014)

    WayneS (3/27/2014)

    Luis Cazares (3/27/2014)

    How is it possible that someone writes a cursor instead of using SUM()?

    I'm afraid that this database is full of these pieces of sh code...

    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

    March 28, 2014 at 6:58 am

    #1701071

  • RE: Are the posted questions getting worse?

    dwain.c (3/28/2014)

    Ville-Pekka Vahteala (3/27/2014)

    Luis Cazares (3/27/2014)

    How is it possible that someone writes a cursor instead of using SUM()?

    I'm afraid that this database is full of these pieces of sh code...

    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

    March 28, 2014 at 6:52 am

    #1701068

  • RE: missing .mdf and .ldf database file after hard drive crash

    Two things.

    They're not hard drive recovery specialists. If you don't have an mdf and an ldf which doesn't attach or a backup which won't restore (a full-sized backup, not 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

    March 28, 2014 at 12:28 am

    #1700983

  • RE: SQL INSERTS are significanlty slower on newer server

    mberran (3/27/2014)

    GilaMonster (3/27/2014)

    What wait types are you seeing on your data modification queries?

    What do the disk latency counters look like (physical disk sec/read and physical disk sec/write)?

    I requested the information...

    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

    March 27, 2014 at 10:59 am

    #1700803

  • RE: GUID Pirmary key

    Koen Verbeeck (3/27/2014)

    should a table always be clustered instead of a heap?

    Yes, in vast majority of cases.

    Heap has the forwarded records and the non-deallocation of pages to contend with, scans...

    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

    March 27, 2014 at 8:35 am

    #1700713

Viewing 15 posts - 9,496 through 9,510 (of 49,552 total)