I'm not sure I want to create a "compendium" like I did for Spry, with the care and feeding I've given that so far. Clearly, this entry's links could grow dated over time, or could use new additions. Please add updates in the comments below. Let me know if you find this helpful.
First, I'll note that there was a CFDJ article in April, "Version Control Using Subversion in ColdFusion".
Also, Matt and Pete did a a whole episode of the ColdFusion Weekly Podcast on version control, and included considerable (and glowing) discussion of Subversion. Go to the archive page and find show 1.6beta from May 1, 2006.
Cameron Childress has done a presentation on it, and shared it and some other thoughts in a couple of blog entries.
Shlomy Gantz did one at CFUnited as well, and is offering it on his blog.
Pete Frietag has done several SVN blog entries, indeed so many that he has a subversion category to help easily find them all...
...as has Rob Gonda. Thanks to both of you.
Ray Camden did a couple of blog entries as well, and there are various some very useful comments from the community in those, including discussions of Eclipse and Trak integration. The latter entry also has some nice info in a comment on 6/26/06 from Adam Cameron.
And Joe Rinehart did an entry that explains his use of it with regard to MG, with some tips and a related Ant script.
Finally, Nick Tong also has put together a similar list of links he'd found.
I could go on, but that should be enough to get you started in what the CFML community thinks about it. Note as well that several open source CFML projects use SVN.
General Interest Windows Installation tips
Many of the above also point to the popular, "Mere-Moments Guide to installing a Subversion server on Windows", which was written to help make it easier to understand and install all the parts for Windows users.
Some good news is that, as useful as that is for understanding things, it was supplanted by the "Less-Than-Mere-Moments Subversion Installer", which is a one-click installer that makes configuration drop-dead simple.
Unfortunately, as you'll see in a comment on that last blog entry, I had a bug which you can avoid by not doing what I did. :-)
While Adam's comment in the aforementioned blog is right that there is a single installer already available from the main SVN site, the "mere moments" ones try to do more than just install it, but also help you configure it.
Here's yet another Windows installation assistance tutorial.
Understanding the need for server versus client components
I think it's worth noting that there are two aspects of using SVN: one is setting up the server component so that you or others can create repositories, and the other is setting up the client components so that you can merely access or edit code that is stored in such a repository.
Some of the resources above (from info to installers) may focus on and assume you're interested in the former (or both together).
If you just want to use someone's existing repository, then you don't need to install the server component. You just need a client, and the most popular seem to be either TortoiseSVN (which plugs into the Windows Explorer) or SubEclipse (which is an add in for Eclipse).
And in conclusion, if you need more insight into the general concept of revision control, see the Wikipedia entry.