Articles

Lots of people are designing and building Microsoft Windows-based apps with previously unimagined reliability. Starbucks, GMAC, and FreeMarkets.com all have case studies demonstrating five nines. So, how are these companies able to achieve these levels of reliability?This month I am going to show you how to use standard Microsoft Windows technologies to make your Microsoft SQL Server™ app just like Denny's—“always open” and ready for business.

2001-06-05

1,660 reads

Complex updates using the Case statement

by Neil Boyle

SQLServerCentral.com

Advanced Querying

One of the keys to database performance if keeping your transactions as short as possible. In this article we will look at a couple of tricks using the CASE statement to perform multiple updates on a table in a single operation.

★ ★ ★ ★ ★ ★ ★ ★ ★ ★

5 (2)

You rated this post out of 5. Change rating

2001-06-04

10,699 reads

Job Performance Review

by Steve Jones

SQLServerCentral.com

The Lighter Side

I hope I never receive a review like this one!

★ ★ ★ ★ ★ ★ ★ ★ ★ ★

5 (1)

You rated this post out of 5. Change rating

2001-06-04

2,726 reads

Put Advanced SQL Server Features To Work

by Additional Articles

Microsoft MSDN

Miscellaneous

SQL is the lingua franca of server-side Web data apps. Some of the advanced features of SQL joins, views, rankings, and computed columns can drastically simplify your code.

2001-06-04

1,107 reads

Missing Temp Tables

by Andy Warren

SQLServerCentral.com

SQL Puzzles

In part one of a two part article, Andy Warren challenges the readers of SQLServerCentral.com to solve a problem involving ADO and SQL Server. Are you up to the challenge?

★ ★ ★ ★ ★ ★ ★ ★ ★ ★

You rated this post out of 5. Change rating

2001-06-01

4,210 reads

Scrubbing Data With DTS : Part 1

by Brian Knight

SQLServerCentral.com

When trying to implement data from an external source, very rarely do you receive the data in perfect condition. In part one of this series, we show you how to clean your data using DTS.