This month's discount Comprehensive Database Performance Health Check · Testimonials
SQLAuthority with Pinal Dave
Home
  • Consulting
    • Health Check
  • Free Videos
  • All Articles
    • AI
    • SQL Performance
    • SQL Tips and Tricks
    • Interview Questions and Answers
    • SQL Puzzle
    • SQL Video
    • SQLAuthority News
    • Personal
  • Books
  • Consulting
Set ROWCOUNT Option in SQL Server Management Studio.

SQL SERVER – Find Row Count in Table – Find Largest Table in Database – T-SQL

January 13, 2009
Pinal Dave
SQL Tips and Tricks
SQL Index, SQL Scripts, SQL System Table, SQL Utility

A quick script using sys.dm_db_partition_stats that lists the row count of every table and shows the largest table in database right at the top.

Read More
  • Books
  • Testimonials
  • Privacy Policy

© 2006 – 2026 All rights reserved. pinal @ SQLAuthority.com