A quick thought, let's figure out what needs to be done before pondering on how things are done!

😎

A simple modelling of the problem would include the following entities:

            
June 20, 2024 at 3:38 pm
            
#4430059

            
            
                                                
        

.-. --- ..-. .-..

😎

Hi Pieter,

can you share the model you are working on?

😎

There are several ways of approaching this problem, some are good, some are bad and some are ugly!

For performance, one might...

Do you have the supporting foreign key constraints in place?

😎

If the table joins are supported by foreign key constraints with the proper indices, the engine can "trust" the statistics instead...

Reaping the benefits of the Window functions in T-SQL – SQLServerCentral

😎

Look at the second...

If you can send a note to marketing@ with your specific complaints or issues, that will help. There is a proposal up with our internal IT staff/developers to do...

Happy to help, now let's dig into the problem you need to solve!

😎

Could you please list the high-level requirements in a handful of bullet points?

My first thought is that something is not right at the source!

😎

Question; have you analysed the offending queries?

Quick comment: NO LOCK == NO LUCK

😎

Has your doctor ever asked you how many painkillers you are taking in order to diagnose your problem?

Quick question; why store the Excel files as BLOB?

😎

There are several resilient options for file storage, most of which will provide better visibility/usability of the content.

There are a few possible causes, we need some further information!

😎

Quick questions:

1. was this Error 684 and Severity 22?
2. Could you please post the output of "SELECT @@VERSION;"
3. Can you...

Can you share some more details, don't like guesswork?

😎

Quick question, is the application's query interface a predefined API or dynamically constructed SQL?

😎

Capturing the queries on the server comes with a considerable overhead, I suggest you do an impact...

What is the problem you are trying to solve?

😎

First of all, establish what the issues are and then target those issues! Without a proper RCA (Root Cause Analysis), I will not provide any guesswork on a possible solution.

😎

Another...