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,944 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,109 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
789 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,093 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,449 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,768 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
775 reads
Blogs
Flyway Tips: Object History
By Steve Jones
It’s a small change, but a handy one. Flyway Desktop (FWD) now includes the...
Car Update September 2026
By Steve Jones
Software is hard. While I love our Lucid Gravity, I realize that they are...
Microsoft Tools for Making Data AI-Ready
By James Serra
Making Data AI-Ready, Part 2 (This is the second article in a three-part series...
Forums
Looking for old SQL Server 1.x - 4.21 disks, manuals, boxes, etc.
Hi everyone, I'm hoping some of the longtime SQL Server professionals here might be...
Checking the Error Log II
Comments posted to this topic are about the item Checking the Error Log II
Parameter Sniffing on SQL Server 2025: A Walkthrough with Real Numbers
Comments posted to this topic are about the item Parameter Sniffing on SQL Server...
Question of the Day
Checking the Error Log II
What is the reason I should change my old code that uses xp_readerrorlog?
See possible answers