If I remember, at the bottom, 3 main tables were used. Each one having around 7000 entries in each (at most 32k rows). So we were not talking about millions...

I've updated statistics on all tables and views and it didn't help.

I didn't saw the 3.5 billions row join in the plan. That's sure not helping the query!

What's sad (but...

Oh

This is the query I used to rebuild all indexes in the database:

USE DatabaseName --Enter the name of the database you want to reindex

DECLARE @TableName varchar(255)

DECLARE TableCursor CURSOR FOR

SELECT table_name...

From estimated execution plan, rebuilding indexes seem to help but the inner join query still have the issue while left join doesn't have.

Here's the zip file containing all estimated execution...

Hi Grant Fritchey

I'll do as you say and post both plan

I've gave it a new try with indexes.

All underlying tables had clustered index on their primary key. As the Microsoft rule of thumb it is their preferred place. (I know...

Colins

Inner Join returns only rows that exist in both tables satisfying the join condition

Left Outer Join return all rows from the left join table whether or not there are any...

None of these

First I've reloaded a backup of the DB, then I've requested an estimated execution plan with the original query using inner join and check it.

Second, I've reloaded the...

Still unable to find out what's the cause of the issue.

Am I alone with that strange behaviour?

Could this be a CAL limitation for Win 2k3 R2 ?

Anyone ever had this kind of issue?

Hi

Just a reminder that SQL is not a server to echange mail. What I mean by that is in some rare circumstances it can make hang the entire server /...

Thanks for the reply.

The service pack issue, to my knowledge, didn't installed successfully because DTC wasn't configured at all so none of the instance had a transaction coordinator available which...

Ok thks to all of you.

I think I understand.

There's only one tempDB per SQL Server instance cluster or not.

That tempDB can be divided into filegroups which then can be moved...

Inside the cluster, I'm having 2 active node and 1 passive node.

Each cluster node only contain 1 SQL Server instance.

If each SQL Server have it's own tempDB, how come can't...

Just to make sure, a cluster node = virtual instance?

Or I will have as many tempDB as active node is that so?

And what about other system databases? (master, msdb and...