Hi! I have a join which looks something like this: SELECT ... FROM @memberselection t INNER JOIN order o ON o.member_id = t.member_id INNER JOIN transactions t ON t.order_id = o.order_id For a large set in @memberselection this takes forever. For a selection of about 1000 members, it takes 30 second...

I have the following script: DECLARE @ConsultantID AS nVarChar ( 50 ) , @PeriodDate AS DateTime SET @ConsultantID = '0000344' SET @PeriodDate = '12-01-2007' -- Declare Local Variables Declare @MonthStartDt As DateTime DECLARE @MonthEndDt AS DateTime DECLARE @QuarterStartDt AS DateTime...

Hi, I have a stored procedure which is doing a select joining several tables based on certain conditions.There are two left outer joins and the rest are inner joins. We are using SQL Server 2000. The problem is that this particular procedure is taking unusally long time (10-12 mins) to execute in the...

I have a table with more than 50,000 records in SQL server 2000 without any index or even primary key on any column. Now i have identified two columns which are together unique ( say- empid, projectid) for the table. Now if i create a clustered index on the above mentioned columns, then my table scans...