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.

SQL Server Ranking Functions

A new article from Wayne Sheffield that examines the ranking functions in SQL Server. Learn how you can use ROW_NUMBER(), NTILE(), RANK(), and DENSE_RANK() in your applications.

What is the value of SCOPE_IDENTITY()

Rowcount and multiple assignment