List All Databases, Sizes and Properties
This script will list all the databases on your server (SQL2000 only) as well as their sizes and some key properties.Β Very useful for keeping rogue developers under control π
2003-05-17
791 reads
This script will list all the databases on your server (SQL2000 only) as well as their sizes and some key properties.Β Very useful for keeping rogue developers under control π
2003-05-17
791 reads
This script will run through the foreign keys on tables to produce a hierarchy of the tables in a database.This is useful when you need to purge and repopulate test databases with foreign key contraints
2002-07-24
2,110 reads
This queries the sysjobs, sysjobschedules and sysjobhistory table to produce a resultset showing the jobs on a server plus their schedules (if applicable) and the maximun duration of the job.
2002-06-20
4,244 reads
This queries the sysjobs, sysjobschedules and sysjobhistory table to produce a resultset showing the jobs on a server plus their schedules (if applicable).
2002-06-04
1,759 reads
This simple script is based on sp_spacedused, but returns values for all user tables in the database, with information in MB instead of the usual KB - which is useful for large databases.Β Simply run it in query analyser against the database concerned
2002-05-03
741 reads
By Daniel Janik
The circle cylinder of life Maybe youβve noticed all the twenty somethings tight rolling...
By Chris Yates
In todayβs data-driven economy, organizations are no longer asking if they should invest in...
By Rohit Garg
PostgreSQL, often referred to as Postgres, is a powerful, open-source object-relational database system that...
Comments posted to this topic are about the item How a Legacy Logic Choked...
Good Morning All, We are facing replication latency issue. I checked for blocking, long...
Comments posted to this topic are about the item Life's Little Frustrations
I have this table in SQL Server 2022:
CREATE TABLE CustomerLarge (CustomerID INT NOT NULL IDENTITY(1, 1) CONSTRAINT CustomerLargePK PRIMARY KEY CLUSTERED , CustomerName VARCHAR(20) , CustomerContactFirstName VARCHAR(40) , CustomerContactLastName VARCHAR(40) , Address VARCHAR(20) , Address2 VARCHAR(20) , City VARCHAR(20) , CountryCode CHAR(3) , Postal VARCHAR(20) ) GOIf I check the columns_updated() function return in a trigger, what is the data returned? See possible answers