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,879 reads
Rafal Skotak
Select from stored procedure
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,123 reads
Clear database - delete all records from a database (updated)
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,133 reads
Generating number sequences with Common Table Expressions
The script shows one of ways generating number sequence - this one uses CTE.
2011-10-04 (first published: 2008-02-06)
1,877 reads
Row count and space used for all tables in database (update)
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)
9,988 reads
Search for a text in all databases
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)
4,957 reads
2011-03-01 (first published: 2011-02-18)
3,963 reads
Search for a specified GUID (or its part) in all databases (updated)
This procedure searches for the specified GUID (or its part) in all (or selected one) databases
2011-02-21 (first published: 2008-01-24)
873 reads
Compare databases structure
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,060 reads
Show all database's tables' columns' collations.
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,656 reads
Blogs
SQL Homework – October 2022 – Replication part 2
In August we started taking a look at replication. We learned some of the...
Function Vs. Performance
Recently I was looking through DBA.StackExchange when I saw a pretty simple question that...
Daily Coping 3 Oct 2022
By Steve Jones
Today’s coping tip is to write down three things you appreciate about yourself. I...
Forums
Data replication tools and review
Hello expertise, Could you please suggest best tool for database replication? data replication on...
Version Controlling Lambdas
I know there are lambda versions. But I want to know if this can...
subscriber part of ALWAYSON
Hi. Publisher stop sending transaction to AOAG primary replica whenever AG failover. It seems...
Ask SSC