2015-07-22
1,244 reads
2015-07-22
1,244 reads
Hi friends, today we will continue with Query Store in SQL Server 2016. In previous blog we learnt about what...
2015-07-17
1,097 reads
Hi friends, in next few blogs we will explore another new feature named Query Store which gets introduced in SQL...
2015-07-16
700 reads
Hi friends, today we will learn another new feature Live Query Statistics which gets introduced in SQL Server 2016. It’s...
2015-07-14
689 reads
In release of SQL Server 2016 CTP 2.0 another new feature that is released is Dynamic Data Masking. Using Dynamic...
2015-07-09
588 reads
Hi friends, we will continue with FOR JSON clause in this blog and today we will learn formatting of query...
2015-07-06
355 reads
Hi folks, Today we learn how to format query using FOR JSON clause with INCLUDE_NULL_VALUES option in SQL Server 2016....
2015-07-03
337 reads
In previous blog we learnt about changing query format using JSON clause with AUTO mode option. In this blog we...
2015-07-02
375 reads
Hi friends, in release of SQL Server 2016 CTP2 one of the feature that introduced is JSON clause. So first...
2015-06-30
890 reads
Hi friends, today we will discuss about new performance monitoring system Extended Events which gets introduced in version SQL Server...
2015-06-27
746 reads
By Steve Jones
I love Chicago. I went to visit three times in 2023: a Redgate event,...
By Brian Kelley
I have found that non-functional requirements (NFRs) can be hard to define for a...
You can find the slidedeck for my Techorama session “Microsoft Fabric for Dummies” on...
Testing with AG on Linux with Cluster=NONE. it was all going ok and as...
Hi, I have two tables: one for headers with 9 fields and another for...
We're trying to understand how quick new versions of SQL server can be. Obviously...
Let’s consider the following script that can be executed without any error on both SQL Sever and PostgreSQL. We define the table t1 in which we insert three records:
create table t1 (id int primary key, city varchar(50)); insert into t1 values (1, 'Rome'), (2, 'New York'), (3, NULL);If we execute the following query, how will the records be sorted in both environments?
select city from t1 order by city;See possible answers