Use of IDENTITY_INSERT?

Round up or down II

Data Type and Length

Try it out..

Creating Holidays and Special Dates

A way to save holiday records that can be created as needed into a search-able calendar table.

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.