List of query processing errors in SQL Server 2005

For my own reference: http://msdn.microsoft.com/en-us/library/ms172350.aspx

Note to myself

Check the following post for responses:

http://social.msdn.microsoft.com/Forums/en-US/perfmon/thread/fc20f93d-8443-4f62-8d22-556eac66ba71

Update: While somewhat helpful, the MSFT didn't bother looking at my followup question and marked their own answer as the solution. Nice going.

New post to follow up on:

http://social.msdn.microsoft.com/Forums/en-US/perfmon/thread/db3d4e32-1f40-4c95-92a2-02a87649eb56

Well here's something new...

... a professional sound engineer switched using his Mac to another platform. "Why would anyone use Windows for sound?" I hear you say. Well, they don't. In fact he's switch to... Ubuntu Linux.

Check it out here:

http://createdigitalmusic.com/2009/08/04/linux-music-workflow-switching-from-mac-os-x-to-ubuntu-with-kim-cascone/

Speaking of sound on Linux, I found a good Intro to this topic here:

http://www.osnews.com/story/6720/Introduction_to_Linux_Audio

Guaranteeing order in views

In SQL Server 2005, using the TOP 100 PERCENT clause with an ORDER BY xxx doesn't gurantee that the results will be ordered by xxx. See this article for more info.

So what to do?

I believe that you can use the following syntax:

create view guaranteedOrderView
select xxx, row_number() over (order by xxx) as OrderNo
from exampleTable

NOTE: I've not tested this assumption. One of the extremely smart developers at my work told me that the optimizer might well... optimize... out this order.