DBCC CHECKFILEGROUP
Well, with the name “blobeater” it was about time I did another post on CHECKDB. This time I want to...
2016-09-14 (first published: 2016-09-13)
1,217 reads
Well, with the name “blobeater” it was about time I did another post on CHECKDB. This time I want to...
2016-09-14 (first published: 2016-09-13)
1,217 reads
Recently I have been creating many Azure SQL databases via the portal where I started to find it quite tedious. So...
2016-09-14
509 reads
It is really easy getting insight into Query performance within your Azure SQL DB. I think Microsoft have done a...
2016-09-12
753 reads
I was going through some online courses and came across Erin Stellato’s Course on DBCC commands.http://www.sqlskills.com/blogs/paul/new-course-understanding-and-using-dbcc-commands/ I learnt something new!...
2016-09-09
540 reads
Running the usual consistency checks on a database (with a new release code applied from an ISV) I noticed slower...
2016-09-01
399 reads
I was having a conversation with someone over a disgusting vanilla latte and we talked about shutting down a machine...
2016-08-25
183 reads
I am going to show you why you should be using checksum options on your backups (and restores). I AM...
2016-08-11
198 reads
2016-08-05
180 reads
There isn’t really a need to do what I am doing in this blog post but I guess one reason...
2016-08-03
194 reads
There are many ways to migrate an “earthed” SQL Server database to Azure, for this article I want to show...
2016-08-02
215 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