Forum Replies Created

Viewing 15 posts - 29,341 through 29,355 (of 49,552 total)

  • RE: Almost identical indexes with nested include columns - any advantage?

    Virtually none. There are some specialised cases where having two near identical indexes is advantageous, but it' mostly about the width of the index and it's not common.

    This is one...

    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

    November 17, 2010 at 9:55 am

    #1251977

  • RE: How to shrink Database Snapshot (Sparse File)?

    Reo (11/17/2010)

    You are right! When I right click on .ss file and check file property it shows File Size: 50GB and Size on disk: 200MB That’s I am looking for.

    That'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

    November 17, 2010 at 8:22 am

    #1251923

  • RE: How to change SQL Server Collation

    eduardo.pin (11/17/2010)

    I don't know How, but it works just fine. Easy, clean, fast.

    Anybody knows how this command works?

    You're running and recommending commands that you don't know 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

    November 17, 2010 at 8:20 am

    #1251920

  • RE: how often does procedural cache gets refreshed?

    Adiga (11/17/2010)

    This article has some good information.

    That article is seriously out of date and a lot of the information in there is not valid for SQL 2005 or above.

    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

    November 17, 2010 at 4:50 am

    #1251817

  • RE: how often does procedural cache gets refreshed?

    The procedure cache only gets completely cleared if you request it (DBCC FREEPROCCACHE) or if certain server configuration changes occur (some of the sp_configure options) or for certain other server...

    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

    November 17, 2010 at 4:43 am

    #1251813

  • RE: DBCC CHECKDB resulted in error

    Are you using diskeeper?

    I suspect you're running into this issue. Please check what disk utilities you have installed.

    http://blogs.msdn.com/b/psssql/archive/2010/01/08/dbcc-check-commands-encounter-problems-and-reports-errors.aspx

    http://sqlblog.com/blogs/jonathan_kehayias/archive/2009/12/10/a-tale-of-checkdb-failures-cause-by-3rd-party-file-system-drivers.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

    November 17, 2010 at 4:29 am

    #1251806

  • RE: How to shrink Database Snapshot (Sparse File)?

    The size of the sparse file may be 50GB, but the size on disk should not be. Sparse files are only as large as the data in them. If you've...

    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

    November 17, 2010 at 4:26 am

    #1251804

  • RE: Is it bad to disable Page locking for a table?

    If you do it for the wrong reasons, yes it is bad.

    Disable page locks and you may just get table locks instead. It may fix the deadlocks, but the concurrency...

    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

    November 17, 2010 at 12:24 am

    #1251707

  • RE: Restore Database

    You can try the following:

    RESTORE DATABASE <DB Name> WITH RECOVERY

    That may fail and, if it does, you will have to find a backup for the DB you overwrote and restore...

    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

    November 17, 2010 at 12:22 am

    #1251706

  • RE: Are the posted questions getting worse?

    CirquedeSQLeil (11/16/2010)

    FWIW, I found the easiest way to add feeds to categories is through feedburner. There are also plugins available for doing it - but I prefer the feedburner...

    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

    November 17, 2010 at 12:20 am

    #1251705

  • RE: How to change SQL Server Collation

    Then you need to script and drop all of them, change the collation and recreate them

    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

    November 17, 2010 at 12:17 am

    #1251703

  • RE: SQL 2005 execution plan problem

    The optimiser changed. There will be occasional cases where a query plan gets worse, it comes with the territory.

    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

    November 16, 2010 at 7:13 am

    #1251333

  • RE: Stored Procuders which has multiple execution plans

    ps. (11/16/2010)

    In some cases, query processor may keep two plans, 1) without using parallelism, 2) using parallism and use either of them.

    Nope. Recently debunked by Paul White (I'll leave it...

    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

    November 16, 2010 at 6:29 am

    #1251285

  • RE: SQL 2005 execution plan problem

    Have you updated all stats after the upgrade? It is highly recommended.

    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

    November 16, 2010 at 3:46 am

    #1251202

  • RE: Stored Procuders which has multiple execution plans

    The only way you'll have multiple plans per procedure is if the procedure has been run with different SET options. Certain set options (see BoL for details) change the way...

    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

    November 16, 2010 at 3:45 am

    #1251200

Viewing 15 posts - 29,341 through 29,355 (of 49,552 total)