Forum Replies Created

Viewing 15 posts - 15,436 through 15,450 (of 49,552 total)

  • RE: Unconsistent consistency errors...

    Machine getting frequently rebooted?

    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 29, 2012 at 3:18 am

    #1563631

  • RE: Too many statistics

    MOC Ewez (11/29/2012)

    So having so many statistics on a table with (36 cols) is normal or at least not unusual?

    Depends. 🙂 If there are duplicate stats (between the dta and...

    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 29, 2012 at 3:17 am

    #1563630

  • RE: Low instance memory.....or is it.

    RESOURCE_MEMPHYSICAL_LOW indicates external memory pressure, the OS is short of memory.

    The counters you mention indicate that there is no internal memory pressure, that SQL has enough memory.

    How much memory 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 29, 2012 at 2:24 am

    #1563611

  • RE: Unable to alter column in table

    There's a default dependant on the column. Drop that first.

    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 29, 2012 at 1:40 am

    #1563601

  • RE: Adding "group by" or even "INTO #tmpTable" completely change Execution Plan (for the worse)

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

    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 29, 2012 at 1:40 am

    #1563600

  • RE: Unconsistent consistency errors...

    NTesla (11/29/2012)

    The server is custom built and is not using those powerfull raid boards with battery and all that stuff.

    Yeah, I got that. In that case make sure 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 29, 2012 at 1:36 am

    #1563598

  • RE: Unconsistent consistency errors...

    NTesla (11/29/2012)

    GilaMonster (11/29/2012)

    Are you doing index rebuilds right after the consistency checks?

    These results were obtained running the command right from a query window.

    I do have a scheduled maintenance plan (runs...

    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 29, 2012 at 1:14 am

    #1563592

  • RE: Buffer Pool Dirty/Clean Pages

    There's a reason people have been referring you to Kalen's internals book on a regular basis....

    http://sqlskills.com/blogs/paul/post/Inside-the-Storage-Engine-Anatomy-of-a-page.aspx

    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 29, 2012 at 1:04 am

    #1563588

  • RE: Unconsistent consistency errors...

    Are you doing index rebuilds right after the consistency checks?

    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 29, 2012 at 12:33 am

    #1563579

  • RE: Buffer Pool Dirty/Clean Pages

    A page is just an 8kb chunk of data. Given that, what exactly is the difference between a page (an 8kb chunk of data) and the contents of the page...

    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 29, 2012 at 12:33 am

    #1563578

  • RE: Buffer Pool Dirty/Clean Pages

    And the difference between those two 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

    November 29, 2012 at 12:03 am

    #1563571

  • RE: query

    Distinct is not a function. It does not take parameters. It does not give you distinct of a column that you put brackets around. It gets you distinct rows.

    For better...

    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 29, 2012 at 12:00 am

    #1563569

  • RE: Using SUM(1) to count Rows (vs Count(1))

    MyDoggieJessie (11/28/2012)

    I was referring to sysindexes, it's eventually being replaced by sys.indexes. Or am I completely confused? :ermm:

    sysindexes is indeed deprecated. It's already been replaced with sys.indexes (7...

    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 28, 2012 at 11:52 pm

    #1563566

  • RE: Unconsistent consistency errors...

    No, it won't be the OS drive if the database files aren't on it.

    Errors please.

    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 28, 2012 at 11:50 pm

    #1563565

  • RE: Buffer Pool Dirty/Clean Pages

    SQLSACT (11/28/2012)

    This seems like the page is not written back to disk, but rather the page contents that have changed are written to the corresponding pages on disk.

    And what...

    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 28, 2012 at 11:48 pm

    #1563564

Viewing 15 posts - 15,436 through 15,450 (of 49,552 total)