I'll try and get the execution plan.

How does this look as a replacement;

CREATE PROCEDURE [dbo].[NIC_Main_SessionDB_SaveSession]

-- Add the parameters for the stored procedure here

@ID BIGINT,

...

Thanks for the replies. I think the overall design is terrible but likely the best I could do is try to improve the execution of the SP. Remember...

If anyone has a code example that would generate this command I would love to see it.

Thanks!

This is just the back end of a web application. I had read somewhere that this was the result of a command.parameters command in a .net application. Where...

This is exactly the answer I was hoping for. I plan on trying this out during off hours this week. Thanks for your response!

Thanks for all the info. We actually do run most of our SQL instances on VMWare. This instance is quite sensitive thus we following the vendors recommendation of...

Do you think there is a significant performance impact on the principle server?

Thanks for all the great advice. Definitely have some solid direction now!

Thanks Micheal! I thought I had to do the conversion but I understand now.

Sorry to confuse you - yes both are the same. I'm changing between environments and even confusing myself. Thanks!

Micheal that doesn't work for me because the column is a datetime column so I need a conversion to get only the date, unless I'm missing something?

IE the date is...

Thanks Grant,

I do understand that and the fact is in some cases we'll have to do a full scan. Do you think that storing the message in a separate...

I'm not trying to hide the query (I just didn't think it would help) - so here it is;

SELECT

b.sending_app,

b.service_name,

b.event_time,

b.message_type,

b.receiving_app,

b.direction

FROM [Message_Journal].[dbo].[Journal] b

WHERE CONVERT(DATETIME,LEFT(CONVERT(VARCHAR, b.event_time, 120),10)) >= '20100901'

AND...

There is no primary key.

There are non-clustered indexes on uuid, service_name, event_time,last_name and personid.

Basically any report that causes a full table scan takes a long time (around an hour last...

No problem at all - glad I could help.