All assembly information is stored in the following system tables: sys.assemblies and sys.assembly_files

Just a small remark: system catalog views, not tables. SQL2K users should not confuse them with the system...

We can't possibly give any good answer with this information. Which version of SQL Server 2005 have you installed? What tutorial book are you referring to? Where did you install...

Ok, then I was slightly incorrect in stating that 25000 bookmark lookups where done. Since so many lookups would be necessary SQL Server instead chose to do a clustered index...

Because for each of the 25000 rows that have PostWordSortOrder = 2 a bookmark lookup is needed. The results for the first 2 queries can be created and returned by...

First, what version are you installing. Beta 3 is not an edition of SQL Server 2005. You should clean the system entirely. Then install SQL Server 2005 June CTP, including...

Remi, what is 15 users? Total number of users of system of concurrently executing queries? If you are on a tight budget I would release with SQL Server 2005 Express...

Absolutely, use the MSDN SQL Server forums. It is not an official channel, but there are lots of MS guys reading.

Yes, I noted some copy-paste errors in my suggestion. This query should work:

SELECT sum(draw) as tot_draw , sum(returns) as tot_returns,

sum(returns + short + notdeliv + damaged) as unsold,

sum(draw-returns-short-notdeliv-damaged) as Netsale,

case...

I gave you an example above for the % sale column. If you need more, please post the DDL (your table schema), some sample data and the expected results.

SELECT * INTO newtable FROM oldtable

Sorry, no good answer for that I'm afraid. But I would probably guess it is more of a side-effect.

Parallellised queries can show up as multiple rows in sp_who2. I have experienced that DBCC commands often do this.

Well then you need to decide what to do when the divisor is 0. For instance, you could test:

case when draw / sum(returns + short + notdeliver+damaged) AS '%sale' =...

One alternative is to use this entire query as a derived table and then select the columns from that, including a new column that can reference draw and unsold.

Another option...

Yes, definitely a bug in sp_who2. You can do EXEC sp_who2 '55' to filter the output so you get only activity for spid 55, but not filter on the login...