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 Attendance (If your Checked the Restrict Attendance User will allow the door access but attendance not marked) For Option: 1 For Option: 2 For Opti
Read more

Cisco WebEx Room Kit Series Configuration - Step by Step Simple method

CISCO   WebEx   Room   Kit   Series. -  Configuration - Step by Step Thereafter follow the steps :   Basic Steps Using Touch 10 for Device : Welcome Screen -> Change Language -> English (United Kingdom) -> Back Welcome Screen -> Start No Network Connection Screen -> Next Ethernet Settings -> Disable DHCP & Enter All Static IP Address Details -> Next Select “Other Settings” Select Advanced Set-Up -> Next Change Time Zone -> Southern Asia -> Colombo, New Delhi -> 12 Hours / 24 Hours -> Next Skip Step related to using Device as External USB Camera -> Next Adjust Camera View (Manual) -> Next Sound Check (Auto) -> Next Set-Up Complete Screen -> Next “Welcome” Screen appears on Touch 10.   Web-Login using IP Address of Device : Setup -> Configuration -> System Unit -> Name -> Define Name as per Customer for Identification. Setup -> Configuration -> Conference -> Default Call Protocol -> H.323 -> Save Setup -> C
Read more