Hi, I am using derieved tables and using left outer join with other tables. Can any one tell me if Left outer joins are faster than inner joins

Hi All, I am attempting to tune a stored procedure that is very slow when executed through an application. The problem is that when I attempt to run the stored procedure through management studio it does not return at all (or at least I have not been patient enough to see it return - it has been running...

Hello All! Im trying to figure out which variant of a query (subquery with EXISTS, subquery with IN, one overall join with group and having) is the best. I executed all three queries at once and display the execution plan. The first had query costs (relative to the batch) of 6%, the second 66%, the third...

It seems when I run the query with the set staticts IO on then statistic reports back with the 'work table', and the query takes 30+ sec. if the worktable is ommited(whatever the reason?) the query take less 1 sec. Here is my take, I believe work table is created in tempdb...and if not then whole...