Yep, that should just about do it.

Absolutely not, there's a whole load of things that you can look at for query turning.

indexing only takes you so far, a badly written query will always be slower than...

lol

I agree with Remi, it takes years of experience and even then you're only just scratching the surface.

If you're interested in a book then I can recommend 'inside SQL server'...

Yes, that's exactly what I mean, you can enable this setting in query analyser by clicking on the Query menu and selecting show execution plan, you can also do it...

Without wanting to sound harsh, I'd suggest that the first steps towards query tuning must be to learn how to use TSQL and understand the query plans that get generated.

You...

Can you tell us what indexes you already have on the table please? clustered, non-clustered, that will give us a little bit more info to go on.

definately not a mind reader, especially not with my twin blonde swedish au-pairs

People, People, People, you're not thinking smart enough

I'd have to go for a sweedish au-pair if I could only employ one person, or...

Thanks for the offers and suggestions, in the end i managed to get enough time to look at it myself and fixed what was up (which is what I should...

If its comming from a web app then stored procedures are definately the way to go, just make sure that you build in sufficient safeguards to prevent sql injection attacks.

Why on earth would you want to create a seperate database for each user, I don't know how many users you have but as the numbers increase the amount of...

We've got round 30 SQL Servers, ranging from single processor Development servers right through to clustered Itanium 2 boxes in production.

As for the article, I'd love to get a look...

Absolutely, use virtual servers for QA environments or when you want to test how something works in a cluster and can't afford to buy 2 new servers to do it.

Virtual...

Yep, we're coping quite well, our SAN is more than up to the job so long as we keep adding extra storage and partitioning the data properly.

I might get round...