Forum Replies Created

Viewing 15 posts - 23,116 through 23,130 (of 49,552 total)

  • RE: 30 hours rollback

    Ninja's_RGR'us (10/3/2011)

    If I were in the ops shoes, change management procedure / code reviews would be on top of my list in the currently hapenning meeting.

    And a QA environment with...

    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

    October 3, 2011 at 8:47 am

    #1389578

  • RE: DBCC CHeckDB issue

    Run the following, post the full and complete results.

    DBCC CHECKDB (<Database Name>) WITH NO_INFOMSGS, ALL_ERRORMSGS

    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

    October 3, 2011 at 8:38 am

    #1389571

  • RE: 30 hours rollback

    A few more answers:

    Chances the rollback will fail: virtually none. SQL ensures that it reserves space in the tran log to roll any transaction back.

    Bloating of the log: Only due...

    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

    October 3, 2011 at 8:37 am

    #1389569

  • RE: Dead lock issue

    As I said right at the beginning...

    GilaMonster (9/19/2011)

    That's JDBC stuff, has to do with it's transaction handling.

    Nothing more that can really be said with the little you posted.

    I'd start...

    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

    October 3, 2011 at 8:30 am

    #1389559

  • RE: Backup Failure

    http://www.sqlservercentral.com/articles/Transaction+Log/72488/

    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

    October 3, 2011 at 12:14 am

    #1389292

  • RE: Parallel Processing in SQL ?

    prithvi.m (10/2/2011)

    This would mean that you need to use Degree's of Parallelism (MAXDOP).

    Err, no.

    MAXDOP sets the maximum number of cores that operators in a single query can run. What...

    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

    October 2, 2011 at 11:56 pm

    #1389288

  • RE: Partitioning a table with 50 million records - What should be the strategy ?

    Maybe, but probably not. (Can't say more with such little info)

    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

    October 2, 2011 at 11:54 pm

    #1389287

  • RE: Shoud you add clusteirng key in included col of non clustered index?

    Because the optimiser doesn't consider the definition of the clustered index when recommending non-clustered indexes.

    If you need the clustering key in an non-clustered index, specify it. If you don't, leave...

    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

    October 2, 2011 at 5:32 pm

    #1389250

  • RE: Partitioning a table with 50 million records - What should be the strategy ?

    Lynn Pettis (10/2/2011)

    I've read that partitioning can enhance performance if it is done for the right reasons. In this case, if most of the queries are restricted to 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

    October 2, 2011 at 5:24 pm

    #1389249

  • RE: Partitioning a table with 50 million records - What should be the strategy ?

    Partitioning for performance seldom works. That's just not a good reason to partition tables in general.

    The high level steps are detailed in Books Online. Create the partition scheme (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

    October 2, 2011 at 11:31 am

    #1389220

  • RE: Partitioning a table with 50 million records - What should be the strategy ?

    What's the reason for partitioning the 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

    October 2, 2011 at 9:56 am

    #1389216

  • RE: will updating though a view help speed up the database response time?

    As I said, At best it'll have no effect. At worst it'll slow things down.

    If you have blocking you really have 3 options:

    Tune the queries (they're unlikely to be...

    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

    October 2, 2011 at 9:54 am

    #1389215

  • RE: will updating though a view help speed up the database response time?

    No. At best it'll have no effect. At worst it'll slow things down.

    If you mean an indexed view (a view with a clustered index) that will potentially slow all updates...

    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

    October 2, 2011 at 8:06 am

    #1389208

  • RE: procedure

    Duplicate post. No replies to this thread please. Direct replies to:http://www.sqlservercentral.com/Forums/Topic1184035-391-1.aspx

    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

    October 2, 2011 at 4:33 am

    #1389193

  • RE: Could not find database ID 14

    giontech (10/1/2011)

    GilaMonster (10/1/2011)

    giontech (10/1/2011)

    By the way, the database files are still in the MSSQL Data Folder, it was like 30 minutes past already since I clicked to take offline, obviously...

    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

    October 2, 2011 at 4:31 am

    #1389192

Viewing 15 posts - 23,116 through 23,130 (of 49,552 total)