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 …

Advertisement

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

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

Oracle – Facts About Primary Key vs. Unique Key You May Not Have Known

In this post we talk about Oracle specifically although some concepts apply to other databases. At a high level - PK's vs UK's Ask someone who has been doing database work about Primary Keys (PK) and Unique Keys (UK) and the differences between the two, they will tell you everything they know. Some even go into …

Oracle & SQL Server: COUNT(*) vs. COUNT(1) vs. COUNT(ColumnName) – Differences

NULL's will be eliminated! When doing a count() operation, it helps to understand what is counted and what is not. Count can be done in multiple ways COUNT(*) COUNT(1) COUNT([Column_Name]) COUNT(DISTNCT [Column_Name]) With and without GROUP BY While it is straight-forward to get a count, here are a couple of things to note NULL values …