Tag: Microsoft SQL Server 2019

How do I compare and synchronize two databases in Microsoft SQL Server?
 

How do I compare and synchronize two databases in Microsoft SQL Server?

In this material I will show you how to compare two databases in Microsoft SQL Server with the possibility of further synchronization, while showing a simple way that does not require writing complex...

How to make SELECT COUNT(*) requests very fast
 

How to make SELECT COUNT(*) requests very fast

When you run SELECT COUNT(*), the speed of results depends largely on the structure and settings of the database. Let's do a survey on the Votes table in the Stack Overflow database - 300 GB version...

Cool hints of requests
 

Cool hints of requests

Cool hints of requests - SQL Server documentation contains a pretty cool list of query hints: But what is the color box? Let's see.Since SQL Server query optimizer usually chooses the best...

SSAS - SQL Server Analysis Services: Server OLAP Tools
 

SSAS – SQL Server Analysis Services

Microsoft SQL Server Analysis Services (SSAS) provides interactive analytics processing (OLAP) and intelligent data analysis functions for business intelligence applications. Analysis Services...

SSIS - SQL Server Integration Services: Description of integration services
 

SSIS – SQL Server Integration Services: Description of services

SSIS: Microsoft SQL Server includes the SQL Server Integration Services component, and today we will learn what this component is for and take a look at its main features.As you probably know,...

Microsoft SQL Server 2019 - all its advantages
 

Microsoft SQL Server 2019 – High availability and advanced analytics for all your data

SQL Server 2019 - advanced security and compliance mechanisms, industry-leading performance, high availability and advanced analytics for all your data, and now support for working with large...

SQL Server - is a relational database management system (RDBMS)
 

SQL Server – is a relational database management system (RDBMS)

Microsoft SQL Server is a relational database management system (RDBMS) developed by Microsoft Corporation. The main query language used is Transact-SQL, developed jointly by Microsoft and...