SQL Server: Compare Database Tables/Indexes/Views/SP’s etc. For Differences Across Instances

There are a bunch of tools in the market to do the database comparisons for differences but if you want to do it for free (and programmatically)  at a basic level, you could use the method outlined below. For me, this came about as a result of an user asking "So, what is different between …

SQL Server: Compare The Configuration Of Two Instances Using sys.configurations

Compare the configuration of 2 SQL Server instances using sys.configurations

Oracle – Compare Text Files With 10 Million Lines In 10 Minutes Using 10 Lines Of Code – EXTERNAL Tables

The goal of this post is to compare two text files that may have millions of lines and compare them to quickly find out which lines differ using Oracle EXTERNAL tables. As an Oracle professional, “external tables” are something you may already be familiar with or maybe you have heard about them but not used …

Oracle and SQL Server – Conditions In WHERE Clause vs. JOIN Clause – Why And When It Matters? Must Read!

This post is about the various types of JOIN's and how the conditions affect the results when placed in the JOIN clause versus the WHERE clause. OUTER JOINS Database programmers use OUTER JOINS in their job day in and day out. There are certain “gotchas” that you need to watch out for. One not only …

Oracle (or) SQL Server: Find Row Level Data Differences Using MINUS/EXCEPT – 100 Level

Changes needed for SQL Server The simple SQL illustrations mostly show Oracle code but the final SQL is also shown for SQL Server (simply remove the “FROM DUAL” references and replace "MINUS" with "EXCEPT"). What this post is about? When we need to compare two sets of data to find out which rows are different between the …