Forum Replies Created

Viewing 15 posts - 14,926 through 14,940 (of 49,552 total)

  • RE: Database restore

    mourad.b (1/8/2013)

    Well this is the situation, this is in my home lab and I'm looking to restore an SQl Express 2005 DB to a 2008 SQL server is possible using...

    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

    January 8, 2013 at 3:18 am

    #1574696

  • RE: Log size is Big

    Please read through this - Managing Transaction Logs[/url]

    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

    January 8, 2013 at 2:37 am

    #1574685

  • RE: Deadlock In SQL

    rocky_498 (1/7/2013)

    The Store Procedure "MyStoreProcedure" has 19 Pages hard to post here ( I hope you understand). Some time this SP work fine and Some time i am getting Dead...

    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

    January 7, 2013 at 5:39 pm

    #1574585

  • RE: Deadlock In SQL

    Can you post the definitions for MyStoreProcedure and CM.dbo.saveCodedProcTx, as well as the indexes on the tables CM.dbo.tblEncounters and CM.dbo.tblCharge?

    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

    January 7, 2013 at 5:26 pm

    #1574581

  • RE: Deadlock In SQL

    The entire deadlock graph. Just one of them if there are multiple.

    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

    January 7, 2013 at 5:02 pm

    #1574574

  • RE: SQL Server 2008 R2 TEMPDB massive autogrowth suddenly.

    Joie Andrew (1/7/2013)

    Of couse these solutions are only good if SQL has not been restarted since the TempDB errors, as the DMVs will only collect metrics from the time SQL...

    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

    January 7, 2013 at 4:58 pm

    #1574571

  • RE: Deadlock In SQL

    GilaMonster (1/7/2013)

    Switch traceflag 1222 on. That will result in a deadlock graph been written to the error log every time a deadlock occurs. Post the result of that graph here.

    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

    January 7, 2013 at 4:57 pm

    #1574570

  • RE: SQL Server 2008 R2 TEMPDB massive autogrowth suddenly.

    davidwarner (1/7/2013)

    So what does this leave as likely outcomes?

    Someone ran a query that pulled a lot of data and put an order by on it (or something that required 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

    January 7, 2013 at 4:42 pm

    #1574566

  • RE: Deadlock In SQL

    Switch traceflag 1222 on. That will result in a deadlock graph been written to the error log every time a deadlock occurs. Post the result of that graph here.

    DBCC TRACEON(1222,-1)

    There's...

    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

    January 7, 2013 at 4:36 pm

    #1574564

  • RE: Index usage and RID lookup.

    ScottPletcher (1/7/2013)

    0.375% is almost 4 times 0.1%; yes, the number goes very low, but I don't think it reaches quite down to 0.1% .

    I did say "Usually somewhere around 0.1%-0.5%"

    p.s....

    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

    January 7, 2013 at 3:50 pm

    #1574555

  • RE: When to Index

    My random wafflings on the subject: http://sqlinthewild.co.za/index.php/2011/11/11/sql-university-advanced-indexing-indexing-strategies/

    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

    January 7, 2013 at 3:12 pm

    #1574546

  • RE: sql auditing triggers

    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

    January 7, 2013 at 3:04 pm

    #1574543

  • RE: Backup Log Incorrect Function Message (nonrecoverable I/O error).

    Just a comment on your 'solution', you got lucky there, SQL cannot always recreate the log file if it's lost. It's very possible that deleting the log file will result...

    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

    January 7, 2013 at 2:55 pm

    #1574542

  • RE: Index usage and RID lookup.

    ScottPletcher (1/7/2013)

    Fewest rows? The number of rows that match all the criteria will be the same regardless of the index used, right?

    Match all criteria, yes. What I was thinking...

    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

    January 7, 2013 at 2:54 pm

    #1574541

  • RE: Index usage and RID lookup.

    ScottPletcher (1/7/2013)

    If so, SQL will use that; if multiple indexes with all columns, SQL uses the one with the shortest row.

    The most selective one (the one that, based on...

    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

    January 7, 2013 at 1:07 pm

    #1574500

Viewing 15 posts - 14,926 through 14,940 (of 49,552 total)