Forum Replies Created

Viewing 15 posts - 13,381 through 13,395 (of 49,552 total)

  • RE: Capturing workload for analysis

    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/

    DMVs can miss queries because of plan removal or plans never cached.

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

    #1608965

  • RE: weird dbid from sys.dm_exec_query_stats

    32767, the system resource database.

    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 23, 2013 at 2:18 am

    #1608964

  • RE: SQL server logs backup / reduction

    Shrink to X GB (where X is the size the log needs to be for normal operation)

    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 23, 2013 at 1:44 am

    #1608961

  • RE: SQL server logs backup / reduction

    Ice007 (4/22/2013)

    Cannot open backup device '\\X\analyitcs\test_UNC.BAK'. Operating system error 53(The network path was not found.).

    As the error message says, the network path does not exist. Nor would I expect 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

    April 22, 2013 at 3:53 pm

    #1608895

  • RE: A backup is made on SQL Server 2005, can it be restored to SQL Server 2008 R2 engine?

    haiao2000 (4/22/2013)

    Thanks Sean,

    So after restored on a SQL 2008 R2 engine, the database being upgrated to 2008 R2 or is it still considered sort of SQL 2005 database running on...

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

    #1608874

  • RE: SQL server logs backup / reduction

    GilaMonster (4/22/2013)

    Please read through this - Managing Transaction Logs[/url] and http://www.sqlservercentral.com/articles/Transaction+Log/72488/

    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, 2013 at 1:49 pm

    #1608832

  • RE: SQL server logs backup / reduction

    aayushmail007 (4/22/2013)

    My data gets updated daily once.

    I need more space in disk and historical data changes is not necessary because i can use backup to create them back again (...

    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, 2013 at 1:17 pm

    #1608821

  • RE: Are the posted questions getting worse?

    I'm just going to leave this one here http://www.sqlservercentral.com/Forums/Topic1445111-357-1.aspx, have mercy on him. 🙂

    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, 2013 at 12:59 pm

    #1608808

  • RE: SQL server logs backup / reduction

    Please read through this - Managing Transaction Logs[/url] and http://www.sqlservercentral.com/articles/Transaction+Log/72488/

    3)Will my data get effected if I create new similar name files and delete previous one after backing them up?

    Other than...

    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, 2013 at 12:56 pm

    #1608805

  • RE: Deattach or take offline the DB to copy

    Please note: 4 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

    April 22, 2013 at 12:28 pm

    #1608798

  • RE: Slow performing query!

    Why are you joining on a hash of several columns in the first place?

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

    #1608780

  • RE: 70-461 - Done, but more difficult than expected

    Just a warning, discussing what's in the exam is a violation of the NDA that you accepted when writing that exam, so watch what you say about the contents of...

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

    #1608779

  • RE: Nesting of Procedures

    SELECT @@NestLevel

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

    #1608593

  • RE: Log backups while Full/Differential backups are running

    Let's see... what happens when we have a 6-hour full backup duration and a 15 minute data loss SLA and log backups don't run during that full backup?

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

    #1608562

  • RE: Slows system performance

    IgorMi (4/21/2013)

    Just had similar scenario yesterday, without locks but with high cpu. Some update scripts were running for 'forever'. We stopped them, rebuilt the indexes and run again and they...

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

    #1608561

Viewing 15 posts - 13,381 through 13,395 (of 49,552 total)