I deem September 2011 – SQL Server Month
If you haven’t visited the SQL Saturday website you should take a look. There are SEVEN events planned during September around...
2011-08-02
548 reads
If you haven’t visited the SQL Saturday website you should take a look. There are SEVEN events planned during September around...
2011-08-02
548 reads
Are you tired of doing self joins, just to get the value of a column in the previus/subsequent row, or...
2011-08-02
1,697 reads
Last month, I started using Meetup to schedule SQL Server Study Group events. The idea is to meet twice a...
2011-08-02
933 reads
Oh no you, you got the Could not load type ‘Microsoft.AnalysisServices.SharePoint.Integration.ReportGalleryView’ error!!! What to do now? Why did you get...
2011-08-02
1,049 reads
SQL FUNCTION: -
Function in a database can be defined as the code segment consisting of a logical group of SQL...
2011-08-02
2,949 reads
Since it is August 1, 2011 (which is also my birthday), I thought it would be a good time to...
2011-08-01
1,017 reads
Interesting topic this month posted by Thomas LaRock. This month he has chosen “crap code” as the topic. I think...
2011-08-01
781 reads
Interesting topic this month posted by Thomas LaRock. This month he has chosen “crap code” as the topic. I think it is interesting because there really are so many...
2011-08-01
1 reads
Whether it is Transact-SQL for applications you are developing, or just for routine administrative tasks, managing Transact-SQL has never been...
2011-08-01
820 reads
I might send this to a VP or CIO: Global CIO: A Framework For Developing Technical Leaders. It’s an article...
2011-08-01
1,377 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