Hi,

This has...

Thanks for the reply Chris.

I see what you mean, I've modified the query, the execution plans show a marked performance increase which is good.

Guess I'll just see what happens this...

Hi,

Thanks...

Thanks for the reply.

You point on workload is valid.

Regards,

Nic

Hi,

Thanks for the SELECT.

I've picked out a time where the 'RESOURCE_MEMPHYSICAL_LOW' is raised in the ring buffer (process - 2, system 0) under the buffer type 'RING_BUFFER_RESOURCE_MONITOR'

I've then gone through...

GilaMonster (11/29/2012)

---

Nic-306421 (11/29/2012)

---

I can't remember where I read it, but I thought the 'Process_Indicator' flag - which is 2 (sorry should have mentioned that) indicated its something within SQL Server...

Hi,

This is where I have read about it;

http://blogs.msdn.com/b/psssql/archive/2009/09/17/how-it-works-what-are-the-ring-buffer-resource-monitor-telling-me.aspx

Although re-reading it, my previous post was incorrect, I now take it to me;

IndicatorsProcess - 2 - This is the RESOURCE_MEMPHYSICAL_LOW...

Hi Gail,

Thanks for the response.

Regarding the machine, it has 3GB in it at the moment, this instance is set to 1GB max and there is another instance which is also...

Toreador (8/10/2012)

---

and then select the wrong options anyway, even though you know...

"This is an opportunity to learn new/different thing and your answer will never be wrong if you read the related subject first. "

I dont think I would agree with that...

Hi,

Yes, I think you should be able to do this using a GROUP BY, if you are not familiar with that then there are loads of good examples on the...

Hi,

Managed to resolve this one.

Turned out to be a space after one of the SPN entries that was causing it to not be found and therefore go to NTLM.

Drop and...

Hi,

I'm not sure exactly what you are asking but I think you are refering to a 'GROUP BY', check out BOL and see if that's what you are after.

If not...

A great questions, got me thinking so well worth it.

Thank you.

Hi,

Perhaps I'm not understanding correctly, but you should be able to take your pick of;

Identity columns - Your table can increment itself automatically.

ROW_NUMBER - You can assign a row number...