SSIS Fuzzy Lookup Error
A Fuzzy Lookup Task in SSIS that I was working on was bombing out, and I had a heck of...
2011-06-13
1,658 reads
A Fuzzy Lookup Task in SSIS that I was working on was bombing out, and I had a heck of...
2011-06-13
1,658 reads
Ever get a timeout error when using the “View History” for a SQL Server Agent job? I find this happens...
2011-06-10
4,325 reads
BIDS helper is Visual Studio add-in with features that extend and enhance the functionality of the SQL Server 2005 and SQL Server...
2011-06-09
756 reads
Virtualization is becoming a hot topic lately, and there is no doubt it provides a ton of benefits. But you...
2011-06-08
1,092 reads
Interesting video on eWeek.com called Business Intelligence Takes Higher Education Students to the Head of the Class that talks about...
2011-06-07
1,219 reads
A fantastic white paper just released: Microsoft EDW Architecture, Guidance and Deployment Best Practices.
It’s a must read if you are...
2011-06-06
1,092 reads
While there is no way to use a source control system such as Team Foundation Server (TFS) or Subversion with PerformancePoint...
2011-06-03
909 reads
A Windows 8 demo was just released. Looks really cool. Check it out at Previewing ‘Windows 8’ as well as Microsoft’s...
2011-06-02
661 reads
One item on my PerformancePoint wish list is the ability to change a datasource for an Analytic Chart/Grid. There is...
2011-06-01
805 reads
I have been compiling a list of what things a person can do to become an expert, or guru, in...
2011-05-30
5,062 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