Forum Replies Created

Viewing 15 posts - 12,481 through 12,495 (of 49,552 total)

  • RE: Autonumber field sometimes skips a 1000

    SQL Server 2012?

    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

    July 4, 2013 at 8:09 am

    #1629836

  • RE: Table Locks

    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

    July 4, 2013 at 6:21 am

    #1629820

  • RE: SQL I/O Errors

    Can you explain in more detail what you're after?

    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

    July 4, 2013 at 6:21 am

    #1629818

  • RE: memory

    Resource governor (though it may not do what you expect) and server memory settings.

    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

    July 4, 2013 at 6:20 am

    #1629817

  • RE: How to find who changed the database to Single_user mode.

    SQL will never automatically change the recovery model. If it was changed, someone changed it.

    Check the default trace, if the change was recent enough it may still be in there.

    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

    July 4, 2013 at 4:04 am

    #1629790

  • RE: Queries that cause full scan table

    "Number of read block"?

    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

    July 4, 2013 at 4:01 am

    #1629788

  • RE: Overhead on a NC index if the key fields are not updated during production.

    SQLSACT (7/4/2013)

    Hi Gail - Just to confirm, is this part correct?

    if you are changing the Clustering key at all with your updates, all nonclustered indexes will be affected as well...

    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

    July 4, 2013 at 3:59 am

    #1629786

  • RE: Difference between Cluster and Index

    Take a read through these

    http://www.sqlservercentral.com/articles/Indexing/68439/

    http://www.sqlservercentral.com/articles/Indexing/68563/

    http://www.sqlservercentral.com/articles/Indexing/68636/

    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

    July 3, 2013 at 11:47 am

    #1629632

  • RE: Procedure Cache Size: Monitoring and Adjusting

    There are no settings or switches that allow you to directly control the plan cache size. It's maximum will be a function of the max server memory, that's about all.

    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

    July 3, 2013 at 11:46 am

    #1629631

  • RE: Using snapshots for reporting on historical data?

    Not a good idea.

    Snapshots impact insert/update/delete performance, they take up space, they can't be backed up and if for any reason you need to restore the source database you'll have...

    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

    July 3, 2013 at 9:08 am

    #1629566

  • RE: Right click on a Database, select properties Error, cannot show requested dialog.

    Check that the database owner is set to a valid account. SA is often used.

    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

    July 3, 2013 at 9:01 am

    #1629560

  • RE: Overhead on a NC index if the key fields are not updated during production.

    If you are never modifying any of the columns that are in the index, then the index has no update overhead. It'll still add overhead to inserts and deletes, but...

    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

    July 3, 2013 at 9:00 am

    #1629559

  • RE: index advantage query

    Don't create missing indexes off the missing index DMV unless you've tested and ensured they really are useful.

    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

    July 3, 2013 at 1:27 am

    #1629385

  • RE: Invalid object even though script should never run

    That doesn't fail because of something called deferred compile. If a table isn't found at parse/compile time, the statement that refers to that table is not parsed or compiled (past...

    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

    July 3, 2013 at 1:13 am

    #1629378

  • RE: tail log backup

    When your database is damaged and you are trying to do a last-ditch backup of the log before starting restoring over it, or when for other reasons you're restoring or...

    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

    July 3, 2013 at 1:08 am

    #1629376

Viewing 15 posts - 12,481 through 12,495 (of 49,552 total)