I did SQL Server --> Oracle and now I'm back to SQL Server (3 jobs).

I have no doubt that SQL Server would be but a footnote in database books if Oracle...

temp table >>> cursor

Cursors are the method of last resort.

The operations you are speaking of are for permanent tables.  Select into a temp table should cause no logging to occur.  That is what we are speaking about in this...

At least in the past (I'm not sure this is still an issue, though), SQL Server would lock system table rows while the select was being performed.  The rows were...

Yes, just use create index.  Index creation on a temp table is identical to a normal table, and it can speed joins and processing of rows immensely just like putting...

Table Variables are inferior to Temp Tables in performance except in cases where performance won't really be an issue (small tables) . 

Table variables are great for small things, but if...

Well, the one I posted on my own site should be working.  Since it was never emailed via our email system.

If not, I can try try again.

Bah.  Sorry about that.  I've tried 4 times now to get all the files.  Visual studio needs some nice way of packaging this up.

Anyway, I have replaced the file again.

Fixed.  Download from my link above and the files should be there.  The ER1 file is an ERwin file.  It is only helpful if you have ERwin.

I agree, you are definitely making a trade off.

That trade off is essentially developer time for performance.  However, serving application based (internal) webpages is usually something where you can know...

Here ya go:

DOWNLOAD

How about not granting users read access? IF they shouldnt be reading the data, it is the correct solution.  If they CAN read the data, what's the problem?

If they should...

Try this - create a temporary table with an identity on it and a column for the primary key column of your invoices table.  Select all the invoices into it. ...

No, this is what I'm talking about:

"Changing tables doesn't always require changing procs, depends on why, right? If you need a value from the app, you'll usually have to...