If anyone is still following this thread, a related question. If I want to use the MAXDOP query hint but set it dynamically, is there a way to tell...

Thanks for the update. It's proved to be useful many times for me.

That'll teach me to read the question a little more carefully. Of course, then we couldn't have had a fascinating discussion on AWE and Lock Pages in memory. ...

I think what people should take away from this is that you want to get the memory settings on 64 bit correct; set Min/Max memory, and lock pages in memory....

Cliff Jones (1/11/2010)

---

Again, in order to use these APIs, you must have the 'lock pages in memory' privilege set. This is why for 64bit systems, you don't need to...

Did you read the blog post from the CSS SQL Server group engineers? The AWE switch is NOT ignored and it is recommended as a best practice. Here...

The answer is incorrect. AWE can be used in 64-bit and some people recommend that it should be set because it helps SQL Server manage memory by not allowing...

This is the error message being returned:

Column, parameter, or variable #1: Cannot find data type PROVIDERS.IMREPROV_CODE.

Column, parameter, or variable #3: Cannot find data type LOCATION.LOCATION_ID.

Parameter or variable '@aCaregiverId' has an...

When I posted the original problem I said that the problem I identified was part of a much larger query but that I had isolated it to a specific view....

Yes, I'm planning on attending the data camp and I hope to see you there.

I am familiar with the issue that Gail raises about "cursors in disguise". It's a...

Grant,

Thanks for stimulating the brain cells. In short, the subquery that you pointed out was the problem and the view just wasn't going to get it done. I...

Thanks for the link to the guidelines. That was helpful.

I've already posted the query. I've attached a zip file with the three table definitions and the view definition...

I have the book on my desk. I also have had the pleasure of speaking with Grant and hearing him speak at the New England SQL Server User Group...

Mauve (12/10/2009)

---

Re: A clustered index physically rearanges data on disk.

Technically, the use of the word "disk" is wrong. It rearranges data within the (SQL Server) pages and extents. ...

My page 311 paragaph 1 says something different than your page 311 paragraph 1.

Mine says: "...This order is maintained through a doubly linked list called a page...