Forum Replies Created

Viewing 15 posts - 10,636 through 10,650 (of 49,552 total)

  • RE: associatedObjectID = 72057594049462272

    It's an allocation unit ID, not an object ID. Query sys.partitions.

    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 16, 2013 at 3:00 pm

    #1673880

  • RE: DB data processing take too much time

    Sagar Akhare (12/16/2013)

    Please check index fragmentation, if the fragmentation % is more than 60% need to rebuild the indexes.

    It will improve your performance.

    Maybe, but probably not, and if 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

    December 16, 2013 at 4:49 am

    #1673632

  • RE: DB data processing take too much time

    https://www.simple-talk.com/sql/performance/finding-the-causes-of-poor-performance-in-sql-server,-part-1/

    https://www.simple-talk.com/sql/performance/finding-the-causes-of-poor-performance-in-sql-server,-part-2/

    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 16, 2013 at 4:48 am

    #1673630

  • RE: How to find where one can make good index

    To be honest, the most accurate is to tune by hand, look at problematic queries, create indexes to support them. DTA's OK if you don't know how enough about indexes...

    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 16, 2013 at 3:40 am

    #1673616

  • RE: How to find where one can make good index

    Maybe start by reading up on indexes

    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

    December 14, 2013 at 7:49 am

    #1673466

  • RE: odd situation

    aaron.reese (12/11/2013)

    Not sure what it will do to the cached execution plans though if the statistics for the different schemas are skewed 🙂

    Different execution plans for different users, because...

    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 14, 2013 at 6:09 am

    #1673464

  • RE: Need ideas on how to handle the inserting of millions of rows per day

    Tens of millions of rows a day is low activity. If you were talking millions of rows a second, then I'd understand looking for specialised, non-relational solutions.

    If you're having performance...

    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 14, 2013 at 5:47 am

    #1673463

  • RE: Articles and IP Protection

    tmlink99 (12/13/2013)

    Grant said to just rely on the integrity of the publication. Is that it?

    Yes. What I said here is exactly what I would do if the situation ever...

    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 14, 2013 at 3:04 am

    #1673461

  • RE: Certifications on SQL server 2008 or 2012 ?

    The exams for the SQL 2008 exams are already unavailable. If you want a cert, it'll have to be 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

    December 13, 2013 at 3:18 am

    #1673192

  • RE: SQL Server 2008 R2 - Lock Excalation question

    Not the cached plans and not a screenshot please.

    To see if it's a stats problem, we need the actual execution plans with runtime info (capture using profiler or use SSMS...

    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 13, 2013 at 3:14 am

    #1673191

  • RE: what is Copy-Only Backup?

    Please note: 3 year old thread.

    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, 2013 at 2:03 pm

    #1673082

  • RE: Mirror - 824 Corruption

    This will probably fail, but try ALTER DATABASE ... SET EMERGENCY. If it works you can run a CheckDB in that state (not with repair)

    But any checksum failure is an...

    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, 2013 at 7:21 am

    #1672949

  • RE: The Effect of Reindexing on a backup file

    Only in the 'black box' sense.

    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, 2013 at 6:59 am

    #1672937

  • RE: Mirror - 824 Corruption

    If you're getting an error that a log record can't be redone, then that DB probably won't be coming online, except maybe in SUSPECT state. Try recovering the DB without...

    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, 2013 at 6:58 am

    #1672935

  • RE: The Effect of Reindexing on a backup file

    Depends how big the blocks that the dedupe looks at, but yes, probably they will have changed. This is not a good reason to not rebuild indexes

    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, 2013 at 5:19 am

    #1672899

Viewing 15 posts - 10,636 through 10,650 (of 49,552 total)