Forum Replies Created

Viewing 15 posts - 34,456 through 34,470 (of 49,552 total)

  • RE: SP evaluate

    Run it and gets its execution characteristics via Profiler (or server-side trace)

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

    http://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

    January 24, 2010 at 11:46 pm

    #1108017

  • RE: Stored Proc returning invalid data

    Please post table definitions, sample data and desired output. Read this to see the best way to post this to get quick responses.

    http://www.sqlservercentral.com/articles/Best+Practices/61537/

    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 24, 2010 at 11:38 pm

    #1108014

  • RE: Simulation Questions Exam 70-431

    harryamow (1/24/2010)

    I got the same problem where I had to ...

    What you've said there is in violation of the exam NDA agreement that you accepted when you wrote...

    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 24, 2010 at 11:35 pm

    #1108013

  • RE: 0 allocation, 1 consistency error -- repair_rebuild min repair level didn’t fix

    Just an addendum, now that the crisis has passed...

    From what I saw in the list of indexes, you may have a few too many indexes on that table (though too...

    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 24, 2010 at 11:29 pm

    #1108012

  • RE: Log file is gone

    Good to hear. Just to be sure that there's no lingering damage, please run this

    DBCC CHECKDB (<Database Name>) WITH NO_INFOMSGS, ALL_ERRORMSGS

    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 24, 2010 at 11:23 pm

    #1108010

  • RE: Is it possible to keep my database in RAM????

    That's a lot more complex than just adding a second instance and moving the 3 DBs there, as has been earlier 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

    January 24, 2010 at 11:23 pm

    #1108009

  • RE: Avoiding Log full Error

    Ol'SureHand (1/24/2010)

    the log size will be maintained reasonably small by regular FULL backups (if the recovery mode is Simple)

    Errr, no.

    What allows for log space reuse in Simple recovery...

    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 24, 2010 at 11:20 pm

    #1108008

  • RE: Not getting desired results

    Please post table definitions, sample data and desired output. Read this to see the best way to post this to get quick responses.

    http://www.sqlservercentral.com/articles/Best+Practices/61537/

    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 24, 2010 at 2:21 pm

    #1107956

  • RE: SQL Server 2005 server login worked, then did not

    Password change?

    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 24, 2010 at 11:40 am

    #1107941

  • RE: How to know what time a table is last-updated?

    You need a trigger or a trace. It's not something that SQL keeps track of itself.

    If you can give more detail on what you want, I can give you better...

    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 24, 2010 at 11:10 am

    #1107937

  • RE: Primary keys and indexes

    Is google down today?

    http://msdn.microsoft.com/en-us/library/ms190273.aspx

    There are several examples at the bottom

    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 24, 2010 at 8:47 am

    #1107915

  • RE: Log file is gone

    I would recommend just restoring from your backups. While this may complete (or may not) it may cause data loss, transactional inconsistencies, structural inconsistencies or other similar problems.

    Emergency mode repair...

    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 24, 2010 at 7:53 am

    #1107911

  • RE: understand following concepts of resouce database:

    luckysql.kinda (1/24/2010)

    Could you go through following article where I found these statements under the heading of 'Advantages of Resource db'.

    http://www.sql-server-performance.com/articles/dba/Importance_of_the_Resource_Database%20_p1.aspx

    I'm going to call that complete garbage and dangerous information.

    While service...

    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 24, 2010 at 7:47 am

    #1107909

  • RE: Avoiding Log full Error

    mahesh.vsp (1/23/2010)

    I thought, whenever i say SIMPLE recovery model, when log file reaches 70-80% , then automatically overwrittes the LOG file but it is not happended and result in

    LOG FULL...

    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 24, 2010 at 12:53 am

    #1107890

  • RE: understand following concepts of resouce database:

    The resource database, especially in SQL 2008, should be treated as if it were a binary file, a .dll file or the like. It should not be moved, messed 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

    January 24, 2010 at 12:49 am

    #1107889

Viewing 15 posts - 34,456 through 34,470 (of 49,552 total)