seen from United States
seen from United States
seen from Australia
seen from United States
seen from Türkiye
seen from United States
seen from United States
seen from Germany
seen from United States
seen from Türkiye
seen from United States
seen from United States
seen from Guatemala
seen from Türkiye
seen from Luxembourg
seen from Malaysia
seen from United States
seen from United States
seen from United States
seen from United States
SQL Server – Internals of sp_spaceused
This article is an effort to dissect the output of the sp_spaceused stored procedure. Introduction Understanding the database usage internals and the growth trends play a vital role in the defining the right sizing of the database. sp_spaceused is probably an administrator’s most widely-executed system stored procedure to find the disk space used by a database. This helps get a quick glimpse of…
View On WordPress
Capturing Database(s) and Table Usage stats – sp_spaceused simulation using DMVs
For more Information refer Technet Article Introduction
sp_spaceused is one of the system stored procedure used frequently by many DBA’s that reveals amount of space used by database/tables. This procedure can be executed either by passing parameters or no parameters. The objective of this stored procedure is to measure the amount of space consumed by database or tables.
Objective
This article…
View On WordPress
SQL - List All Tables, Space Usage Info & Other Details
SQL – List All Tables, Space Usage Info & Other Details
One of the OP requested in the forum to find all table details of any database. The details such as Number of Rows,table size, index size etc:-. Even I frequently writing queries to list all such details.
I’ve used SQLCMD mode to connect to the remote server and database to fetch all the required result.
SQLCMD can be enabled in Query Editor.
Go to SSMS Menu -> Query ->Select SQLCMD.
Download…
View On WordPress
How to find space used by a table in SQL Server
How to find space used by a table in SQL Server
Use ‘sp_spaceused’ to find space used by table in SQL Server (SQL Server 2005 and newer).
Following is a syntax for that.
sp_spaceused N’YourTableName’
Note: Permission to execute sp_spaceused is granted to the public role.
Displaying disk space information about a table
The following example reports disk space information for the Vendor table and its indexes.
USE AdventureWorks2012; GO…
View On WordPress
