(505) 570-5505 info@logicalalternative.org
  • Facebook
  • LinkedIn
  • Facebook
  • LinkedIn
Logical Alternative, Inc.
  • Home
  • About
    • Who We Are
    • What We Do
    • Our Philosophy
    • Featured Work
    • Testimonials
    • Our Design Process
  • Projects
    • GLAAD Website
    • Out & Equal Global Hub
  • Services
    • Website Design Packages
    • Digital Marketing Packages
    • Google Ad Grants for Nonprofits
    • Hosting Packages
      • What Makes Us Different?
  • Blog
  • Resources
    • Support Requests
    • Frequently Asked Questions
    • Client Questionnaire
    • Nonprofit Grant Application
  • Contact
Select Page

Query to find number Rows, Columns, ByteSize for each table in the current database

by Evelyn Dickinson | Nov 6, 2014 | Tech Snippets

USE DatabaseNameGOCREATE TABLE #temp (table_name sysname ,row_count INT,reserved_size VARCHAR(50),data_size VARCHAR(50),index_size VARCHAR(50),unused_size VARCHAR(50))SET NOCOUNT ONINSERT #tempEXEC sp_msforeachtable ‘sp_spaceused ”?”’SELECT...

Recent Posts

  • Page Titles vs. Page Headings—Is There a Difference?
  • How to Choose a WordPress Plugin
  • How to transfer a domain away from Network Solutions
  • How to set up Gravity Forms with Discount Codes
  • Helpful WordPress Tips and Tricks

Categories

  • Accessibility
  • Design
  • Development
  • Tech Snippets
  • Wordpress
  • Wordpress beginners

astra header astra menu avada aws crm integration cta Custom post types divi dnn Document Library Pro dotnetnuke ebs snapshots ec2/vpc instances eCommerce solutions form integration Gravity Forms Gravity Perks LAMP lexicata mac os mamp Ninja Forms slider revolution social media images SQL queries Square Payments ssl website integration

Privacy Policy | Copyright © 2025 Logical Alternative