SQL Server Performance

How to effectively search the previous topics?

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

  1. xiebo2010cx 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!
  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.



  3. xiebo2010cx Member

    Thanks, Luis
  4. xiebo2010cx 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.
  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.



  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
  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
  8. FrankKalis Moderator

  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
  10. xiebo2010cx Member

    Thank you all, will try google, and try this search engine with more accurate search string
  11. xiebo2010cx Member

    finding an effective way to search previous posts can greatly reduce redundant topics here
  12. FrankKalis Moderator

  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
  14. xiebo2010cx 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
  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
  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>
  17. xiebo2010cx Member

    Thanks all again
  18. FrankKalis Moderator

  19. Madhivanan Moderator

  20. FrankKalis Moderator

  21. Madhivanan Moderator

  22. satya Moderator

  23. FrankKalis Moderator

  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
  25. xiebo2010cx Member

    Thank you all again, searching is good way for new learner
    good search engine is good way for good seaching.
  26. xiebo2010cx Member

    I really like this forum, especially article section, while found just a little articles, and etc can be applied to SQL Server 2005.

Share This Page