Tag: databases

To get the size of all tables using MSSQL you can use the snippet below. Sample MSSQL

To list all Databases in MSSQL you can use the following snippet. Sample MSSQL SQL Server Version newer than MS SQL 2000 also support these StoredProcedures. or

To list all views in database in MSSQL you can use the following snippet. Sample MSSQL

To show all backups of a Database in MSSQL you can use the following snippet. This snippet will show you every path even if the backup does not exist anymore.…

To list last backup date of all databases in MSSQL you can use the following snippet. Sample MSSQL

To list all users in MSSQL you can use the following snippet.

To list all databases in MSSQL you can use the following snippet. Sample 1 MSSQL Sample 2 MSSQL

To get the size of all databases in mysql you can use the following query. Sample MySql