SQL Server Free eBooks, Softwares, Tutorials and Websites
When we start working as developer or learning, we often
face this issue. Where is the best tutorials, books and other...
2017-04-10
266 reads
When we start working as developer or learning, we often
face this issue. Where is the best tutorials, books and other...
2017-04-10
266 reads
Requirement: Recently we got the information from management
that our project will be getting the customers from China, so our application
should...
2017-03-28
136 reads
In this article I will be listing the tips and tricks to work like
a Pro.
So let's get started –
Important keyboard...
2017-02-20
182 reads
I will be writing
this article in four parts because this topic is huge and the amount of
information can be overwhelming...
2017-02-06
540 reads
This is not an article or a script. I am posting this just to share my experience and I feel...
2017-01-30
876 reads
There are many situations when we want to know the size of our database tables or just need a list...
2017-01-19
673 reads
I will be writing this series of articles for the Special Indexes in SQL Server. In this series we will...
2016-11-11
488 reads
This
article is the part of series Mastering Index, in this particular article
we will be exploring Index on computed
columns. Take a look...
2016-11-07
529 reads
This article is the part of series Mastering Index, in this particular article we will be exploring Index with included...
2016-10-18
470 reads
This article is the part of series Mastering Index, in this particular article we will be exploring Unique Index. Take a...
2016-10-14
450 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...
By Kevin3NF
Can we normalize a couple of things? 1 – Trade Schools. Back in the...
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