SQL Server Performance

SQL 2005 NO_BROWSETABLE only with cursors?

Discussion in 'SQL Server 2005 T-SQL Performance Tuning' started by sql_machine, Nov 30, 2005.

  1. sql_machine New Member

    Hi all,

    I'm trying to understand if the "set no_browsetable on" applies only to cursors. As far as I can see, this is done when you don't want to keep typing "FOR BROWSE" for each of your tables being scanned by a cursor.

    Is this all it's used for? I just want to understand the general use of this, nothing detailed.

    Thanks
  2. satya Moderator

  3. BikeBoy New Member

    Satya, thanks for the quick responce,

    I read the articles, but they discuss the limitations of the FOR BROWSE and NO_BROWSETABLE statements, not what the statements are actually used for. I think they are used only for application using the sql cursor to select from the database, is that correct?
    I've never used those, just curious.
  4. Luis Martin Moderator

    Should be moved to 2005 Forums.


    Luis Martin
    Moderator
    SQL-Server-Performance.com

    One of the symptoms of an approaching nervous breakdown is the belief that one's work is terribly important
    Bertrand Russell


    All postings are provided “AS IS” with no warranties for accuracy.



  5. Adriaan New Member

    You mention 2005 in the thread title ...
  6. FrankKalis Moderator

    Look, a miracle happened to the forum category. [<img src='/community/emoticons/emotion-1.gif' alt=':)' />]<br /><br />--<br />Frank Kalis<br />Moderator<br />Microsoft SQL Server MVP<br />Webmaster:<a target="_blank" href=http://www.insidesql.de>http://www.insidesql.de</a>
  7. satya Moderator

    [<img src='/community/emoticons/emotion-1.gif' alt=':)' />] 1 and half years old thread, whats happening here!<br /><br /><b>Satya SKJ</b><br />Microsoft SQL Server MVP<br />Writer, Contributing Editor & Moderator<br /<a target="_blank" href=http://www.SQL-Server-Performance.Com>http://www.SQL-Server-Performance.Com</a><br /><center><font color="teal"><font size="1">This posting is provided AS IS with no rights for the sake of <i>knowledge sharing. <hr noshade size="1">Knowledge is of two kinds. We know a subject ourselves or we know where we can find information on it.</i></font id="size1"></font id="teal"></center>
  8. Adriaan New Member

    Hm - for reasons unbeknownst to men and women alike, this thread popped up on my Active Topics. After the disappearing logins, this is a new one ... Let's hope the new forum software is up and running soon!
  9. satya Moderator

    That's because Frank has modified (moved) to relevant forums [<img src='/community/emoticons/emotion-1.gif' alt=':)' />].<br /><br /><b>Satya SKJ</b><br />Microsoft SQL Server MVP<br />Writer, Contributing Editor & Moderator<br /<a target="_blank" href=http://www.SQL-Server-Performance.Com>http://www.SQL-Server-Performance.Com</a><br /><center><font color="teal"><font size="1">This posting is provided AS IS with no rights for the sake of <i>knowledge sharing. <hr noshade size="1">Knowledge is of two kinds. We know a subject ourselves or we know where we can find information on it.</i></font id="size1"></font id="teal"></center>
  10. Adriaan New Member

    Then the miracle must be how Frank stumbled across this one. Or are you guys making preparations for the big move, behind the scenes?
  11. satya Moderator

    Big move is not yet official [<img src='/community/emoticons/emotion-1.gif' alt=':)' />], may be Frank has too much free time.<br /><br /><b>Satya SKJ</b><br />Microsoft SQL Server MVP<br />Writer, Contributing Editor & Moderator<br /<a target="_blank" href=http://www.SQL-Server-Performance.Com>http://www.SQL-Server-Performance.Com</a><br /><center><font color="teal"><font size="1">This posting is provided AS IS with no rights for the sake of <i>knowledge sharing. <hr noshade size="1">Knowledge is of two kinds. We know a subject ourselves or we know where we can find information on it.</i></font id="size1"></font id="teal"></center>
  12. FrankKalis Moderator

    Haha, I have only seen Adriaan's reply and didn't even look at the date of the original question. [<img src='/community/emoticons/emotion-1.gif' alt=':)' />]<br /><br />--<br />Frank Kalis<br />Moderator<br />Microsoft SQL Server MVP<br />Webmaster:<a target="_blank" href=http://www.insidesql.de>http://www.insidesql.de</a>

Share This Page