These values are chosen arbitrary by the decision support department depending of the way the butterflies move through the window when it rains...

So they are randomly chosen from a combo...

Is no paging, simple:

I have 2 Tables: First one of 4000 rows. Users use them to filter the second table, much bigger.

They choose, almost randomly many of these rows to...

I didnt said they were consecutive, it was just an example. I have a 4000 rows table whose primary keys are used for filtering that way.

No 4000 columns... Only rows.

No.

Is not a simple list of integers, is a selection of 2000 primary keys over 4000 primary keys non consecutive and arbitrary from a table, in an arbitrary mode (too)...

Is a good aproach, but keeps a very big SQL when we reach the 2000 fields.

The problem: Users have a list of their shops, and choose between 4000 arbitrarily. No...

Do no seem to me a very elegant way to do it in comparison to DB2 but is a good start point:

As more fields, more alias...

select pvt.Vals from

(

select...

As a beginning...

First you should read this: http://www.microsoft.com/technet/prodtechnol/sql/2005/tsprfprb.mspx

To be sure you do not have any bottle neck in your system.

Then i'll start with SQL profiler, for example,...

I need to the new sintax of DBCC PSS. Sql server 2005 answers this to the DBCC:

Msg 2526, Level 16, State 3, Line 1

Incorrect DBCC statement. Check the documentation for...