Well, as I research the issue further, I am beginning to agree with all of you. RCSI is not going to help, and it just might make things worse.

I'll...

You seem to be trying to embody the good coding practices of encapsulation and reuse in your SQL code.

I won't say it can't be done, but that is very hard...

Gianluca Sartori (12/28/2011)

---

NOLOCK? :sick:

With RCS enabled writers don't block readers. Is this the kind of concurrency issue you're trying to address?

As far as the dangers is concerned, you could read...

This is an extremely bad idea - for very large values of bad. :w00t:

Please review this article: http://www.sqlmag.com/article/sql-server/what-are-your-nested-views-doing-

Then review this forum discussion: http://www.sqlservercentral.com/Forums/Topic1224077-391-1.aspx

You are making a serious mistake.

Sigh. :pinch: Where shall I begin? We have concurrency issues. (The root cause of these concurrency issues is poor design, but that - alas - is water under...

You know, I was just reviewing your code, and I have to ask: Is TableX, by any chance, a VIEW?

I have a hideous number of atrocious views in my...

I've been doing some research on Read Committed Snapshot Isolation myself. I was just asking about possible problems with it on Twittter (#SQLHelp), and I was given several articles...

:blush: It's one of those things I keep telling myself I should do.

I'll make it a New Year's resolution. 🙂

OK, now let me take a stab at answering your MERGE question. The example that I am going to use is taken from a blog post by Pinal Dave,...

You are really asking two questions: one about the MERGE statement and one about CTE's. I'll try to address your question about CTE's.

Common Table Expressions (aka CTE's) are...

I feel that the best way to start learning about SQL is to get a good book, install SQL Server on your home system and work through the examples on...

Heh. I'm glad I'm not the only one! 😉 Once...

Very cool query, Mr. Russell. I did not know you could do that. The only problem in applying it to this particular problem is that the transactions he...

Does it seem wrong to anyone else that...

Ah, very cool! I'll have to try out the Performance Dashboard. I can think of some other reports I'd like to add, too.