Hi - Please see below my code for altering the table;

ALTER TABLE tbl_User

ADD FreeFieldValues NVARCHAR(MAX) NULL

Thanks, Russ

Thanks for the information Grant! I'm much clearer now on what needs to be done.

Thanks for the response guys!

Ok, thanks. Thought as much but wanted to double check. Thanks again!

Ok, great. Thanks

Thanks for the link.

I actually looked at it before creating a Topic.

I would like to know wheather it is 256 or 128 but the link does...

Hi there - I don't think there's a way of optimizing the UPDATE STATISTICS function, however database statistics should be updated automatically by default therefore any statistics which would benefit...

I'm assuming that the problem is intermittent as you mentioned long running queries effecting the connection more than slow running queries.

I came across a similar issue recently which...

Thanks a lot!

I thought this would be the case but wasn't entirely sure if you should not include a clustered index column in a nonclustered covering index. Thanks

Ok, thanks. As the data cache forms part of the buffer pool does this mean that setting the max memory does not strictly manage data but also the sql...

Thanks for that! I'll check them out.

You could run a trace, this will track what is occurring on the database around the time the user is reporting a performance issues.

However, for the CPU to peak...

Thanks all - The named pipes/TCP-IP solution hasn't worked and I can't see anyhting that's going to help me in the link but thanks for helping out!

Thankfully its...

Absolutely. Here is a section of logs once I start the service. (The db named instance is Duke)

Thanks. I've investigated a further and found the following error message; There is insufficient system memory in resource pool 'internal' to run this query.

I have calculated the memory...