Yes, you're quite right, it will use more CPU. ...

• This reply was modified 4 years, 9 months ago by ScottPletcher.

Oracle used to use Grid (which is much more powerful than just the cluster setup in SQL Server).  But big $$$$$$$.

Could you use SQL Developer Edition?  If it's business prod, you can't, but if it's just something you're doing on your own, you can.  And that edition has full capabilities.

that is where some disagree.

on my 1500 production db's 220 have RCSI enabled - and most new db's are being created with it enabled unless the team requesting...

Oh BTW, On top of compression, you may also want to fiddle around with following settings to see what works best for you !

--Media Set Options
...

(1) As always, the first step is to make sure you have the very best clustered index on every table of significant size.  That is not an easy thing to...

Hmm, the first part of the Answer you chose is correct.  But keep in mind that the second part, the "P.S.", is not.

that is where some disagree.

on my 1500 production db's 220 have RCSI enabled - and most new db's are being created with it enabled unless the team requesting it...

(1) Have you page compressed any (or better yet all) of the really large tables?  And used COMPRESS/DECOMPRESS if it's clob data? [If you're on SQL 2016+ then even Standard...

For example:

ALTER TABLE #ACME ADD 
    new_column1 uniqueidentifier NOT NULL DEFAULT NEWID(),
    new_column2 int IDENTITY(1, 1) NOT NULL;

SELECT ca1.*
FROM #ACME A
CROSS...

You don't really need a pk or any other column from the main table.  Also, I assumed you're rather see blank than NULL for missing levels, but if...

Hmm, that doesn't seem right.  You must have added other columns to...

Although the PK is frequently also the clustered index, it's not necessarily so.  The keys of non-clustered indexes include the keys of the clustered index, which isn't necessarily the...

I manage hundreds of prod dbs (and hundreds of qa ones) and I have roughly a dozen that have RCSI.  The overhead is just so high.  [And if you want...

You don't really need a pk or any other column from the main table.  Also, I assumed you'd rather see blank than NULL for missing levels, but if not, just...