Introduction to Gaps and Islands Analysis

T-SQL window functions simplify solving many complex queries. In this article, Edward Pollack demonstrates how the functions can be used to find gaps and islands in a dataset.

More Choice

CHOOSing a value

Default Schemas

The End of 2019

Do You Have REFERENCES?

The logic for referential integrity can be implemented in application code, but to make sure that it is enforced, include foreign key constraints in the database design instead. In this article, Joe Celko talks about the history of references in SQL and the options available today.

Knocking off early

What is the datatype?

T-SQL script to purge all the tables including foreign key references

T-SQL script to purge all the tables including foreign key references. The script has been made smart enough to use TRUNCATE wherever there is no foreign key reference and to use DELETE wherever there is foreign key reference.

Using All Your Tools

Steve looks at a number of tools that you should spend time learning and building a level of comfort that enables you to use them in your daily work.