If you could post the execution plan, that would be a big help.

You do realize that NOLOCK could lead to missing or duplicate rows.

Nothing jumps out of the query as...

That memory is not an issue....

There is an older book available from Redgate called The Guide to SQL Server Team Development[/url]. It's free to download. It has a chapter on coding standards. The rest of...

So other people who will find this in the future and read it know, how did you solve the problem?

benjamin.reyes (11/23/2015)

---

Grant Fritchey (11/23/2015)

---

I'm pretty much with Gail. Just because it says it's using 98% of memory doesn't mean there's anything approaching a problem.

If you do know that the batch...

I'm pretty much with Gail. Just because it says it's using 98% of memory doesn't mean there's anything approaching a problem.

If you do know that the batch is a problem,...

So it's a giant batch process. You could try breaking up the batch into smaller pieces. It might run longer overall that way, but it'll use fewer resources while it's...

IO Latches are about reading and writing to disk. It's...

Brandie Tarvin (11/20/2015)

---

Nothing like staying up late two nights in a row to do releases, get called back ten minutes after the second release to be told I forgot to...

GilaMonster (11/19/2015)

---

I once...

Hard to say for sure without a lot more detail, but it looks like you have a server with some memory stress which is leading to timeouts with your Availability...

Except in the case of the OUTER JOIN as the other posters have outlined, there is no fundamental difference under normal circumstances. For the sake of clarity, I would advocate...

shamshad.ali (11/18/2015)

---

I have a sample table with following structure:

CREATE TABLE [dbo].[RTable](

[Id] [int] IDENTITY(1,1) NOT NULL,

[Amount] [int] NULL,

[DateRange] [date] NULL,

CONSTRAINT [PK_RTable] PRIMARY KEY CLUSTERED

(

[Id] ASC

)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE...

Adi Cohn-120898 (11/18/2015)

---

If what you are interested in is only performance, then I would suggest using sequence instead of identity and also use the return code or an output parameter...

But PLE is not a measure of performance. It's merely an indication of load and behavior. Having low or wildly variable PLE is not, by itself an indication of a...