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
803 reads
Mike Pearson
Auto Close and Auto Shrink - Just Don't
New author! Mike Pearson discusses how auto close was at the root of a performance problem he was troubleshooting, how you can check your servers easily, and discusses why both auto close and auto shrink are bad ideas in a production environment.
2003-05-05
22,321 reads
Get the Foreign Key Hierarchy
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
List All Jobs and Their Schedules
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
List All Jobs and Their Schedules (SQL7.0 & 2000)
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
Get table sizes and rowcounts in MB (for VLDB)
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
758 reads
Blogs
From SQL Saturday to Day of Data
By ReviewMyDB
A behind-the-scenes look at Day of Data Jacksonville 2026, the transition from SQL Saturday,...
PostgreSQL 18 Finally Makes BUFFERS the Default. Here Is Why That Matters
You run EXPLAIN ANALYZE on a slow query, stare at the plan, and something...
A New Word: La Guadière
By Steve Jones
la guadière – n. a glint of goodness you notice in something that you...
Forums
BCA KCU KUNINGAN | Tlp/Wa:0817866887
Tlp/Wa_Cs:0817-866-887. Cyber 2, Gedung Menara Karya, Jl. H. R. Rasuna Said Ground Floor, RT.7/RW.2,...
BCA KCP Samanhudi | Tlp/Wa:0817866887
Tlp/Wa_Cs:0817-866-887. Jl. Samanhudi No.57 B, RT.5/RW.3, Ps. Baru, Kecamatan Sawah Besar, Kota Jakarta Pusat,...
non ascii columns in a utf-8 .txt file
hi, we couldnt get our upstream data source developers to supply what is sometimes...
Question of the Day
Running SQLCMD I
I run the SQLCMD utility as follows:
lcmd -S localhost -EI then type this (the 1> is the prompt):
1> select @@version goIf I hit enter, what happens? See possible answers