Forum Replies Created

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

  • RE: DBCC Commands like CHECKDB and calculating estimated Duration

    Odd. The checkDB shows 3 pages with errors, all in the clustered index.

    Could something have deleted rows from that table (and resulted in pages deallocated) before the backup that you're...

    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 23, 2010 at 11:55 am

    #1254659

  • RE: Are the posted questions getting worse?

    WayneS (11/23/2010)

    LOL! Yeah, I just bought two a couple of weeks ago (brings me to 3 on that list) - Kalen's and Grant's are the ones I picked up then....

    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 23, 2010 at 11:43 am

    #1254655

  • RE: Are the posted questions getting worse?

    CirquedeSQLeil (11/23/2010)

    GilaMonster (11/23/2010)

    R131 for 2 books, R183 for shipping, and the books should be here by Feb.

    Ouch. If it won't be until Feb, would it be more cost effective...

    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 23, 2010 at 11:30 am

    #1254644

  • RE: Which process and memory

    Please post new questions in a new thread. Thanks

    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 23, 2010 at 11:25 am

    #1254636

  • RE: Are the posted questions getting worse?

    R131 for 2 books, R183 for shipping, and the books should be here by Feb.

    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 23, 2010 at 11:18 am

    #1254630

  • RE: Column Order in an Index

    cengland0 (11/23/2010)

    Doh, I just discovered the maximum key length is 900 bytes so combining two VARCHAR(500) columns into one index results in a warning:

    The maximum key length is 900 bytes....

    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 23, 2010 at 11:06 am

    #1254620

  • RE: Are the posted questions getting worse?

    CirquedeSQLeil (11/23/2010)

    GilaMonster (11/23/2010)

    CirquedeSQLeil (11/23/2010)

    If you were to buy a SQL book, what would you buy? If there is a topic you wanted to learn about, what is 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

    November 23, 2010 at 11:00 am

    #1254612

  • RE: Are the posted questions getting worse?

    CirquedeSQLeil (11/23/2010)

    If you were to buy a SQL book, what would you buy? If there is a topic you wanted to learn about, what is it? Is there...

    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 23, 2010 at 10:34 am

    #1254595

  • RE: Are the posted questions getting worse?

    Craig Farrell (11/23/2010)

    Yep, one definately has job security, and I actually don't consult the way Gail and the rest do to clean up systems, I just travel as a fill-in...

    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 23, 2010 at 10:32 am

    #1254594

  • RE: Datbase is in Suspect mode

    Brandie Tarvin (11/23/2010)

    homebrew01 (11/23/2010)

    When I have a job that I want disabled for a period of time. instead of disabling it, I often change the start date to a future...

    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 23, 2010 at 10:29 am

    #1254592

  • RE: Missing Index Suggestion

    Don't discount indexes with a bit as a leading column. Especially if lots of queries include that bit column in the where clause. I wouldn't suggest you index it alone,...

    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 23, 2010 at 10:29 am

    #1254591

  • RE: Missing Index Suggestion

    Stefan Krzywicki (11/23/2010)

    Response to Long Answer: That's what I thought from reading the Books Online entry, that the columns would only be there once either way, but it is good...

    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 23, 2010 at 10:20 am

    #1254586

  • RE: Missing Index Suggestion

    An index on a bit field, probably not. But this is not an index on a bit field. It's a composite index on a bit and a date with include...

    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 23, 2010 at 10:17 am

    #1254583

  • RE: Missing Index Suggestion

    Short answer: Because the missing index functionality is rather limited (read stupid) and lists EXACTLY the index that it thinks it wants.

    Longer answer: The columns will be there whether 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

    November 23, 2010 at 10:09 am

    #1254576

  • RE: Are the posted questions getting worse?

    Grant Fritchey (11/23/2010)

    Oh yes. Can't wait. I love hearing these stories. Kevin Boles was regaling me recently. It's simply amazing. Although, I see amazingly stupid stuff in the company 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

    November 23, 2010 at 10:07 am

    #1254574

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