Michael Coles

The Joy of Numbers

Numbers are fascinating concepts in all types of mathematics, but they can be very helpful as well in your SQL Server queries. Guru Michael Coles brings us a look at how a numbers table can you and includes a bunch of code for both SQL Server 2000 and SQL Server 2005.

5 (1)

2006-08-14

16,427 reads

SQL 2000 DBA Toolkit Part 4

In the final installment of his series, Michael Coles examines a few other functions in his SQL Server 2000 toolkit to help you with other functions, like reading a directory on your server. Read the series and send some feedback to make this THE premier toolset for SQL Server 2000 DBAs.

5 (1)

2006-05-04

14,061 reads

Sequential Ordering on SQL 2005

Many people have posed the question of how to generate sequential numbers for some report when the underlying data has no numbering system. The solutions have always been complicated derived or temporary tables and are difficult to implement. SQL Server 2005, however, brings us the ROW_NUMBER() function and author Michael Coles shows us how this can be used to easily add sequential numbering to your results.

5 (5)

2006-02-14

18,252 reads

Blogs

Improving TweetDeck with Better TweetDeck

By

If you are at involved with the #sqlfamily, you are bound to hear about...

Interview with Bob Ward

By

This is the eight interview we have done. This time our guest is the...

SQL in the City Comes Back to Seattle

By

This year at the PASS Summit, Redgate is holding our SQL in the City...

Read the latest Blogs

Forums

Selecting data from two columns

By GPGAgent

The table has many columns, two of which are mutually exclusive, LocationNo and assetNo,...

Refresh data warehouse with production data

By Lord Slaagh

Hello SSC, I want to create a package that refreshes the tables in my...

SSIS Deployment w params

By Darryl Wilson

<!--more-->Hi I have a simple package that exports data via ftp using a dynamic...

Visit the forum

Ask SSC

SQL Server Q&A from the SQLServerCentral community

Get answers