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,880 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,141 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,882 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,999 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,966 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)
881 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,662 reads
Blogs
Daily Coping 1 Dec 2022
By Steve Jones
Today’s coping tip is to discover your artistic side. Design a friendly greeting card....
New Database Job – The 6 Month Plan
So, we made it through our first 90 days, things start getting tougher now...
SQL Homework – December 2022 – What’s new in SQL Server?
SQL Server 2022 has been released! Long live SQL Server! No really, I’ve still...
Forums
How to get intellisense on CLR types in SQL Server Management Studio
I created a CLR user defined type in C#/Visual Studio and added it to...
Display Top N values of a table with calculation next to it
Hi, In Power BI Report Builder I need to use SSRS code for my...
Package runs in Debug mode but fails otherwise
Hi We have a SSIS package that uploads data to Blob storage. The package...
Ask SSC