Forum Replies Created

Viewing 15 posts - 36,796 through 36,810 (of 49,552 total)

  • RE: DBCC CHECKDB consistency errors

    Paul Randal (8/27/2009)

    I really need to write a comprehensive guide to CHECKDB errors and troubleshooting corruption...

    Somehow I don't think that would be a short document... more like a doorstop 😉

    How...

    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 27, 2009 at 6:30 am

    #1045463

  • RE: Are the posted questions getting worse?

    Grant Fritchey (8/27/2009)

    I think I got one from the same guy. He said "I know this is the wrong way to ask this..." so I told them "Then why did...

    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 27, 2009 at 5:56 am

    #1045451

  • RE: Are the posted questions getting worse?

    Edit: Duplicate

    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 27, 2009 at 5:30 am

    #1045439

  • RE: Are the posted questions getting worse?

    Not doing Neotel. I've had more than enough of wireless. I'm tired of the latency and the connection problems every time it rains. Besides, the high-speed internet's not available 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

    August 27, 2009 at 5:21 am

    #1045436

  • RE: DBCC CHECKDB consistency errors

    If you have no backup then you are going to have to take the database into single user mode and run CheckDB with the repair_allow_data_loss option. This will lose 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

    August 27, 2009 at 4:53 am

    #1045423

  • RE: If the Storage is on SAN, then the Perfmon counter readings are incorrect!!!!

    Ok, the Disk queue length reported by perfmon is correct. There's no question there. The problem is the traditional interpretation of that counter is that if it exceeds 2 per...

    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 27, 2009 at 4:35 am

    #1045413

  • RE: Are the posted questions getting worse?

    Sentech. I haven't heard about similar problems from iBurst or Neotel, but have no experience with them.

    My contract is finally up in March (cancellation fees are very high, that's why...

    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 27, 2009 at 4:33 am

    #1045412

  • RE: Does creating an clustered index physically sort the table

    The clustered index is the table. A clustered index has, at the leaf level, the actual data pages of the table and SQL will do it's best, at time of...

    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 27, 2009 at 1:13 am

    #1045355

  • RE: If the Storage is on SAN, then the Perfmon counter readings are incorrect!!!!

    I haven't ever heard that. Is that your opinion or are you asking for clarification of something you're read? If the former, why do you think that, if the latter,...

    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 26, 2009 at 11:20 pm

    #1045331

  • RE: Are the posted questions getting worse?

    K. Brian Kelley (8/26/2009)

    Lynn Pettis (8/26/2009)

    So, what was the question and how did you handle it? I've just started ignoring requests for help sent via PM. I don't...

    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 26, 2009 at 11:13 pm

    #1045330

  • RE: First run of a query takes much longer

    glu (8/26/2009)

    This is the same query of different executions, and return the same numebr of rows, thus network load is the same. This scenario has been repeated many times and...

    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 26, 2009 at 11:12 pm

    #1045329

  • RE: First run of a query takes much longer

    glu (8/26/2009)

    What puzzles me is that, take one table as example, display of SET STATISTICS IO ON shows "logical reads 62832, physical reads 55, read-ahead reads 1190" in the case...

    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 26, 2009 at 11:09 pm

    #1045328

  • RE: Need help Restoring database to what it was this at 12:00pm

    Expanding a bit on Steve's post.

    Restore the full WITH NORECOVERY

    Restore the latest differential WITH NOERCOVERY. You don't need both differentials

    Restore all the log backups, in sequence, starting with 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 26, 2009 at 1:51 pm

    #1045144

  • RE: Space required to restore a backup

    Amit Singh (8/26/2009)

    Once restored ... shrink the Data and log files to release free space ..... then take another full backup of this shrinked databse and use that to restire...

    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 26, 2009 at 8:54 am

    #1044929

  • RE: Space required to restore a backup

    matty_o_connor01 (8/26/2009)

    The database below has a size of 3.289 gig

    Whereas the resultant .bak file from a backup with all the defaults is 2.375 gig

    So the files in total are 3.2GB,...

    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 26, 2009 at 8:52 am

    #1044926

Viewing 15 posts - 36,796 through 36,810 (of 49,552 total)