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,024 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 the realm of data science, SQL (Structured Query Language) reigns supreme. It's your...
By Brian Kelley
The bottom line here is this: the idea that a CSP takes care of...
In today's data-driven world, SQL (Structured Query Language) is a blazing-hot skill. It's your...
The below code works for backup files only from local drives. When replaced with...
I have been asked to fine-tune the following SQL that was written by a...
In this scenario, I seek assistance in implementing row-level permissions for a table named...
What are the initial config sizes for the tempdb primary data files, secondary data files, and log files in SQL Server 2022?
See possible answers