Forum Replies Created

Viewing 15 posts - 40,411 through 40,425 (of 49,552 total)

  • RE: Different backup/restore sizes

    Dp you perhaps have two or more backups in one file? If you backup to a file with an existing backup and don't use the WITH INIT option, the new...

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

    #957790

  • RE: SQL Performance

    Nolock allows for what's called an allocation order scan, where the storage engine reads the index leaf pages in the order they are in the file, not the logical order...

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

    #957788

  • RE: Are the posted questions getting worse?

    Lynn Pettis (3/11/2009)

    GilaMonster (3/11/2009)

    Roy Ernest (3/11/2009)

    I think we have good one here...

    Let us see if he comes back with a positive answer or not.

    Bet you a coffee that either he...

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

    #957738

  • RE: SQL Performance

    Gianluca Sartori (3/11/2009)

    If you're sure every user works only on his data, try putting some NOLOCK in the select satements to avoid table and page locking during reads.

    Provided you 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

    March 11, 2009 at 11:28 am

    #957733

  • RE: Are the posted questions getting worse?

    Roy Ernest (3/11/2009)

    I think we have good one here...

    Let us see if he comes back with a positive answer or not.

    Bet you a coffee that either he comes back 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

    March 11, 2009 at 11:20 am

    #957716

  • RE: The dumbest database design ever - shoot me

    barcode (3/11/2009)

    Everyone's been telling me that Index Tuning Wizard is the best thing since sliced bread but I've also been having my doubts lately!

    Personally, I don't use the ITW...

    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 11, 2009 at 9:08 am

    #957575

  • RE: Can I make this any faster

    My gut feel is that the function is, if not the root of the problem, obscuring the root of the problem.

    Can we see the code for the function? We...

    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 11, 2009 at 6:48 am

    #957421

  • RE: DDL auditing in sql server2000

    Profiler or a server-side trace.

    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 11, 2009 at 6:37 am

    #957415

  • RE: The dumbest database design ever - shoot me

    barcode (3/11/2009)

    My Question: Will it help if I spent time on the database, clear all existing indexes, then start and create the correct primary key for each column. ...

    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 11, 2009 at 6:37 am

    #957414

  • RE: Transaction Log Shrinking

    CrazyDBA (3/11/2009)

    I have investigated through dbcc log info, all log files have most VLF's(about 400) with status 0, only couple has value 2. Its size should come down to about...

    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 11, 2009 at 6:33 am

    #957409

  • RE: updatable view

    Giovanni (3/11/2009)

    I confirm the design is related to OO structure that we have to write in c#: mapping a class to the view instead of having a business logic 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 11, 2009 at 6:27 am

    #957397

  • RE: Problem with Stored procedure

    peace2007 (3/11/2009)

    I've run a server side trace. now, when I want to open it in DTS for analyzing it says the file is in use. I tried to stop 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

    March 11, 2009 at 6:21 am

    #957392

  • RE: Execution plan

    Post table definitions, index definitions and execution plan (saved as a .sqlplan file, zipped and attached)

    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 11, 2009 at 6:20 am

    #957390

  • RE: Execution plan

    How long does the query take to run?

    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 11, 2009 at 1:15 am

    #957288

  • RE: Calculating Totals

    Duplicate post. No replies to this thread please. Direct replies to:http://www.sqlservercentral.com/Forums/Topic673017-147-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

    March 11, 2009 at 1:14 am

    #957287

Viewing 15 posts - 40,411 through 40,425 (of 49,552 total)