IBM used to look specifically for music majors to hire them as developers. It might be worthwhile to ask them about that policy.

I think it has a bit to do...

athurgar is right. Create a clustered index, then drop the index to return it to heap status.

------------------------------------

create clustered index CookieMonster

on

go

drop index CookieMonster

go

------------------------------------

I agree, the varchar(1) is useless, because it has provisions to handle nulls. Besides it doesn't sound like they are too concerned about the SQL server side of things.

If you...

Yea, I'd agree with all of the above. My thoughts are to create a table / temp table that you can populate with the 25,000 ids, then use a subquery...

Unlike other RDBS, SQL handle row structure and storage for you. It looks at the datatype makeup that you've requested and then physically stores the rows in an efficient manner....

Yep. When I was teaching SQL classes I used to tell the class that one thing that irked me was that Enterprise Manager (EM) is not so good at refreshing....

I agree with Andy. I admire your ingenuity, but there's no need to duplicate MS's efforts when they offer you a tool to do just that. The SQL Profiler can...

Another option would be to wrap it all up as a subquery where the outer query does the summing. That'd be my first reaction.

However, this would no doubt be less...

I feel your pain. I tried to do that too at one point. I had an SP create a temp table, then try to populate it in a different SP....

I'm going to side with everyone here about the "put it in a string" line of approach. However, allow me to add something. If you have a limited number of...

I'd give a nod to what PhillCart said. However I'd add that for me it is largely a question of performance.

SPs give the best performance of the three objects of...

If I am not mistaken, there is a script to promote the secondary to the primary, and there is also a script to demote the primary to the secondary. It...

Believe it or not, there is some evidense that 4 cpus is optimal for SQL. I believe Gartner Group may have some data on this, but the jist is that...

Remember that you can have up to 249 non-clustered indexes on a table, and 1 clustered.

Assuming that the Clustered is already taken, a separate index on all three of the...

You may hate this answer, but it will work.

If you are not in a production environment, or can get your data to server that is not crucial, you an stop...