Shrink Database Log Files One by One

Learn how you can shrink your transaction log files serially, one by one.

The Importance of Reading Comments

Read when you search for help on the internet. You might miss a very important part of what you must do.

Creating indexes on computed columns

Group by

Missing row numbers

I had a request from a client who prints a lot of cheques each month and there control over the cheques went a bit haywire. The requested me to create some controls in their system to make sure that the cheques are use in cheque number sequence.

Knowledge sharing

This article talks about the sharing of knowledge in forums such as SQLServerCentral.

Patindex

This artcle by new author Manie Verster examines the use of the PATINDEX function in T-SQL.