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
Today I was having a nice discussion with some colleagues about Fabric and pricing/licensing...
By Steve Jones
As I’ve been working with SQL Saturday and managing changes to events, I’ve accumulated...
By James Serra
Starting last week is a rollout of the public preview of a new and...
By Stewart "Arturius" Campbell
Comments posted to this topic are about the item Read Only Replica in SQL...
Comments posted to this topic are about the item Identifying Customer Buying Pattern in...
I've had some backups of my encrypted databases failing with the error "BACKUP 'DBName'...
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