Forum Replies Created

Viewing 15 posts - 16,606 through 16,620 (of 49,552 total)

  • RE: Are the posted questions getting worse?

    Really tempted to go really sarcastic at this point. "Oh noooes. 2 pages displaced!"

    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 14, 2012 at 4:02 pm

    #1538201

  • RE: Using Print, will it slow down procedure?

    ScottPletcher (9/14/2012)

    The original source must stay available, so must be cached somewhere. If you add 11K of comments to 2K of code, you're wasting HUGE amounts of RAM 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

    September 14, 2012 at 3:45 pm

    #1538195

  • RE: Are the posted questions getting worse?

    SQLRNNR (9/14/2012)

    GilaMonster (9/14/2012)

    SQL Kiwi (9/14/2012)

    GilaMonster (9/14/2012)

    SQL Kiwi (9/14/2012)

    Lynn Pettis (9/14/2012)

    Hey, any comments on what is posted here?

    My first reaction was, "LOL!". Posted a more serious comment.

    Thank you, you saved...

    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 14, 2012 at 2:40 pm

    #1538160

  • RE: Are the posted questions getting worse?

    Lynn Pettis (9/14/2012)

    Nothing like having two people obviously in over their heads this week.

    Which 2 are you thinking about?

    Installing SQL 2012, dropping filegroups? Or are there more?

    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 14, 2012 at 1:43 pm

    #1538120

  • RE: Are the posted questions getting worse?

    SQL Kiwi (9/14/2012)

    GilaMonster (9/14/2012)

    SQL Kiwi (9/14/2012)

    Lynn Pettis (9/14/2012)

    Hey, any comments on what is posted here?

    My first reaction was, "LOL!". Posted a more serious comment.

    Thank you, you saved me the...

    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 14, 2012 at 1:19 pm

    #1538110

  • RE: Using Print, will it slow down procedure?

    Procedure cache = plan cache. Procedure cache is the old name from when it used to store object plans only (many versions ago), but both refer to the portion 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 14, 2012 at 1:13 pm

    #1538108

  • RE: Are the posted questions getting worse?

    Sean Lange (9/14/2012)

    Same with me on a totally different topic recently too.

    Oh good, so it's not 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

    September 14, 2012 at 12:48 pm

    #1538085

  • RE: Are the posted questions getting worse?

    SQL Kiwi (9/14/2012)

    GilaMonster (9/14/2012)

    SQL Kiwi (9/14/2012)

    Lynn Pettis (9/14/2012)

    Hey, any comments on what is posted here?

    My first reaction was, "LOL!". Posted a more serious comment.

    Thank you, you saved me the...

    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 14, 2012 at 11:20 am

    #1538048

  • RE: Are the posted questions getting worse?

    SQL Kiwi (9/14/2012)

    Lynn Pettis (9/14/2012)

    Hey, any comments on what is posted here?

    My first reaction was, "LOL!". Posted a more serious comment.

    Thank you, you saved me the trouble.

    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 14, 2012 at 10:50 am

    #1538030

  • RE: Indexes, Query plans and optimization

    Gut feel, you've run into this: http://sqlinthewild.co.za/index.php/2011/03/22/statistics-row-estimations-and-the-ascending-date-column/

    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 14, 2012 at 10:37 am

    #1538020

  • RE: simple que

    bala.a (9/14/2012)

    Literally speaking,

    a) "Select *" will return the result set , whereas "Count(*)/Count(1)" will return a scalar value and this will result in significance difference in terms of I/O

    IO,...

    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 14, 2012 at 10:31 am

    #1538019

  • RE: simple que

    harri.reddy (9/14/2012)

    it was something ,if i define global variable in sp,will it can be access in inside stored procedure

    As I mentioned above, SQL Server doesn't have global variables.

    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 14, 2012 at 10:28 am

    #1538018

  • RE: simple que

    Have a look at the execution plan.

    Also consider, how much data has to be transmitted and displayed in each case?

    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 14, 2012 at 6:44 am

    #1537782

  • RE: Are the posted questions getting worse?

    Anyone get the increasing feeling people are looking for the 'eazy button'?

    Case in point:

    "I read through those articles [on index column ordering], but I still want a formula that tells...

    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 14, 2012 at 6:18 am

    #1537767

  • RE: logical consistency-based I/O error: incorrect checksum

    Probably because the temp table that had the error was dropped before you could run checkDB.

    Still, indicates that there's something not right about the IO subsystem. Check logs, check drivers,...

    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 14, 2012 at 6:12 am

    #1537761

Viewing 15 posts - 16,606 through 16,620 (of 49,552 total)