Hang on there PW, I think the CASE statement in your subquery is backwards.  The way it is written it will return -1 as the orderid for all records with...

You can get multiple rows if a customer places more than one order a day.  To be sure you only get one row per customer you may have to...

Look at the options for the data pump task.  The default is to commit all rows in one transaction, but you change it to commit every x number of rows. ...

The best way to prevent table locks is to limit the number of rows that are part of each transaction.  Commit inserts every few thousand rows, perform updates in a...

How about "don't post anything you'd NOT want your employer to read."

Wouldn't your solution (unknown password on the primary) work if you didn't bother changing the password every day?  Passwords are stored in the master database, so they wouldn't be part of...

That is an oversimplification.  It needs 1.2 x the size of the data in the table just to rebuild a clustered index.  (If there have been a lot of randomly-distributed...

Use the "Design Query in Editor" toolbar button to use the graphical query designer.  It won't run queries, but when you're finished the query is automatically pasted into the active...

This version should be fairly robust.  This will prevent multiple users from getting the same number, but it will create locking problems if you have a lot of concurrent users. ...