Dba: When should sp_spaceused be used to get the size of a database, instead of querying sys.data...

Channel:
Peter Schneider
Subscribers:
4,430
Published on ● Video Link: https://www.youtube.com/watch?v=7dwLsPxh3Wo


Duration: 0:00
3 views
0

When should sp_spaceused be used to get the size of a database, instead of querying sys.database_files?
I hope you found a solution that worked for you :)
The Content is licensed under (https://meta.stackexchange.com/help/licensing) CC BY-SA.
Attention! This video does always use the same license as the source!
Thanks to all those great people for their contributions!

(dba.stackexchange.com/users/277982/j-mini)J. Mini
(dba.stackexchange.com/users/71599/dj)DJ.
A special thanks goes out to the (dba.stackexchange.com/questions/343326/when-should-sp-spaceused-be-used-to-get-the-size-of-a-database-instead-of-query)Stackexchange community

I wish you all a wonderful day! Stay safe :)
If anything is off, please write me at peter D.O.T schneider A.T ois42.de

database-size sql-server-2019 dmv disk-space sql-server



Other Videos By Peter Schneider


2024-11-25Gis: Georeference the second and the following pages of PDF in QGIS
2024-11-25Certbot and Nginx issue
2024-11-25SUMIF on two arrays from FILTER-function
2024-11-25Networkengineering: Do Extreme Switches need to have ports filled in sequence
2024-11-25How to debug iptables nat connections, when packets are forwarded but not received by the server?
2024-11-25"Firebase Messaging getToken() Error: Invalid fetch response, expected 'token' or 'Error' key" in...
2024-11-25Speeding Up Monte Carlo Simulations for Weather-Dependent Claims
2024-11-25C++ Returning a lambda's return value
2024-11-25Bitcoin: Is it possible to get bitcoin address from Jan 2010 that still has balance and never sen...
2024-11-25Is there a way to streamline naming hundreds of cells?
2024-11-23Dba: When should sp_spaceused be used to get the size of a database, instead of querying sys.data...
2024-11-22Raspberrypi: Install OS on microSD card via SSH
2024-11-22Unexpected output of callCC in Haskell
2024-11-22Tex: setbeamercolormath text introduces extra vertical space in beamer
2024-11-22Codereview: MongoDB cache decorator
2024-11-22Tex: How to put the QED symbol of a proof at the right place inside aligned?
2024-11-22Tex: Testing, if a file exists. (The point is the point.)
2024-11-22Unix: Run program only on matching lines
2024-11-22Dba: Is there any information in Query Store that can be used to find block leaders?
2024-11-22Electronics: Heating Aluminium Block with 40W Cartridges
2024-11-22Unix: Unable to get USB Serial path/connection on Ubuntu