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,915 reads
Script Drop all tables of a database
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,094 reads
Grant permission to the profile
The Profiler is a powerful tool available to the dba, but it can also be very useful for system developers....
2010-12-18
775 reads
Last restart of SQL Server
Occasionally I need to see what the date of last restart of SQL Server. The old method isto check the...
2010-12-17
1,076 reads
Number of sessions per database
Sometimes when we need to do some maintenance on a SQL server, you need to verify which users are connected...
2010-12-16
1,430 reads
Using DMV to identify members roles
Some times is necessary retrieve a list of members of the roles of a database. Doing this is simple, using...
2010-08-12
2,751 reads
Retrieving last backups of the databases
The script below is a simple and quick way to find out the last backup performed successfully to the databases...
2010-07-14
758 reads
Blogs
The Benefits of Teaching
By Brian Kelley
Even preparing for a class or seminar with set materials takes a lot of...
Power BI, Excel, OneLake – Dreams Do Come True!
By DataOnWheels
I can’t believe it’s finally here! A way to have Excel live in OneDrive...
The Book of Redgate: What Our Staff Says
By Steve Jones
This image is from 2010, and it goes along with my last post of...
Forums
Website Stability 2025/12/05
All week we've had issues with the site being up and down. There's been...
403 Forbidden
I created a post (or tried) in the 2022 Admin forum. https://www.sqlservercentral.com/?post_type=topic&p=4694880 But it's...
Question of the Day
Fabric Mirroring
In which versions can I mirror a database from an on-premises SQL Server to a Fabric data warehouse?
See possible answers