Forum Replies Created

Viewing 15 posts - 15,256 through 15,270 (of 49,552 total)

  • RE: Transaction log corruption

    I'd suggest restore from backup 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

    December 12, 2012 at 12:25 pm

    #1568033

  • RE: How to find Transaction

    Probably best bet here is an extended events session with the bucketiser target.

    This should help: http://sqlblog.com/blogs/jonathan_kehayias/archive/tags/XEvent+A+Day/default.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

    December 12, 2012 at 10:36 am

    #1568001

  • RE: Transaction log corruption

    Can you take a log backup?

    Do you have all the log backups since the full last night?

    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

    December 12, 2012 at 10:35 am

    #1567998

  • RE: Enhanced Variable Declaration in SQL Server 2005 Mode

    The only thing that the compat level does is make certain query constructs behave as they did in the lower version. This does not mean that new functionality is disabled,...

    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

    December 12, 2012 at 10:28 am

    #1567995

  • RE: Microsoft Certified Solutions Associate (MCSA)

    So you didn't like our previous advice and decided to ask again. Sorry, same answer. Go and study for the damn cert and don't ask for us to help 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

    December 12, 2012 at 5:46 am

    #1567837

  • RE: Reduce database size

    itsmemegamind (12/12/2012)

    1. Defrag you database

    2. Reorganising the indexes

    3. Partitioning the database or also table

    these operations will definitely improve your server performance and also the database space

    Err, no, they won'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

    December 12, 2012 at 5:36 am

    #1567833

  • RE: Reduce database size

    bdeboer (12/12/2012)

    When looking at our database it's 226 Gb, but the data is 167 Gb and the logfiles 59 Gb. Does this mean that I can reduce the size 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

    December 12, 2012 at 3:00 am

    #1567776

  • RE: Reduce database size

    Lowell (12/5/2012)

    http://sqlserverpedia.com/wiki/Heaps#Deletes_and_Heaps

    Deletes and Heaps

    When data is deleted from a heap using a DELETE statement, SQL Server will not release the space; it remains allocated to the heap. This leads 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

    December 12, 2012 at 2:56 am

    #1567774

  • RE: Microsoft Certified Solutions Associate (MCSA)

    sanandh87 (12/12/2012)

    I want to do MCSA exam. Do any dump available for this? Please let me know.

    Here's a novel idea... Study for it! Like the rest of us who hold...

    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

    December 12, 2012 at 2:52 am

    #1567772

  • RE: Help to optimize SP

    If you have the update failing and you want the insert to be rolled back, then you need a transaction and error handling. Look up Begin transaction and Try... Catch.

    Not...

    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

    December 12, 2012 at 2:01 am

    #1567752

  • RE: Create a policy to avoid backups withou copy_only option

    Hemant.R (12/12/2012)

    hi ,

    you can used copy_only option to take full backup. when transaction log backup job created for same database .

    bcoz it will not break lsn squence of database .

    Full...

    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

    December 12, 2012 at 1:58 am

    #1567751

  • RE: Help to optimize SP

    Update won't fail because it takes too long either, neither will a delete.

    If you have the update failing and you want the insert to be rolled back, then you need...

    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

    December 12, 2012 at 1:17 am

    #1567737

  • RE: Help to optimize SP

    An insert or select won't fail because the server's slow. SQL by itself doesn't care how long a query takes. If the procedure is timing out, then it means 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

    December 12, 2012 at 1:02 am

    #1567734

  • RE: Help to optimize SP

    Timeout is a client-side setting, not a server side. It means the client has got tired of waiting and told SQL to cancel the execution.

    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

    December 12, 2012 at 12:54 am

    #1567730

  • RE: Query optimization

    Please post table definitions, index definitions and execution plan, as per http://www.sqlservercentral.com/articles/SQLServerCentral/66909/

    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

    December 12, 2012 at 12:49 am

    #1567728

Viewing 15 posts - 15,256 through 15,270 (of 49,552 total)