SQL Server Performance

How to effectively search the previous topics?

Discussion in 'Please Tell Us What You Think' started by xiebo2010cx, Jun 8, 2006.

Page 1 of 2

  1. xiebo2010cx New Member

    Anyone here give me some good hints to effectively search the old topics posted here before?
    Like, I want to search the topic "how to find the count of user tables"? I remembered this topic was here before, but I could not be able to find it.


    Thanks!
    xiebo2010cx, Jun 8, 2006
    #2

  2. Luis Martin Moderator

    Use few words.
    "Count user tables" with search for all words filter and (if you remember) said 30 days ago.

    Luis Martin
    Moderator
    SQL-Server-Performance.com

    All in Love is Fair
    Stevie Wonder


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



    Luis Martin, Jun 8, 2006
    #2

  3. xiebo2010cx New Member

    Thanks, Luis
    xiebo2010cx, Jun 8, 2006
    #2

  4. xiebo2010cx New Member

    I remembered I read one topic "script to calculate the number of user tables in one database" half month ago, while now I still could not find it.
    xiebo2010cx, Jun 8, 2006
    #2

  5. Luis Martin Moderator

    I don't think there is any script.

    Try

    Use yourdatabase
    select SO.Name as Table
    from sysobjects as SO where xtype = 'U'
    order by SO.Name



    Luis Martin
    Moderator
    SQL-Server-Performance.com

    All in Love is Fair
    Stevie Wonder


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



    Luis Martin, Jun 8, 2006
    #2

  6. FrankKalis Moderator

    Usually it helps when you know in which forum it was posted and who posted it. In your case if I understand this correct, I would search for "sp_MSForeachTable" or do a straight


    exec sp_msforeachtable "print '?' select count(*) from ?"

    However if you want to find out the number of user tables in a db, what about


    SELECT COUNT(*)
    FROM INFORMATION_SCHEMA.TABLES
    WHERE TABLE_TYPE = 'BASE TABLE'


    --
    Frank Kalis
    Microsoft SQL Server MVP
    http://www.insidesql.de
    Heute schon gebloggt?http://www.insidesql.de/blogs
    FrankKalis, Jun 8, 2006
    #2

  7. Madhivanan Moderator

    quote:Originally posted by xiebo2010cx

    Anyone here give me some good hints to effectively search the old topics posted here before?
    Like, I want to search the topic "how to find the count of user tables"? I remembered this topic was here before, but I could not be able to find it.


    Thanks!
    One of the ways is to use google

    "Your Search String" + SQL-Server-performance.com

    Madhivanan

    Failing to plan is Planning to fail
    Madhivanan, Jun 9, 2006
    #2

  8. FrankKalis Moderator

    FrankKalis, Jun 9, 2006
    #2

  9. Madhivanan Moderator

    quote:Originally posted by FrankKalis

    Will you find forum topics that way?

    --
    Frank Kalis
    Microsoft SQL Server MVP
    http://www.insidesql.de
    Heute schon gebloggt?http://www.insidesql.de/blogs
    Yes I think that will be best way as you wont get any time out error when searching here itself

    Eg. To search for "Parameter sniffing"
    Googlehttp://www.google.co.in/search?hl=en&q=parameter sniffing + sql-server-performance.com&meta=
    Search from SSPhttp://www.sql-server-performance.com/forum/search.asp?mode=DoIt


    Madhivanan

    Failing to plan is Planning to fail
    Madhivanan, Jun 9, 2006
    #2

  10. xiebo2010cx New Member

    Thank you all, will try google, and try this search engine with more accurate search string
    xiebo2010cx, Jun 9, 2006
    #2

  11. xiebo2010cx New Member

    finding an effective way to search previous posts can greatly reduce redundant topics here
    xiebo2010cx, Jun 9, 2006
    #2

  12. FrankKalis Moderator

    FrankKalis, Jun 9, 2006
    #2

  13. Madhivanan Moderator

    <blockquote id="quote"><font size="1" face="Verdana, Arial, Helvetica" id="quote">quote:<hr height="1" noshade id="quote"><i>Originally posted by FrankKalis</i><br /><br />No, I really don't think so. Most people don't use the search pages, no matter how good they are.<br /><br />--<br />Frank Kalis<br />Microsoft SQL Server MVP<br /<a target="_blank" href=http://www.insidesql.de>http://www.insidesql.de</a><br />Heute schon gebloggt?<a target="_blank" href=http://www.insidesql.de/blogs>http://www.insidesql.de/blogs</a><br /><hr height="1" noshade id="quote"></font id="quote"></blockquote id="quote"><br />Yes but google will give us the related links quickly [<img src='/community/emoticons/emotion-1.gif' alt=':)' />]<br /><br />Madhivanan<br /><br />Failing to plan is Planning to fail
    Madhivanan, Jun 9, 2006
    #2

  14. xiebo2010cx New Member

    it is a good idea to encourage people to search previous pages, I did this and got immediate and excellent answers for my questions.

    While I don't think this search engine is excellent, torturing me when I tried to find the specific posts
    xiebo2010cx, Jun 9, 2006
    #2

  15. Madhivanan Moderator

    &gt;&gt;While I don't think this search engine is excellent, torturing me when I tried to find the specific posts<br /><br />Then follow what I suggested [<img src='/community/emoticons/emotion-1.gif' alt=':)' />]<br /><br />Madhivanan<br /><br />Failing to plan is Planning to fail
    Madhivanan, Jun 9, 2006
    #2

  16. satya Moderator

    THe search engine associated with Snitz is not as good as Google and I believe a suggestion to Snitz to include Google search will do a better job.<br /><br />At the end you need specific words to get to the required post and that will not work as always expected, sometimes patience is virtue [<img src='/community/emoticons/emotion-1.gif' alt=':)' />].<br /><br /><hr noshade size="1"><b>Satya SKJ</b><br />Microsoft SQL Server MVP<br />Contributing Editor & Forums 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.</i></font id="size1"></font id="teal"></center>
    satya, Jun 9, 2006
    #2

  17. xiebo2010cx New Member

    Thanks all again
    xiebo2010cx, Jun 9, 2006
    #2

  18. FrankKalis Moderator

    FrankKalis, Jun 9, 2006
    #2

  19. Madhivanan Moderator

    Madhivanan, Jun 10, 2006
    #2

  20. FrankKalis Moderator

    FrankKalis, Jun 13, 2006
    #2

  21. Madhivanan Moderator

    Madhivanan, Jun 14, 2006
    #2

  22. satya Moderator

    satya, Jun 14, 2006
    #2

  23. FrankKalis Moderator

    FrankKalis, Jun 14, 2006
    #2

  24. Madhivanan Moderator

    <blockquote id="quote"><font size="1" face="Verdana, Arial, Helvetica" id="quote">quote:<hr height="1" noshade id="quote"><i>Originally posted by FrankKalis</i><br /><br />I wonder if Brad has restricted the Advanced Search not to include forum postings?<br /><br />--<br />Frank Kalis<br />Microsoft SQL Server MVP<br /<a target="_blank" href=http://www.insidesql.de>http://www.insidesql.de</a><br />Heute schon gebloggt?<a target="_blank" href=http://www.insidesql.de/blogs>http://www.insidesql.de/blogs</a><br /><hr height="1" noshade id="quote"></font id="quote"></blockquote id="quote"><br />Yes I think so [<img src='/community/emoticons/emotion-1.gif' alt=':)' />]<br /><br />Madhivanan<br /><br />Failing to plan is Planning to fail
    Madhivanan, Jun 14, 2006
    #2

  25. xiebo2010cx New Member

    Thank you all again, searching is good way for new learner
    good search engine is good way for good seaching.
    xiebo2010cx, Jun 14, 2006
    #2

  26. xiebo2010cx New Member

    I really like this forum, especially article section, while found just a little articles, and etc can be applied to SQL Server 2005.
    xiebo2010cx, Jun 14, 2006
    #2
Page 1 of 2

Share This Page