You are currently browsing comments. If you would like to return to the full story, you can read the full entry here: “List All Tables in a Database”.
Random MVP RSS Feeds- [Aaron Bertrand] How SQL Saturday could be better: I've been to a lot of SQL Saturdays. They are great events to... http://t.co/bLe97UD5
- [Aaron Bertrand] SQL Server 2008 R2 Service Pack 2 CTP is available: You can download the service pack 2 CTP fro... http://t.co/kblQTr2y
- [SQLTeam] Why to avoid SELECT * from tables in your Views: -- clean up any messes left over from before: if OB... http://t.co/GIDxRhEY
- [Kalen Delaney] Did You Know? Turning Off Locking: Back when the lock manager was rewritten for SQL Server 7, an... http://t.co/lzEEpC11
- [Aaron Bertrand] A cautionary tale about grandfathering CAL licenses in SQL Server 2012 Enterprise: I've tried t... http://t.co/1Uoru0DD
- [Kalen Delaney] Geek City: Build a Big Table with a Columnstore Index: I was looking all over to find a big tabl... http://t.co/kzBZMTZu
- [SQLTeam] ClearTrace Performance on 170GB of Trace Files: I’ve always worked to make ClearTrace perform well. T... http://t.co/R24uwgOl
- [SQLTeam] ClearTrace Beta for SQL Server 2012: I have a beta version of ClearTrace that supports 2012. You can ... http://t.co/IrXM7ZFb
- User Defined Functions and Performance - There is definitely a lack of... http://t.co/YdHjOTuH #fb
- [Aaron Bertrand] Seacoast SQL Users Group : What's New in SQL Server 2012: Tonight I presented my "What's New in... http://t.co/wL7bT7qg
Connect
how see all tables of database in sql server 2005
Your last method with row count did not work for me. Your query over estimated the row count. True count is 78,120 and your query stated 312,480.
Hey Mac,
The fact that the number is wrong, most likely means your stats are out of wack.
http://sqlserverplanet.com/query-optimizer/using-dbcc-updateusage/
Hi Mac,
Try changing SUM(sp.rows) to MAX(sp.rows).
This seems to be working for me so far…