Stairway to T-SQL DML

Stairway to T-SQL DML Level 4: The Mathematics of SQL: Part 1

A relational database contains tables that relate to each other by key values. When querying data from these related tables you may choose to select data from a single table or many tables. If you select data from many tables, you normally join those tables together using specified join criteria. The concepts of selecting data from tables and joining tables together is all about managing and manipulating sets of data. In Level 4 of this Stairway we will explore the concepts of set theory and mathematical operators to join, merge, and return data from multiple SQL Server tables.

Free eBook: SQL Server Backup and Restore

In this free eBook Shawn McGehee offers advice on query tuning, cutting stored procedures, and system process design and implementation for high availability. Discover how to perform backup and restore operations using SQL Server Management Studio (SSMS), basic T-SQL scripts and Redgate's SQL Backup tool.

Introduction to the Cosmos DB Emulator

Cosmos DB delivers a wide range of advantages over traditional SQL and NoSQL-based data stores, including support for multiple consistency levels, latency and throughput guarantees, policy-based geo-fencing, automatic scaling, and multi-master replication model. However, it is a significant departure from the traditional database management and development approach that most database administrators are familiar with. Discover the offerings that you can use at no cost to gain hands-on experience with Cosmos DB.

Blogs

Strategies for Compliant Development Down Under

By

I’m doing a tour of Australia and New Zealand with our SQL in the...

T-SQL Tuesday #114 Puzzle Party – Roundup

By

Here’s my round-up for this month’s T-SQL Tuesday. Thanks to everyone who contributed last...

Do you have rarely used indexes that are hurting performance of writes?

By

We know that indexes are necessary for query performance but comes with overhead during...

Read the latest Blogs

Forums

The Change Failure Rate

By Steve Jones - SSC Editor

Comments posted to this topic are about the item The Change Failure Rate

SQL Server Error mtlog.cpp

By Hamid-Sadeghian

Hi all We are seeing frequent error messages like this: "[WARNING] === At least...

What are the new distributions of bounty hunter rewards in 2019?

By chengzi524

Sometimes the best change is to remove content altogether. In the past few months...

Visit the forum

Ask SSC

SQL Server Q&A from the SQLServerCentral community

Get answers