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,899 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,899 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,144 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,178 reads
The script shows one of ways generating number sequence - this one uses CTE.
2011-10-04 (first published: 2008-02-06)
1,912 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,134 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,075 reads
2011-03-01 (first published: 2011-02-18)
3,993 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)
916 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,069 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,702 reads
So, you want to get your SQL skills razor-sharp without dropping any cash? You're...
By Steve Jones
Here are the slides from my talk today at the Redgate NYC Devour Hour:...
By Steve Jones
If you have any doubt about being able to carry a load in one...
Pure Leaf CBD, in particular, has gained attention as a high-quality CBD product that...
Hi everyone I have a SP that just failed. Format of SP is: Select...
Comments posted to this topic are about the item Analyzing Tempdb Spills and Usage...
If I run "dab init" to create a new API over a database, what parameters are required?
See possible answers