To merge cells - you need to select the cells, not the row.  On the far left - right-click the gray area and insert a new row in the table. ...

You can write code to search stored procedures, views and functions for specific strings - or use SQL Search from Redgate.  It would be quite easy to search all objects...

From my reading on automatic seeding - yes, that should handle removing and adding the database.  Regardless of the answer from the vendor - notifying them of the issue will...

It looks like each one of those is a 'row' of data in the table - if so, just add another row in the tablix below the last row in...

The reason for this is so that I can change the SYNONYM and be 100% certain that there are no hardwired statements which directly access Other Database and bypass...

I think you are confusing HA with business continuity (DR).  HA is meant for high-availability and generally utilizes servers within the same DC.  If the primary server goes down -...

It appears your vendor is doing something rather problematic during upgrades.  I have a vendor that used to do the same thing - and that is they change the recovery...

Oh - I know that and have run into the same kind of data issues with other large organizations.  However - you would think an international corporation that must deal...

Wow - a large international company that is not using ISO standards in their software or in their exported data?  That is truly concerning...

Are these processes that are taking more than 3 hours causing problems?  If not, then I would not be looking to kill the process and force a rollback - instead...

Most likely this is caused by physical reads - loading the data from disk into the buffer cache.  Once the data has been loaded into the buffer cache the query...

I will add to what Grant has stated - this output is being sent to a report.  Using ORDER BY in the query is only useful if the report is...

The reason '25 déc 2020' does not convert is because the abbreviation for December in French is: 'déc.'  You can confirm this using: Select format(cast('2020-12-25' As date), 'dd MMM yyyy', 'fr-FR')

This goes back to the original problem...you...

You will NOT get dup rows from dup values in an IN clause.  Easy enough to verify:

CREATE TABLE #t1 ( col1 int NOT NULL )
INSERT INTO...

If possible - go back to the sender and have them send the data using ISO standard date format of YYYY-MM-DD or YYYYMMDD instead of locale specific format.

Barring that -...