craigtp
/ LargestDBs
Last active
November 16, 2023 15:41
List the largest databases on a SQL Server instance
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| SELECT DB_NAME(database_id) AS DatabaseName, | |
| Name AS Logical_Name, | |
| Physical_Name, (size*8)/1024 SizeMB | |
| FROM sys.master_files | |
| ORDER BY SizeMB DESC |
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| # The following command works for downloading when using Git for Windows: | |
| # curl -LOf http://gist.githubusercontent.com/kmorcinek/2710267/raw/.gitignore | |
| # | |
| # Download this file using PowerShell v3 under Windows with the following comand: | |
| # Invoke-WebRequest https://gist.githubusercontent.com/kmorcinek/2710267/raw/ -OutFile .gitignore | |
| # | |
| # or wget: | |
| # wget --no-check-certificate http://gist.githubusercontent.com/kmorcinek/2710267/raw/.gitignore | |
| # User-specific files |