Forum Replies Created

Viewing 15 posts - 14,311 through 14,325 (of 49,552 total)

  • RE: Poor Performing SQL Server Queries

    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

    February 12, 2013 at 2:45 am

    #1586888

  • RE: Ideal table partition size per partition

    Again, partitioning is not about performance. You define the ranges based on your business requirements for loading and removing data, that will guide your partition scheme and function. There's 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

    February 12, 2013 at 2:20 am

    #1586883

  • RE: Backward compatibility confusions

    Benki Chendu (2/12/2013)

    For example, we have a database created in SQL Server 2012. We have an application which is configured to work with this database and it encounters some issues....

    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

    February 12, 2013 at 1:35 am

    #1586868

  • RE: Index fragmentation

    Let me guess, tiny table, 2 or 4 pages in size.

    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

    February 12, 2013 at 1:21 am

    #1586866

  • RE: Database in Recovery mode from last 7 days.

    My previous advice stands. If no work is being done (and since you didn't post the recovery messages I can't tell), restart SQL. Otherwise wait. Or open a case 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

    February 12, 2013 at 1:20 am

    #1586865

  • RE: select statement is too slow

    Please post table definitions, index definitions and execution plan, as per http://www.sqlservercentral.com/articles/SQLServerCentral/66909/

    Is the distinct really necessary?

    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

    February 12, 2013 at 12:49 am

    #1586855

  • RE: identity order is not in order

    Hollyz (2/11/2013)

    One would think when you would do a regular insert into a table, the rows would come in the order of the identity field.

    Table are unordered sets of rows....

    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

    February 12, 2013 at 12:43 am

    #1586854

  • RE: Ideal table partition size per partition

    Partitioning is not about performance. It's mostly about data management, fast loads, fast removal of data, compression of different partitions, index rebuilds at the partition level.

    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

    February 12, 2013 at 12:39 am

    #1586853

  • RE: Running "DBCC FLUSHPROCINDB" as part of maintenance plan?

    MyDoggieJessie (2/11/2013)

    Regardless, there's little good reason to have that as part of a maintenance plan. If the maint plan rebuilds indexes or updates stats, it'll invalidate the plans that depend...

    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

    February 12, 2013 at 12:28 am

    #1586851

  • RE: Running "DBCC FLUSHPROCINDB" as part of maintenance plan?

    DVSQL (2/11/2013)

    GilaMonster (2/11/2013)

    The plan cache is part of the allocated SQL memory, with 26 GB of allocated memory it'll probably max out at somewhere around 5-6GB, I forget the exact...

    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

    February 12, 2013 at 12:22 am

    #1586850

  • RE: Read Committed Snapshot Isolation

    They're all data anomalies as far as I know, and the 3 that define the ANSI standards for isolation levels have specific names and meanings, the isolation levels are defined...

    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

    February 12, 2013 at 12:21 am

    #1586849

  • RE: Running "DBCC FLUSHPROCINDB" as part of maintenance plan?

    The plan cache is part of the allocated SQL memory, with 26 GB of allocated memory it'll probably max out at somewhere around 5-6GB, I forget the exact formula.

    Regardless, there's...

    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

    February 11, 2013 at 3:28 pm

    #1586762

  • RE: missing index already exists

    Marius.D (2/11/2013)

    So that means if column C is sorted in the wrong order, it won't be used by that one query?

    No, the sort order is mostly important when you're indexing...

    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

    February 11, 2013 at 10:37 am

    #1586675

  • RE: assertions

    Well, I do hope some future employer doesn't run across this 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

    February 11, 2013 at 8:44 am

    #1586617

  • RE: Read Committed Snapshot Isolation

    Vedran Kesegic (2/11/2013)

    So, it might happen that your statement starts reading a table, and after that other transaction starts and commits a row your query didn't reach yet. Your query...

    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

    February 11, 2013 at 8:39 am

    #1586613

Viewing 15 posts - 14,311 through 14,325 (of 49,552 total)