Michael Coles


SQLServerCentral Article

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

17,539 reads

SQLServerCentral Article

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,106 reads

SQLServerCentral Article

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,791 reads

Blogs

Updates from Coping Tips

By

I’ve written a lot of coping tips now. Over two years worth (Mon-Fri) since...

What I’ve learned in my first 100 days with a consulting group

By

In case you don’t follow me on LinkedIn or Twitter, your humble host joined...

Power BI as a enterprise data warehouse solution?

By

With Power BI continuing to get many great new features, including the latest in...

Read the latest Blogs

Forums

Questions about SQL Server 2016 (and later) High Availability Groups (HADr)

By sayagi1

I'm looking into implementing availability groups for our organization after we upgrade from SQL...

Server related questions

By albstaten

Hi, could someone answer the following questions please? I've googled of course but I'm...

MS SQL Server 2012 question regarding SSIS

By kyoto5

OK so I have a customer with a hosted website with eCommerce options. Essentially...

Visit the forum

Ask SSC Logo Ask SSC

SQL Server Q&A from the SQLServerCentral community

Get answers