I'm interested in how you have memory configured ?  if you run sp_configure what does it return for min and max memory. I used to be ok with the 3gb...

No offence to Deborah, but I figured out how to do this almost at once with sql 6, and I'm sure several books have routines for this, surely most script libs...

don't mess with the server memory settings, use dynamic memory only with the 3gb switch. Only set memory config if you have problems or using awe.

Standard edition ( 2000 )...

an understanding of relational database design would be useful, I'd suggest a training course or a good book on T-SQL.

why not use the native sql tools? For help with a third party tool contact the supplier or see if they have a forum on their site.

I'm not sure if I'm reading this right  but do you want to pass a delimited string that you want to use as an IN statement for a select?

IF so...

I suggest a good bookstore! BOL and microsoft technet and msdn have loads of information.

haven't we done this one already in the last few weeks?

I bet that query will not scale.

agreed - tuning is a bit of a black art - I've just tuned a query on a dev box ( as one might expect ) and when deployed to...

using views to mask underlying tables/complexity is valid although rarely performs very well, adding a hiearchy of views over that will rarely perform well at all. No doubt you'll get...

why on earth would you want to do that?

a fill factor of 70% could increase your scans and cause excessive i/o with selects. I figure you'll have to profile to see the nature of your queries and see....

It's not good to try to compare databases ( especially not the same ) running on different operating systems or database versions. That sp4 gave a problem fine - that's...

you couldn't probably choose a worse front end - can't say that I would expect to be able to compare quereis in qa vs queries in access ( it can...