Forum Replies Created

Viewing 15 posts - 27,106 through 27,120 (of 49,552 total)

  • RE: is Dbcc checkdb command is checking the database log file also

    Can you post the 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

    March 25, 2011 at 2:28 am

    #1303403

  • RE: Are the posted questions getting worse?

    Gianluca Sartori (3/25/2011)

    THE THREAD could be a great source of inspiration, but would spoil the joke for all the threadizens...

    (13)

    As long as no one goes off and starts an SSC...

    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 25, 2011 at 2:28 am

    #1303402

  • RE: Changing IDENTITY column of a huge table from INT to BIGINT - is there a way without recreating the entire table?

    If it's a primary key, drop it and all foreign keys that reference it. Then you should be able to just do an ALTER TABLE ... ALTER COLUMN

    That said, a...

    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 25, 2011 at 2:14 am

    #1303397

  • RE: Are the posted questions getting worse?

    I just realised I don't have an April Fools day blog post planned. 🙁

    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 25, 2011 at 2:11 am

    #1303396

  • RE: Are the posted questions getting worse?

    I really have better things I could be doing on a friday than sitting at Client from Hell, writing a support document.

    Q: What to do if the user complains that...

    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 25, 2011 at 2:10 am

    #1303395

  • RE: Are the posted questions getting worse?

    Gianluca Sartori (3/25/2011)

    Koen Verbeeck (3/25/2011)

    Gianluca Sartori (3/25/2011)

    20 posts to go!

    What a glorious day it will be! And the sun is shining too!

    (19)

    edit: 18, someone beat me to a post

    Would 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

    March 25, 2011 at 2:06 am

    #1303394

  • RE: is Dbcc checkdb command is checking the database log file also

    I don't think it does. Not 100% sure, checking...

    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

    March 25, 2011 at 2:03 am

    #1303392

  • RE: Trigger is causing a lock in a system

    Profiler/server-side trace. Statement completed event.

    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 25, 2011 at 1:59 am

    #1303390

  • RE: Application Slow

    http://www.simple-talk.com/sql/performance/finding-the-causes-of-poor-performance-in-sql-server,-part-1/

    http://www.simple-talk.com/sql/performance/finding-the-causes-of-poor-performance-in-sql-server,-part-2/

    http://www.amazon.com/Server-Performance-Tuning-Distilled-Experts/dp/1430219025/

    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 25, 2011 at 1:58 am

    #1303389

  • RE: Is my Database consistent after running DBCC CHECKDB with ALLOW_DATA_LOSS

    Not from the checkDB, it just rebuilt the log. The concern is if there were any transactions (or partial transactions) that had been written to the log but not 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

    March 25, 2011 at 1:58 am

    #1303388

  • RE: Set Statistics Time oddity.

    Parallelism. If the query paralleled 4-ways and spend a total of 2 seconds executing on each processor that's a CPU time of 8 seconds while it may have only taken...

    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 24, 2011 at 11:40 pm

    #1303356

  • RE: database corruption found

    djordan 4543 (3/24/2011)

    Just on a side note I read somewhere databases can be corrupted due to bad index maintenance - how does that happen?

    Nope. Bugs (in SQL, in-process 3rd party...

    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 24, 2011 at 11:36 pm

    #1303354

  • RE: Are the posted questions getting worse?

    Craig Farrell (3/24/2011)

    Nope that's the book where Ronald Feeblebutt decides to lead the resistance while our 'Hero' wanders around hopelessly lost waiting for his friends to tell him what 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

    March 24, 2011 at 4:05 pm

    #1303281

  • RE: Server losing access to disks

    Please post new questions in a new thread. Thank 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 24, 2011 at 3:58 pm

    #1303276

  • RE: Select Distinct on indexed column is not instant

    Florent Rousseau (3/24/2011)

    My understanding of b-tree structure of indexes was that it would held on the highest page level the list of the distinct values along with the pointers 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

    March 24, 2011 at 3:58 pm

    #1303275

Viewing 15 posts - 27,106 through 27,120 (of 49,552 total)