GilaMonster (4/26/2016)

---

Grant Fritchey (4/26/2016)

---

I do not recommend this because it will seriously negatively impact your startup time, but if you really want it to immediately use the memory you allocate...

I doubt it, but all the...

info.sqldbamail (4/26/2016)

---

Thanks for your answer, one last question i would like to know is, if SQL Server like to consume whole available memory then why it is not consuming whole...

TheSQLGuru (4/24/2016)

---

5) The estimated cost of the plan is 3.84 yet it shows parallelism. That is crazy. What is your cost threshold for parallelism setting?? I note that the default...

In addition to what everyone else has already asked, I'd be curious about a couple of things about this query. The estimates are that it's processing 22 rows out of...

Your memory is behaving exactly as it's supposed to. As Kevin has said, your max might be a little high. Probably leaving 8gb for the OS would work better.

However, the...

On top of what Luis recommends, great selection by the way, I'd suggest getting a copy of Kalen Delaney's SQL Server Internals. That's a fantastic collection of in-depth information about...

You basically have to rebuild the query parsing engine within SQL Server. I know that there are people who have done this, but most of the time it's being used...

I've always written it as ...TableA JOIN TableB ON... adding LEFT/RIGHT as needed. Clarity suggests pretty strongly that you want the defining elements of the JOIN to be right next...

I don't think there are 10 decent tools in the market. Here are a few, in the order I'm recommending them:

Redgate SQL Monitor [/url](my employer)

SQL Sentry

Microsoft System Center

Solarwinds

Idera

Dell/Quest

That's what I...

Without more information, it's hard to say. Probably that's an adequate distribution for a very small set of memory (my laptop has 16gb of memory).

Instead of immediately focusing on...

"Dimmest bulb in the box" is also a good one.

I've always liked "dumber than a bag of hammers"

VSSGeorge (4/19/2016)

---

I am attaching the actual execution plan available.

The full execution plan is not available as an error message is encountered.

Msg 1105, Level 17, State 2, Line 61

Could not allocate...

glen_malcolm (4/19/2016)

---

That is fantastic, I shall be reading that in detail over the next few...