Forum Replies Created

Viewing 15 posts - 26,566 through 26,580 (of 49,552 total)

  • RE: Timeouts occurring, but not reflected in the SQL Server Error Log.

    richard.moses 47670 (4/22/2011)

    I will say that he SOL Server server level time out option is set to 21600 seconds which is 6 hours. Six hours is more than enough...

    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

    April 22, 2011 at 2:15 pm

    #1315027

  • RE: Execution plan analysis

    Please post table and index definitions

    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

    April 22, 2011 at 10:55 am

    #1314950

  • RE: Restricting developer access

    Grant them view definition rights.

    However, I would honestly say that they should do that, like all other development work, on a dev database. Can be a backup/restore of prod, 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

    April 22, 2011 at 10:19 am

    #1314935

  • RE: Best way to move the log file to a different drive

    Shawn Melton (4/22/2011)

    The detach\attach method is the best method if you just need to move it for one database.

    Disagree...

    You can move a database file using ALTER DATABASE, then take just...

    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

    April 22, 2011 at 10:07 am

    #1314926

  • RE: Timeouts occurring, but not reflected in the SQL Server Error Log.

    Timeouts will never appear in the SQL error log, as they are not SQL errors. They are application errors.

    SQL has no timeout. It's happy to run queries for as...

    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

    April 22, 2011 at 10:05 am

    #1314925

  • RE: chnageing Compatibility level in SLQ SERVER 2008

    Marco V (4/21/2011)

    And it will not let you use SQL Server 2000 syntaxes (depcrecated in higer lvl) in comp mode 80 because this is SQL 2005. comp mode 70 is...

    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

    April 22, 2011 at 6:27 am

    #1314849

  • RE: Help needed - Database stopped working

    tim.keen (4/21/2011)

    I think I may have finally figured it out. When I checked the log file settings I noticed that autogrowth was set to a limit of 2 TB which...

    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

    April 22, 2011 at 6:25 am

    #1314848

  • RE: COUNT(*) with WHERE variables too slow with 460 000 records table

    Syed Jahanzaib Bin hassan (4/22/2011)

    OPTION (MERGE JOIN)

    or

    OPTION(MAXDOP 2) --Its depend on the available Processors in the Server

    Got some justification for those suggestions?

    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

    April 22, 2011 at 5:09 am

    #1314836

  • RE: COUNT(*) with WHERE variables too slow with 460 000 records table

    Hello catch-all query (otherwise known as performance nightmare)

    http://sqlinthewild.co.za/index.php/2009/03/19/catch-all-queries/

    Count(1) is the same as count(*), in meaning and performance. Count(<column name>) is not the same in meaning and can only perform the...

    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

    April 22, 2011 at 4:14 am

    #1314826

  • RE: Perfomance Tuning

    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/

    If you run DTA, do it on another server and do not blindly accept recommendations, test each one and see.

    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

    April 22, 2011 at 4:00 am

    #1314822

  • RE: Reindexing job vs Transaction log backup

    The "No current database backup" error means one of two things:

    There's a switch to simple recovery and back to full somewhere between the last successful log backup and the failed...

    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

    April 22, 2011 at 3:57 am

    #1314820

  • RE: SQL Serevr 2008 R2 - All database's restoring.. after transaction log backup

    Ninja's_RGR'us (4/21/2011)

    Could you actually read the thread instead of just posting to rack up your points and traffic back to your site??

    You mean like this? http://www.sqlteam.com/forums/topic.asp?TOPIC_ID=159568

    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

    April 21, 2011 at 10:59 am

    #1314628

  • RE: Will there be a SQL 11 R2?

    Rod at work (4/21/2011)

    Oh, I didn't know that. Thank you for that information, Gail. It could be 2012, then, before Denali is available.

    Possible. Educated guesses put it this...

    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

    April 21, 2011 at 9:29 am

    #1314577

  • RE: Are the posted questions getting worse?

    jcrawf02 (4/21/2011)

    Personally, I learn a lot by being a wallflower in these kinds of conversations, so if it's not in the Thread but you are having it elsewhere, can 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

    April 21, 2011 at 7:54 am

    #1314527

  • RE: Will there be a SQL 11 R2?

    Rod at work (4/12/2011)

    SQL 2011, or SQL 11 for short.

    It's referred to as SQL 11 because the major version number is 11. SQL 2008 was version 10.0, SQL 2008...

    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

    April 21, 2011 at 7:44 am

    #1314512

Viewing 15 posts - 26,566 through 26,580 (of 49,552 total)