I assume it's...

Should we think about compressing tables like MyHugeTbl 200 million rows table which during the day only has reads/scans but is refreshed-truncated and loaded every night. Will the compression...

Yes.  You simply need to "Attach" the database using those two files and it can be done using the Object Explorer window in SSMS.  Right click on "Databases" and then...

Interesting and appropriate parallel you bring up... SpaceX has blown up and crashed as many rockets as I've seen DevOps projects fail for similar reasons. 😉

Here is a quick example of using SUM() with an OVER clause to create a running total without having to UPDATE.  It uses the data from your #tmpTable.

            
April 13, 2021 at 4:09 am
            
#3870355

            
            
                                                
        

@ns550,

Seriously, how'd it go?

p.s. No long-winded lecture on the use of WITH(NOLOCK) or an ordinal column list in the ORDER BY.  You've been around long enough to know the cautions and...

Hello Jeff,

Thanks for your reply!

If I use the initial union query and put everything in a CTE, can I do an Update and then SELECT all fields? I need...

You've probably either actually hit the INS (insert) key or some combination of keys that does the same thing.  If you look at the bottom of the SSMS code window,...

In case anyone is interested, the GroupBy voting begins on Monday, 12 April 2021 (that's about an hour from now for us in the EDST time zone).  Here's the link. ...

p.s. No long-winded lecture on the use of WITH(NOLOCK) or an ordinal column list in the ORDER BY.  You've been around long enough to know the cautions and the reasons...

Thank you for the graphic that clearly demonstrates the problem and for the readily consumable test data, Luis.  The following will do it for you.  Details in the comments.

            
April 12, 2021 at 12:04 am
            
#3867916

            
            
                                                
        

It's a "staging" table, right?  Do you actually need a Clustered Index on it?  While it usually is a "Best Practice" to have a good Clustered Index on permanent tables,...

Heh... a little Sunday morning laugh for everyone... It's simply titled "DevOps engineer during automation of CI-CD ".  I have a real-live appreciation for what they frequently have to go...

Just for your information, Thomas Grosher works with reporting databases that dwarf even the sizes reported on this thread.  He recently did a presentation for the "Cloud Driven Data" Meetup...