Show database size info across an instance

This script shows size information of every database on the instance.

Distinct clause in Select statement

SQL Server CRUD-Generation from System Views

If you are not keen on repetitive typing, you can still rapidly produce production-quality documented code by planning ahead and using Extended properties, and system views. Phil Factor explains, with some Scary SQL

Backup all Filegroups

A short script to backup all filegroups, for those who utilise filegroups within a database.

Binary Trees in SQL

A number of hierarchies and networks are most conveniently modelled as binary trees. So what is the best way of representing them in SQL? Joe Celko discards the Nested Set solution in favour of surprisingly efficient solution based on the Binary Heap

VARCHAR datatype

Are we in all these cities?

REPLACE() and NULL

Table Variable :Doesn't care

More fun with ISNUMERIC()