SQLDIY: Index Usage Statistics
There are several different aspects of indexes that can be monitored via DMV’s. One the neatest things is just how...
2011-07-12
2,456 reads
There are several different aspects of indexes that can be monitored via DMV’s. One the neatest things is just how...
2011-07-12
2,456 reads
Next up, on the super SQLSaturday extravaganza, is SQLSaturday #80, in Wheeling, West Virginia! Wheeling, known as the friendly city,...
2011-07-12
992 reads
It’s so easy to make make mistakes with dates. Here is another one I saw recently, this one used when...
2011-07-12
565 reads
Starting this week on Wednesday night, I will be teaching a special five-week condensed version of ICT 4462, Transact-SQL Programming...
2011-07-12
611 reads
A few weeks back we wrote about a query to tell you which database is using up most CPU time....
2011-07-12
1,479 reads
I wrote this early in June, but lost it in my blog pile again and just found it…
First and foremost,...
2011-07-11
406 reads
Regular readers will now that I like to talk (quite a lot) about how we can be more effective as...
2011-07-11
1,420 reads
I have seen this question come up several times over the last few months. Can you delete from a view?...
2011-07-11
57,591 reads
I continued to check SQL Server 2011 “Denali” for few things I dislike on 2008 R2 and tried to find...
2011-07-11
605 reads
If you are using environment variables in SSIS when using package configuration, chances are you will run into a situation...
2011-07-11
1,852 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