SQL Server “Denali”: Distributed Replay
Replaying multiple threads of a captured trace in SQL Profiler is difficult, and you are limited to replaying the workload from...
2011-08-10
1,576 reads
Replaying multiple threads of a captured trace in SQL Profiler is difficult, and you are limited to replaying the workload from...
2011-08-10
1,576 reads
For those of you who use MDX, I’m sure you share my opinion that MDX is a lot harder to...
2011-08-08
773 reads
I take it for granted that everyone knows all about Microsoft certifications and Microsoft MVP’s. But a few years ago,...
2011-08-05
1,632 reads
As a consultant or contractor, many times the client we are at does not provide us with a laptop, so we must...
2011-08-03
1,219 reads
Project Apollo is a new feature in CTP3 of SQL Server Denali that enables a new columnstore index that offers...
2011-08-01
1,652 reads
Here is a tip that could make you much more productive: At home, I have a desktop computer with dual-monitors...
2011-07-29
2,282 reads
Here is a got-ya that happened to me. In SQL Server I want to generate a script of all the...
2011-07-27
9,080 reads
Here is a common got-ya. You are modifying the cube dimension security for a role-playing dimension. You make the changes and...
2011-07-25
2,021 reads
“vNext” is the codename Microsoft has chosen for the next version of the Visual Studio.
A big feature is improving the application lifecycle management...
2011-07-22
705 reads
According to the post SQL Server “Denali” Experts–We Need You! that asks for your feedback on the Microsoft certifications for the...
2011-07-20
1,712 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