Find Size Of Tables In SQL Database

When we are working with SQL Server databases, very often we will come across the problem of abnormal database size growth. In such a situation we need to get the size of tables in the database to identify the abnormal sized tables to figure out the cause of growth. _______________________________________________________________________________________________________________________ Here we will go through some of the easiest methods to get the size of all the tables in a database. This will help you to identify the tables with abnormal size. _______________________________________________________________________________________________________________________ 1. Find Size Of Tables Using SSMS Standard Report The easiest way to find the size of all the tables in a database is to use the SQL Server Management Studio’s (SSMS) standard report called Disk Usage by Table. To access the disk usage table: _______________________________________________________________________________________________________________________ 1. Logon to SQL Management Studio _______________________________________________________________________________________________________________________ 2. In the right-click Database menu go to Reports >> Standard Reports >> Disk Usage by Tables _______________________________________________________________________________________________________________________ This standard report will give you the number of records in the table, reserved physical space in KB and it’s breakup. _______________________________________________________________________________________________________________________
_______________________________________________________________________________________________________________________

Comments

Post a Comment

Popular posts from this blog

MS Office 2013 Activation Command Line

 Microsoft Office Activation Command Line Permanently Activate Microsoft Office 2013 Without Any Software And Product Key Step 1. Open Notepad copy and paste below mention commands and save msoffice.cmd the right click msoffice.cmd and click run as administrator @echo off title Activate Microsoft Office 2013 Volume for FREE!&cls&echo ============================================================================&echo #Project: Activating Microsoft software products for FREE without software&echo ============================================================================&echo.&echo #Supported products:&echo - Microsoft Office 2013 Standard Volume&echo - Microsoft Office 2013 Professional Plus Volume&echo.&echo.&(if exist "%ProgramFiles%\Microsoft Office\Office15\ospp.vbs" cd /d "%ProgramFiles%\Microsoft Office\Office15")&(if exist "%ProgramFiles(x86)%\Microsoft Office\Office15\ospp.vbs" cd /d "%ProgramFiles...
Read more

Matrix Cosec - IN and OUT Events is there but Attendance is not calculate how to rectify?

Image
1).            If employee Events is there but attendance report not showing the event. How to rectify ? Ans:      option 1. Login to Cosec Software and Click Users > User List > Search the User > Click Edit > Select General > Check the Joining Date (If Joining Date greater than current working days Attendance Report not show. After Joining date only attendance report will show)             Option 2. . Login to Cosec Software and Click Users > User List > Search the User > Click Edit > Select T&A > Check Enable Attendance Calculation (If uncheck Enable Attendance Calculation Attendance will not marked the user)             Option 3. Login to Cosec Software and Click Users > User List > Search the User > Click Edit > Select Devices> Uncheck Restrict Atte...
Read more

How to Change Edit 200 Rows and Select Top 1000 Rows Default Value in SQL Server Management Studio

Image
How to Change Edit 200 Rows and Select Top 1000 Rows Default Value in SQL Server Management Studio 1. Login to SQL Server Manatement Studio 2. Go to Tools Menu and Options 4. To make the necessary changes within the Options Dialog box, Expand SQL Server Object Explorer -> Commands. 5. Specify the new value for Value for Edit Top Rows Command and Specify the Value for Select Top Rows Command. In the below example we have set the value as 50 for both options 6. Finally to save the changes click OK to save the changes to SSMS configuration. 7. Once you have made the above mentioned changes right click the table to see the changes as shown in the snippet below
Read more