Activity Monitor in SQL Server 2008: an Embedded Optimisation Gizmo for the Thrifty DBA
As promised back in December ‘08, after having spoken briefly at SQL teach here in Montreal thanks to MVP Paul...
2009-04-09
1,767 reads
As promised back in December ‘08, after having spoken briefly at SQL teach here in Montreal thanks to MVP Paul...
2009-04-09
1,767 reads
If you are planning a move to SQL Server 2008, although this process can apply for many Database Migrations, perhaps...
2009-03-31
4,813 reads
Starting the summer 2002, for about a year or so, the team and I embarked on a project to develop business...
2009-03-19
967 reads
In response to former Quebec Premier Bernard Landry’s comments of this past week regarding the posting of Michael Sabia as...
2009-03-15
4,318 reads
Yesterday evening I gave a talk about Grouping Sets in SQL 2008 thanks in part to the original front-page blog post...
2009-03-13
641 reads
The continuity of operations during a disaster is as critical to running a business as just about anything. Somewhere, within...
2009-02-28
2,277 reads
I diverge a little from the typical coding-based/oriented best practice to one that is focused on governance within public or government organisations...
2009-02-15
7,839 reads
As reporting requirements increase, it seems that aggregate functions have thankfully risen to the occasion concurrently. To maintain its competitive edge...
2009-01-28
2,667 reads
(1linerForward) I originally wrote this in French while working at LaCaisse.com - http://dbhive.blogspot.com/2008/07/fichiers-journaux-de-transactions.html
Why do you care, as a DBA, or a Developer...
2009-01-17
7,515 reads
One of the great new features in SQL 2008 is Row and/or Page Compression. Plus, still good news for those...
2009-01-02
1,736 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