TSQL

SQLServerCentral Article

Getting started with the SQL MERGE statement

  • Article

This article is focused on beginners who have already started writing SQL queries and are now diving deep towards more data processing and complex queries in SQL. When we talk about data processing, an important concept that comes to our mind is performing ETL workloads to a data warehouse. ETL is a very complex topic […]

4 (1)

2021-01-26

4,130 reads

SQLServerCentral Article

Collections

  • Article

Problem The usage of a collection of integers in some scenarios is considered to be optimal because of the overhead involved by the creation of another user table used just to store numbers, which is the most common solution. What are collections of integers? They are lists or arrays consisting of integers. The number of […]

3.13 (8)

2020-02-13

5,911 reads

Blogs

Flyway Desktop Projects for My PoC

By

In a previous post, I set up the basic databases for the PoC project...

Daily Coping 30 Jan 2023

By

Today’s coping tip is to plan something fun and invite others to join you....

Migrating or Recovering a TDE Protected Database 

By

When encrypting a database with Transparent Data Encryption (TDE), a vital consideration is to...

Read the latest Blogs

Forums

migration

By sqlguru

Has anyone migrated databases from on premise SQL Server to Azure Managed instance? If...

SSRS REPORT

By RDOT

am getting the following when run report what can I do to fix this

This code works, but am requesting help with the code.

By Doug

Hello everyone.  I don't post here often even though I am constantly on the...

Visit the forum

Ask SSC Logo Ask SSC

SQL Server Q&A from the SQLServerCentral community

Get answers