Forum Replies Created

Viewing 15 posts - 16,441 through 16,455 (of 49,552 total)

  • RE: log reuse wait description. (checkpoint)

    Is there a problem?

    If not, then just ignore this, especially if the DB is in simple recovery model where that is a very normal log reuse wait.

    See: 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

    September 26, 2012 at 7:34 am

    #1542396

  • RE: SQL Disk to Memory

    SQLSACT (9/26/2012)

    This whole post is under the assumption that we're only querying data, we are not doing any Inserts, Updates or Deletes, right?

    No, not really.

    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

    September 26, 2012 at 7:29 am

    #1542391

  • RE: need answer

    Start with your SLAs. What is the RPO for that database (recovery point objective, or how much data may be lost)? What is the RTO (recovery time objective or how...

    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

    September 26, 2012 at 4:23 am

    #1542299

  • RE: Index !!!!

    Backup log, yes.

    Explicit truncation of log, no.

    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

    September 26, 2012 at 4:17 am

    #1542297

  • RE: trailing space in len() problem

    There were. I have no idea if there was one relating to LEN of a max data type. Maybe worth reading the kb articles.

    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

    September 26, 2012 at 3:40 am

    #1542277

  • RE: trailing space in len() problem

    That's not what I said....

    There were some nasty memory issues on SQL 2005 RTM, security holes and other unpleasant bugs and hence I strongly recommend that the instance be upgraded...

    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

    September 26, 2012 at 3:16 am

    #1542267

  • RE: SQL Disk to Memory

    Maybe, but maybe not. Older pages may still get tossed out.

    Unless you have buffer pool > total size of all DBs in use, you can't assume that there will be...

    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

    September 26, 2012 at 3:10 am

    #1542263

  • RE: trailing space in len() problem

    SQL 2005 RTM? Oooh.. There were some nasty issues around memory usage fixed in SP2.. I'd recommend you upgrade to SP4 on that one.

    Also check your client connections, see if...

    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

    September 26, 2012 at 3:06 am

    #1542260

  • RE: Understanding the difference between Join and Where filters - SQL 2008R2

    Yes, those two will be identical.

    While the string manipulation's in the select, that derived column is used in the where, so it's absolutely the same as having the string manipulation...

    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

    September 26, 2012 at 1:52 am

    #1542248

  • RE: trailing space in len() problem

    What versions are those two servers?

    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

    September 26, 2012 at 1:47 am

    #1542245

  • RE: MCITP Certification

    Half my clients are still running SQL 2005. The rest 2008 or 2008 R2. I might get one 2012 upgrade done this year.

    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

    September 26, 2012 at 1:28 am

    #1542241

  • RE: Tables most and least used in SQL Server

    On 2008, use sys.dm_sql_referenced_entities and sys.dm_sql_referencing_entities. They're a hell of a lot more reliable that sysdepends.

    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

    September 26, 2012 at 1:24 am

    #1542238

  • RE: SQL Disk to Memory

    SQLSACT (9/25/2012)

    So if a query is submitted to SQL and the pages need to be brought into memory from disk and there is not enough memory to accomodate those pages,...

    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

    September 26, 2012 at 1:21 am

    #1542237

  • RE: SQL Disk to Memory

    Perry Whittle (9/25/2012)

    to TempDB

    The buffer pool never spills to TempDB.

    If pages are read in from disk for a table and there's not space in the buffer pool, other pages will...

    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

    September 26, 2012 at 1:16 am

    #1542234

  • RE: user_seeks Vs user_scan

    User_seeks will be the number of times a user query could use a seek on the index (execution plan shows an index seek operation), user scans is the number 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

    September 26, 2012 at 1:14 am

    #1542233

Viewing 15 posts - 16,441 through 16,455 (of 49,552 total)