Same indexes on both?

Same MAXDOP on both?

Same Cost Threshold For Parallelism?

Same hardware?

There's a shedload of things that could be causing the 2019 code to be running slower and the list...

Well, since few days I was searching about SQL courses to become pro on this. One of my friend suggest me some guide to become pro on this and...

My most valuable lesson in the area of resumes and touting accomplishments came from a meeting with the president and co-owner of the  company I worked for in 1974. ...

Yes, we both should have noticed that, but our methods are more general in that they will return the entire row that contains the max date even if some...

As you...

What's more interesting than any of that is how we missed the forest for the trees.  🙁  The MAX solution that Peter provided is all that's needed here. [headdesk].

I agree with Jeff 100%.  Performance is paramount, assuming the foundation is sound. Bot fast and safe at the same time is an ultimate goal, but at the same...

We are not designing databases for speed, we are doing it to ensure data integrity. What is the use for data retrieved quickly if it is inaccurate or could...

I've got a (8 years old) Dell XPS 8700 desktop with a  i7-4790 and 28GB RAM, and a SanDisk Ultra II 960GB SSD with the tempdb on an even...

Wow!  Those times are about twice as fast as what I'm getting.  What kind of machine are you working on?

I'm on an Alienware R17 (about 4 years old now) with...

Just to add my 2 cents 2 late, for the given test data, the WHERE EXISTS code does 18 page reads.  The following does 1.

WITH cteDupeCheck AS
(
...

Which cardinality estimator has been set for the two databases?  Also, have you check to make sure things like MaxDop and Cost Threshold For Parallelism and other settings are identical?

Creating an SSIS package using Java can be a complex process, as SSIS is primarily designed to work with Microsoft's .NET Framework. However, it is possible to create SSIS...

Improving database design can have a significant impact on the speed of SQL queries. Here are some tips to optimize your database design and enhance query performance:

• Indexing:...

Improving database design can have a significant impact on the speed of SQL queries. Here are some tips to optimize your database design and enhance query performance:

...