Azure SQL Database – Using sp_BlitzIndex
I was doing some normal activities on one of my Azure SQL Databases, I went to make a cup of...
2017-12-14 (first published: 2017-12-05)
1,686 reads
I was doing some normal activities on one of my Azure SQL Databases, I went to make a cup of...
2017-12-14 (first published: 2017-12-05)
1,686 reads
Yes, I like to blog, maybe slightly more on Azure than SQL Server. I enjoy it and it probably explains...
2017-11-28
353 reads
Naturally the cost of Azure SQL Database directly relates to what tier and performance level you are using. Starting from...
2017-11-23
479 reads
If you know about DBCC CHECKDB then most likely you will know about DBCC CHECKTABLE. Quite simply this command performs...
2017-11-20
436 reads
It’s good to be proactive and one way is to setup alerts and it is no different when using Azure...
2017-11-16
499 reads
TSQL Tuesday time hosted by Ewald (https://sqlonice.com/tsql-tuesday-96-folks-who-have-made-a-difference/) and quite simply one man has morphed me into who I am today...
2017-11-14
305 reads
I worked on testing interleaved execution with Microsoft back in January, I didn’t do much, just tested the functionality against...
2017-11-20 (first published: 2017-11-09)
837 reads
Let’s start off with a quick overview of SQL Server versions and compatibility levels.
100 = SQL Server 2008 and Azure SQL...
2017-11-06
485 reads
What? Is probably the most common reply out there and if it is then that is how I felt when...
2017-11-02
402 reads
I used to be on the fence regarding whether or not Automatic Tuning should be on as the default when...
2017-11-01
372 reads
Data isn't just about numbers and spreadsheets. It holds stories, patterns, and the answers...
By Brian Kelley
When I look at a system and think about its security model, the first...
On Wednesday May 15th 2024 I will give a free webinar on MSSQLTips.com about...
Comments posted to this topic are about the item The "ORDER BY" clause behavior
Comments posted to this topic are about the item Are IT Certifications Still Relevant?
I have table TicketNumbers i TicketNumber UID 2 10 09901a22c7c3acc6786847c775f1d113 6 5 00dad28bef21f916240d6e8c1c1bd67d 12 ...
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