Articles

UNION vs. UNION ALL in SQL Server

Sometimes there is a need to combine data from multiple tables or views into one comprehensive dataset. This may be for like tables within the same database or maybe there is a need to combine like data across databases or even across servers. I have read about the UNION and UNION ALL commands, but how do these work and how do they differ?

2019-12-05

It's More Than What You Know

I'm a firm believer in keeping your tech skills up to date, as well as your social skills, What better way than attending or presenting at a conference or group meeting. The reason to attend an event I'm very fortunate that my company allows me training days and time for personal development, covering all expenses […]

2019-12-03

1,656 reads

Blogs

Data Lake Architecture using Delta Lake, Databricks and ADLS Gen2 Part 4

By

This is the fourth and final post in a series about modern Data Lake...

SQLOrlando 2019

By

We just had our final event of the year and looking back, not bad...

Read the latest Blogs

Forums

services not list in sql config mgr

By vsamantha35

Hi All, On one of the sql server machine, when I open the sql...

Query Slow Result

By immaduddinahmed

hi , i getting result of query 65954 rows its take 20 seconds how...

Convert nchar to time and addition functionality

By Rock

I have a scenario: I have a nchar field which is tagged as start...

Visit the forum

Ask SSC

SQL Server Q&A from the SQLServerCentral community

Get answers