Getting data and log size of all databases
Hi guys.
The procedure bellow get the data and log size of all databases in current instance.
CREATE PROCEDURE dbo.uspDatabaseSize
AS
declare...
2011-12-03
1,900 reads
Hi guys.
The procedure bellow get the data and log size of all databases in current instance.
CREATE PROCEDURE dbo.uspDatabaseSize
AS
declare...
2011-12-03
1,900 reads
Hi people, following a script that deletes all tables in a database. Enjoy.
SET NOCOUNT ON;
DECLARE @Tabela TABLE
( Seq INT,...
2010-12-27
2,082 reads
The Profiler is a powerful tool available to the dba, but it can also be very useful for system developers....
2010-12-18
756 reads
Occasionally I need to see what the date of last restart of SQL Server. The old method isto check the...
2010-12-17
1,062 reads
Sometimes when we need to do some maintenance on a SQL server, you need to verify which users are connected...
2010-12-16
1,416 reads
Some times is necessary retrieve a list of members of the roles of a database. Doing this is simple, using...
2010-08-12
2,693 reads
The script below is a simple and quick way to find out the last backup performed successfully to the databases...
2010-07-14
748 reads
By DataOnWheels
Over the past couple of months, I have started losing my ability to talk...
By Steve Jones
apolytus– n. the moment you realize you are changing as a person, finally outgrowing...
If you've ever wrestled with complex SQL code, you know the drill. Hours spent...
I have a job running each night starting at 4:30AM and usually finishing at...
hi guys, I have a partitioned table AM_ITM_INSTNC_MSS and I want to get...
This is one I haven't seen before. I'm trying to drop a database user...
Our environment runs using SQL Server Standard. We are implementing Availability groups. Our database has been experiencing high read volumes, so I want to let the application read the Synchronized Secondary replica, as I read that HADR does this. Can we implement this?
See possible answers