sp_DBCompare

This simple script make a comparison between two given database. It compare: The table present in both database            The data type, lenght, nullability, precision for each table.            The object present in both database. The StoredProc is able to compare database across different server, simple make […]

2002-10-31

766 reads

Blogs

sys.xp_delete_files and ‘allow filesystem enumeration’: two new undocumented items in SQL Server 2019

By

sys.xp_delete_files and 'allow filesystem enumeration': two new undocumented items in SQL Server 2019… Continue...

Actual Difference Between EXISTS(SELECT 1 …), EXISTS(SELECT * …), and EXISTS(SELECT column …)

By

Is EXISTS(SELECT 1 ...) better than EXISTS(SELECT * ...)? Who would know better than...

ANSI_WARNINGS = OFF can break update statements with some SQL features

By

Working on a SQL 2017 database where an external, non-Microsoft application has direct access...

Read the latest Blogs

Forums

Deleting duplicate records with a CTE

By michael.leach2015

This code is modified from an example I saw.  The purpose is to delete...

Building Your Brand

By Grant Fritchey

Comments posted to this topic are about the item Building Your Brand

A Little Paranoia is Good

By Grant Fritchey

Comments posted to this topic are about the item A Little Paranoia is Good

Visit the forum

Ask SSC

SQL Server Q&A from the SQLServerCentral community

Get answers

Question of the Day

Auto Rounding

See possible answers