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
804 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
804 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,131 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,265 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,769 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
759 reads
By Steve Jones
Itβs Prime Day. A few of my recommendations, since I want to do some...
With Fabric Mirroring, Microsoft is promoting a nice and appealing story for operational reporting...
If youβve been watching AI roll through the data community and thinking, βthis seems...
Comments posted to this topic are about the item SQL Art, Part 4: Happy...
Comments posted to this topic are about the item Concurrency and Baseline Control: Level...
Comments posted to this topic are about the item Spending Time in the Office
I have this code on SQL Server 2022. What happens when it runs all at once?
DROP TABLE IF EXISTS dbo.Commission GO CREATE TABLE dbo.Commission (id INT NOT NULL IDENTITY(1,1) CONSTRAINT CommissionPK PRIMARY KEY , salesperson VARCHAR(20) , commission VARCHAR(20) ) GO INSERT dbo.Commission ( salesperson, commission) VALUES ( 'Brian', 12 ), ( 'Brian', 'None' ) GOSee possible answers