Tags » SQL Server

Transact SQL - STRING_AGG - Error - "Multiple ordered aggregate functions in the same scope have mutually incompatible orderings."

Background

Working on some Transact SQL code yesterday.

Ran into an error that was new to me.

Error

Error – Image

Error – Text


Msg 8711, Level 16, State 1, Line 80
Multiple ordered aggregate functions in the same scope have mutually incompatible orderings. 799 more words
Technical

Monitoring Identity Columns for Room To Grow

My friend pointed out an interesting RCA by Github where a database table’s auto-incrementing ID column exceeded . When we attempted to insert larger…

Monitoring Identity Columns for Room To Grow

Grouping Sets: How to group the data in a query

Hey folks,

This time I would like to teach you about how to group the data into different “Group by” sets. The “Group by” clause allows you to categorize the data into the selected grouping set of fields. 525 more words

SQL Syntax

Tidying up the SSIS Database

If we’re running SQL Server Integration Services (SSIS) then it’s database is the wonderful place where we store our packages ready for execution and the lovely logs we can interrogate when those packages inevitably break (of course not, our code is perfect, right?) 539 more words

SSIS

Bulk Restore Databases with SQL Server Always On Availability Group

Previously we demonstrate a simple example of how to restore just a single database on SQL Server with Always On Availability Group using Transact SQL. Now let’s use Transaction SQL to generate the script for bulk restore of multiple databases to SQL Server with Always On Availability Group. 875 more words

Sql Server

School of Hard Knocks: SQL Server, Storage Spaces Direct and Cluster Shared Volumes edition

While I work 100% with cloud based SQL Server deployments these days, my life is not all unicorns and PaaS services. Surprisingly (or not) enough, many of the environments in the cloud are still build on top of good, trusty virtual machines. 953 more words

SQL Server Administration

Backup Database using T-SQL Statements

Introduction

In this article, We will discuss how to backup our database in MS-SQL Server using T-SQL Statements.

We need to use BACKUP DATABASE statement to create full database backup, along with the name of Database and device to store the backup file. 44 more words

SQL Server