Getting data and log size of all databases

• by adeilsonrbrito

• SQLServerCentral.com

Hi guys.
The procedure bellow get the data and log size of all databases in current instance.
 
CREATE PROCEDURE dbo.uspDatabaseSize
AS
declare...

★ ★ ★ ★ ★ ★ ★ ★ ★ ★

Log in or register to rate

2011-12-03

1,701 reads

• Discuss

Script Drop all tables of a database

• by adeilsonrbrito

• SQLServerCentral.com

Hi people, following a script that deletes all tables in a database. Enjoy.
 
SET NOCOUNT ON;
DECLARE @Tabela TABLE
(    Seq INT,...

★ ★ ★ ★ ★ ★ ★ ★ ★ ★

Log in or register to rate

2010-12-27

2,069 reads

Grant permission to the profile

• by adeilsonrbrito

• SQLServerCentral.com

The Profiler is a powerful tool available to the dba, but it can also be very useful for system developers....

★ ★ ★ ★ ★ ★ ★ ★ ★ ★

Log in or register to rate

2010-12-18

743 reads

Last restart of SQL Server

• by adeilsonrbrito

• SQLServerCentral.com

Occasionally I need to see what the date of last restart of SQL Server. The old method isto check the...

★ ★ ★ ★ ★ ★ ★ ★ ★ ★

Log in or register to rate

2010-12-17

1,021 reads

Number of sessions per database

• by adeilsonrbrito

• SQLServerCentral.com

Sometimes when we need to do some maintenance on a SQL server, you need to verify which users are connected...

★ ★ ★ ★ ★ ★ ★ ★ ★ ★

Log in or register to rate

2010-12-16

1,289 reads

Using DMV to identify members roles

• by adeilsonrbrito

• SQLServerCentral.com

Some times is necessary retrieve a list of members of the roles of a database. Doing this is simple, using...

★ ★ ★ ★ ★ ★ ★ ★ ★ ★

Log in or register to rate

2010-08-12

2,648 reads

Retrieving last backups of the databases

• by adeilsonrbrito

• SQLServerCentral.com

The script below is a simple and quick way to find out the last backup performed successfully to the databases...

★ ★ ★ ★ ★ ★ ★ ★ ★ ★

Log in or register to rate

2010-07-14

742 reads