Wouldn't "total invoices - total payments received" be the receivable...

I assumed by "for each Discharge", you wanted to see every discharge, with only their before and after appointments.  If that's not what you wanted, please clarify your requirements.

            
December 3, 2020 at 6:18 pm
            
#3816632

            
            
                                                
        

Are you using data compression?  If not, that should be the first thing to check toward reducing total table size.

If you want to improve overall performance, we'd need to look...

I prefer this method too, with the minor change that the column name should be used rather than a hard-coded value:

SELECT CONVERT(CHAR(8),...

I think a synonym would allow you to create a completely new view without affecting the current one.  Then, when you had the new view fully tested out, with all...

I'd say use CDC as that will require no changes to any existing table that already has a unique index.  Presumably the vast majority of your tables already have at...

I don't know if SQL Server still allows cpu affinity to be used, but if it does, you might look into that and thus licensing fewer than 32 cores.  That's...

I think you will have to drop them and re-create them (once/if sp_refreshview doesn't work).

Script them out, being sure to include any permissions or other system table / metadata entries...

Look in the SQL error log, you might be able to at least some more details about what task timed out, though admittedly not a lot of details.

Typically timeouts are...

That means that the task being run will be cancelled if it is involved in a deadlock.  It doesn't mean that a deadlock will occur.  -10 is the lowest priority...

Ah... therein...

The "trick" part of the query is determining the middle score.  Many developers don't figure that one out.

In my own way I tried to help (sort of), since you can...

• This reply was modified 5 years, 1 months ago by ScottPletcher.

Ah... therein lies the...

>> would hate having to be the DBA going to a place that Celko had designed / created. What a nightmare of missing leading zeros or added leading zeros...

• This reply was modified 5 years, 1 months ago by ScottPletcher.

Here's another q I like to use:

"Bad data is getting into a prod table from an app.  Developers have full data modification authority to that data and currently fix it...