A quick way to find recently entered datetime entries in tables

Sometimes you need to scan a large number of datetime columns for most recent access.

A round number

Play with NULLIF

Using REPLACE in an UPDATE statement

This article covers using the REPLACE function to selectively replace text inside a string in SQL Server. The REPLACE function is easy to use and very handy with an UPDATE statment.

Convert seconds to a timestring

This script converts a number of seconds (integer) to a time string, format 'hh:mm:ss'

Date data type

DateTime

Index Fragmentation Status (includes Partitioned Tables/Indexes)

This script reveals the state of your indexes. It breaks down the indexes where they are partitioned, matching the index to it’s partition and filegroup.

Truncate rollback

Basic Defensive Database Programming Techniques

We can all recognize good-quality database code: It doesn't break with every change in the server's configuration, or on upgrade. It isn't affected by concurrent usage, or high workload. In an extract from his forthcoming book, Alex explains just how to go about producing resilient TSQL code that works, and carries on working.