Charpad - Character Padding Function

A generic character padding function. Useful for situations where you need fixed width formatting e.g. email reports.

Encryption

What will be output?

Finding rows count in a table without Select...

Here is a one more very quick way to find row count for a table.

Linked Server Connectivity Test

A short procedure for your tools database. Use it to test connectivity to linked servers.

Another way to split a recordset

Result set splitter with NTILE() function

Column Size Checker

A T-SQL script that reveals how appropriate your choice of column sizes is.

Credit Card Number Validation Escalar Function

Evaluate credit card numbers based on ISO 2894 algorithm.

An Urgent Ad Hoc Report

In this new article, Yakov Shlafman shows us how he wrote a quick ad hoc report of expenses so that he could leave on time one day.

T-SQL: Why “It Depends”

Why does everyone use "it depends" as an answer to many T-SQL questions? Bob Hovious brings us a short example of how performance can change based on data loads for the same code.