Shrink all databases
Procedure changes all databases' recovery mode to simple and shrinks them all (or at least it tries to).
2012-03-07 (first published: 2008-01-14)
3,890 reads
Procedure changes all databases' recovery mode to simple and shrinks them all (or at least it tries to).
2012-03-07 (first published: 2008-01-14)
3,890 reads
This terse script shows an easy (but "dirty" - so not advisable for production environments - rather for personal use) way to select data from stored procedure.
2011-12-14 (first published: 2008-03-04)
4,127 reads
The procedure below deletes all records from the specified database's(except master, model, msdb and tempdb) tables (except those from the schema 'sys').
2011-12-09 (first published: 2008-01-31)
4,157 reads
The script shows one of ways generating number sequence - this one uses CTE.
2011-10-04 (first published: 2008-02-06)
1,886 reads
This procedure works like the sp_spaceused procedure but this one shows statistics for all tables in the selected database or for all databases (excluding tempdb and model).
2011-05-25 (first published: 2008-03-05)
10,076 reads
This procedure searches for a specified text in all (or one selected) databases in all (or selected) tables.
2011-03-02 (first published: 2008-01-25)
5,023 reads
2011-03-01 (first published: 2011-02-18)
3,969 reads
This procedure searches for the specified GUID (or its part) in all (or selected one) databases
2011-02-21 (first published: 2008-01-24)
899 reads
This procedure is supposed to compare structure (tables, procedures, triggers, foraign keys etc.) of two specified databases.
2008-10-27 (first published: 2008-08-19)
3,063 reads
Created view displays all text columns' collations in the current database with the information whether
the collation is different from the database's one.
2008-04-04 (first published: 2008-01-22)
1,674 reads
In today's data-driven world, SQL (Structured Query Language) is a blazing-hot skill. It's your...
By Steve Jones
I leave tonight for Australia. I was in London 3 days ago, so this...
By Brian Kelley
As I look at the state of information technology today, I see one constant:...
jan 10gb feb 15gb mar 16gb april 14gb(truncate data) may 18gb june 22gb Is...
Everybody (well almost) knows that if you want to learn the design patterns for...
How many table hints can I include in a query?
See possible answers