Comprehensive SQL Server Cheat Sheet: Basics, Advanced Queries, Administration, and Replication

This guide starts with fundamental SQL Server operations such as creating and dropping databases ( CREATE DATABASE database_name , DROP DATABASE dbname ), creating and deleting tables ( CREATE TABLE tabname(...) , DROP TABLE tabname ), adding columns, primary keys, indexes, and views.

It then lists essential DML statements for selecting, inserting, updating, deleting, and aggregating data, followed by advanced set operators (UNION, EXCEPT, INTERSECT) and join variations (LEFT, RIGHT, FULL OUTER). Grouping, ordering, and pagination techniques are also demonstrated.

Administrative commands for database maintenance are included, such as rebuilding indexes ( DBCC REINDEX ), shrinking databases and logs ( DBCC SHRINKDB , DBCC SHRINKFILE ), verifying backups, and repairing databases.

The article explains how to use linked servers and remote queries with sp_addlinkedserver , openrowset , openquery , and opendatasource to copy, query, and synchronize data across servers.

A complete replication setup procedure for SQL Server 2000 is described, covering preparation steps, publishing configuration, creating publications, and scheduling jobs with SQL Server Agent.

Finally, a sample synchronization stored procedure ( CREATE PROC p_process AS ... ) is provided to update, insert, and delete records between two databases, illustrating practical use of linked servers and distributed transactions.