It merely takes the complexity of the join out from the users.  That is unless you create an indexed(materialized) view, than things could speed up potentially.

Tom

I don't think it should be a speed issue, it's clearly a good design issue.  Creating multiple tables and a view over the top of that, makes the application more...

I think if you use something like the following a join is not needed.

select client,sum(servicex) as ServiceX,sum(servicey) as ServiceY from

(

select client,case service when 'x' then 1 else 0 end as...

Is the sqlserver running locally on your machine or just the application.  When was the last time you booted the Sql machine.  Did a configuration on the network change. full...

It is a save password checkbox on the link tables selection window.

Tom

It's been a while, but I'm pretty sure that when the tables are linked you have the option to store password information with that connection.  It's a check-box or something...

Is the auto-close dboption set.  Sounds like this could be your problem.

Thanks

Tom

I would test it to see if that is your problem.  Run your update, and then do not shrink your log.  Then run the update a second time and compare...

I did not fully process your original post, what I meant by trailing edge was the RevisionId field.

There's not much else but a clustered index seek that this query could do.  Try...

Is the State field the trailing edge of the index.  If it is then that is the behavior that you should expect.  Since it is using the front edge of...

How big is the transaction log on the table before you run the update and then after you run the update.  If you regularly are shrinking the transaction log and...

I would look at dbcc updateusage.  This could be the reason the result sets are different.

Tom

You have to add an N to the front of the variable.

set @varUser_Name = N'Brain Pregler'

set @varPassword = N'beer'

This is from books online:

"Unicode constants are specified with a leading...

To see a waiting process, I would look at what sid's are blocked.

eg. Select * from sysprocesses where blocked <> 0

The value in the blocked field is which spid...

Openquery uses the MSDTC which automatically wraps the statement within a transaction so setting the transaction isolation level will not work. It looks like you are locking yourself out with...