HomeНаука и техникаRelated VideosMore From: TechBrothersIT

How to Get Record Count for All the Tables in SQL Server Database - SQL Server Tutorial

21 ratings | 11812 views
TSQL Video Scenario How to get Table Names with Record Count in SQL Server Database? Solution: Consider our company is working on some audit process and they want to log the table names with record count in Audit table during different hours of the day OR we are planning for storage and want to know which table has the most records and plan the storage accordingly. The below query will return us all the tables from SQL Server Database with record count. We will be using System tables sysindexes and sys.tables to get our record count with table names. Blog post link with scripts http://sqlage.blogspot.com/2015/02/how-to-get-table-names-with-record.html
Html code for embedding videos on your blog
Text Comments (3)
Thank You !!
krismaly (3 years ago)
Appreciate for taking pain in creating video on sysindexes, sys.tables and explaining important points to remember. Thanks
krismaly (3 years ago)
I enjoyed this video. You guys know the topic and I would appreciate if you could continue to publish such videos help the world. Thanks for educating the community and appreciate your volunteer-ship. I want to suggest you guys to watch structured way of teaching from below videos. It's only a suggestion don't take it other senses. I love your tech knowledge https://www.youtube.com/watch?v=ZNObiptSMSI&list=PL08903FB7ACA1C2FB https://www.youtube.com/watch?v=3cPq9FXk-RA&list=PLNIs-AWhQzcmPg_uV2BZi_KRG4LKs6cRs https://www.youtube.com/watch?v=kTPJBAtv29k&list=PL7A29088C98E92D5F When you make a video let me know I would be happy to write review. Thanks a lot

Would you like to comment?

Join YouTube for a free account, or sign in if you are already a member.