Logical Alternative, Inc.
  • Home
  • Hosting
  • Blog
  • Contact Us
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...

AWS EBS Snapshots for Windows EC2/VPC Instances

by Evelyn Dickinson | Nov 6, 2014 | Tech Snippets

After scouring through the Amazon Web Services (AWS) management console I discovered that there is, in fact, no GUI method for scheduling elastic block store (EBS) snapshots. Snapshots are one of the great good glories of virtualization in my opinion. Being keen to...

Recent Posts

  • Adding a Front-End Upload Option to Document Library Pro
  • The Logo on My DNN Site Takes Me to a Non-Secure Version of the Home Page
  • Website Inquiry Forms to Lexicata Integration
  • Synching MAMP on Multiple Macs
  • Query to find number Rows, Columns, ByteSize for each table in the current database

Recent Comments

    Archives

    • June 2021
    • June 2018
    • July 2017
    • March 2016
    • November 2014

    Categories

    • Design
    • Development
    • Tech Snippets

    Meta

    • Log in
    • Entries feed
    • Comments feed
    • WordPress.org
    • Facebook
    • LinkedIn