Round up or down I

default schema trouble

UPDATE Basics in SQL Server

SQL Server's UPDATE statement is apparently simple, but complications such as the FROM clause can cause puzzlement. Bob Sheldon starts simply, and introduces the more complex forms painlessly.

Dynamic Data Driven Variable Hierarchical Structures in SQL

This article describes data driven variable structure generation in SQL. The controlling data can be located higher up on the hierarchical pathway or can be located further down on the pathway producing a look-ahead operation. Multiple pathways can independently produce dynamic data driven structures and these dynamic structures can be nested allowing a very flexible and powerful dynamic automatic data structure generation capability. These different controls of structure generation can be combined.

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