Gregory Larsen

In this article, I am going to show you a number of tips for displaying numeric fields as strings. I will show you how to pad zeroes on the left side of

This article will be the last in my data/time series, and will discuss the last few date functions I have yet to cover in this series. I will discuss how

All applications need to retrieve data in SQL Server tables based on DATETIME and/or SMALLDATETIME columns. In your particular application, you may need

In my first article in this series, I discussed different aspects of entering date/time data into SQL Server DATETIME and SMALLDATE columns. This article

This is the first article in a series of articles that I will discuss various aspects of working with SQL Server date/time columns. SQL Server has two

Are you tired of manually restoring each database on a new server when the original server has a melt down? Does the manual process seem slow, and prone

Do you get tired of reviewing each SQL Agent notification nightly to determine which SQL Agent jobs failed? Are there a significant number of SQL Agent

With SQL Server 2000 you are able to create databases or columns with a different collating setting than the server (discussed in Part 1). This is

A few months ago, I was running a stored procedure (SP) that performed a cross database join on our SQL Server 2000 box. This particular procedure was

Have you heard about orphan SQL Server users? If not, an orphan user is a user in a SQL Server database that is not associated with a SQL Server login.

When I was a programmer many years ago, I remember telling the Data Administrator, "I don't care what you name a table/column, just give me a name you can

Introduction The Query Analyzer (QA) in SQL Server 2000 is greatly enhanced over the QA in SQL Server 7.0. One of the enhancements, QA templates, can