I have tried both.

I don't think you're quite getting it.

Answer this question, please - how much memory do you believe SQL Server is using and where are you seeing this information?

His lack of an issue is the issue. 🙂

Ok, to reiterate David's comments, the memory never really "deallocates" from usage. This is by design. When you first fire up SQL Server, the memory allocation will slowly grow to...

So the problem is not that it's using up 90% of the system memory and not releasing it, the problem is that it's using up more than 2.0GB, as you...

I hate these types of responses, but how are you certain that it's the query that's causing something to be written to that volume?

Alright. Educational session in understanding what a PK constraint actually is today. Thanks a lot.

Thank you.

Ok, and the bulk of the time required for creating the constraint is creating the enforcing index? Alright, makes sense. Thank you, and thank everyone else on this thread.

Ok. You're right, of course. That's obviously what happened in my test environment. But riddle me this - why was it that it took me only 20 seconds to add...

Oh wow. I didn't realize that. To be perfectly honest, I'd never created a PK constraint in this fashion before, so I just assumed that the index that was created...

What do you mean when you say "enforced?" No, the clustered index is not unique.

I think I may see what you're getting at. Are you saying that when you...

I thought that the ONLINE specifiers were for indexes only. I'm only talking about a constraint. There's already a clustered index on the table and I don't want to change...

Yeah, like I mentioned in the original post, this table is part of our live website, which gets millions of hits a day. For it to be down/offline for 5...