Forum Replies Created

Viewing 15 posts - 15,796 through 15,810 (of 49,552 total)

  • RE: SQL2012 caching behaviour

    angel.wong 72408 (11/5/2012)

    In SQL 2012, I found out that it seems flush from memory very soon make it unable to use the cache data, results in slow to getting results.

    Could...

    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

    November 5, 2012 at 8:28 pm

    #1556275

  • RE: create table

    capnhector (11/5/2012)

    The other issue could be running over 8060 bytes for a row. its possible since a varchar(100) can take up as much as 102 bytes. SQL...

    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

    November 5, 2012 at 12:45 pm

    #1556187

  • RE: recovery model

    http://www.sqlservercentral.com/articles/Administration/75461/

    http://www.sqlservercentral.com/articles/Recovery+models/89664/

    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

    November 5, 2012 at 12:42 pm

    #1556185

  • RE: Auto Shrink In SQL Server 2008

    Don't regularly shrink your database. This is not MS Access that required a compact and shrink often. shrink is not compression. Free space in a SQL database is not harmful....

    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

    November 5, 2012 at 8:15 am

    #1556065

  • RE: duplicate backup log resore

    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

    November 4, 2012 at 5:20 pm

    #1555867

  • RE: Do people rebuild indexes if non-leaf levels exceed fragmentation threshold?

    Honestly, I probably wouldn't bother in most cases, because of the second part of what I said.

    and for SQL to be doing such large range scans of the table that...

    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

    November 4, 2012 at 11:52 am

    #1555828

  • RE: How to resolve error while attach MDF file Error (5171)

    Restore from a full database 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

    November 3, 2012 at 2:16 am

    #1555735

  • RE: How many rows in a table before using a clustered index?

    Stueyd (11/2/2012)

    I do find it hard to believe there's not a table size where it's actually beneficial not to bother (1 row even?).

    Nevertheless, it is the case. A clustered...

    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

    November 3, 2012 at 2:13 am

    #1555734

  • RE: High Memory Consumption

    Plan cache is part of the buffer pool, therefore constrained by max server memory.

    No, not a memory leak (unless you have buggy linked server drivers). Combo of thread stacks, CLR...

    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

    November 3, 2012 at 2:11 am

    #1555733

  • RE: Do i need to drop temp tables ?

    Temp tables are automatically dropped as soon as they go out of scope (the proc that they were created in completes) or the connection that created them closes.

    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

    November 3, 2012 at 2:09 am

    #1555732

  • RE: T-SQL to call the SQL Parse "function"

    Not even with SET NOEXEC 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

    November 2, 2012 at 7:18 am

    #1555455

  • RE: How many rows in a table before using a clustered index?

    Stewart "Arturius" Campbell (11/2/2012)

    Clustered indexes are best suited for those columns most frequently used in range-based searches.

    I would tend to disagree with that, but that's just me.

    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

    November 2, 2012 at 7:15 am

    #1555453

  • RE: DBCC Slower on new production server

    Check your IO throughput.

    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

    November 2, 2012 at 7:13 am

    #1555451

  • RE: CPU High utilization -urgent help please

    qew420 (11/2/2012)

    Still working on this issue

    I changed the min and max but no effect

    Errr... please don't tell me you set min and max to the same value. Min isn't...

    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

    November 2, 2012 at 7:11 am

    #1555450

  • RE: How many rows in a table before using a clustered index?

    Stueyd (11/2/2012)

    What's the tipping point where there's so few rows it's not worth it?

    0.

    Every table should have a clustered index unless you have a good reason otherwise (low row count...

    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

    November 2, 2012 at 7:07 am

    #1555447

Viewing 15 posts - 15,796 through 15,810 (of 49,552 total)