I look forward to finishing the article, however, could you fix the following typo?

Each table can have only one clustered index, however up to 249 clustered indexes can be added...

Upload the table to a temporary location into a table with no contraints or unique indexes. These are the business rules. Then weed out the duplicates, might use select distinct,...

Visit here at least weekly and read/work through the articles, tips, scripts, etc.

There are a series of books by Henderson called 'The Guru's Guide...' which are great!

Welcome to the club!

--Check BOL. Use Index tab. Look for phrase

user accounts

--then choose

described

--You will find exactly what you are needing.

where (date_column > (getdate() -1))

This would get anything entered in the last 24 hours from the datetime your process runs.

Sandeep -

When you installed SQL Server, it prompted you to enter a password for the SA account. Use SA and that password to register the server in Enterprise Manager....

I have 4 SANS for a total of 42 TB on IBM that I like alot! Lost a couple of drives, but no major outages...knock on wood

A Couple of...

Start-->Programs-->Microsoft SQL Server-->Books Online

If you run the install on your personal workstation, and just choose the client tools, you can have BOL handy on your machine.

SA is the default system admin account in SQL. SQL can use Windows NT authentication(domain) or SQL Authentication, or both.

In BOL (Books Online)(My life-saver), I used the Index tab...

Chris -

When you register a SQL Server in Enterprise Manager, you have the choice of using your domain login or a SQL login. Try editing the registration and...

Do you have a field in the oeCreditCards table besides _billId and _Rev that does not allow nulls?

I generally will create a left join from oeOrders to oeCreditCards on your...

I have 5 years experience dealing with SQL databases 100 GB+ (I have one that is currently 600 GB). We are a Data Warehouse, mostly read-only, many ad-hoc non-sequential...

Not possible in SQL. You could combine the date and time into one field in SQL. You could dummy the date portion of the field and have the...

Make sure you have some extra space in your primary filegroup and in the log file before detaching from SQL7.0. The upgrade requires some additional space.

I have found that I have to have software like VEDIT to convert the flat file from EBCDIC to ASCII before using DTS to bring the file to SQL.