Statement evaluation precedence

Analysing a T-SQL Query

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.