I'm not sure I understand why you added the line:
AND V3.VariableID IN (64,65,66,67,68);

OK, given these requirements, and knowing that there are potentially multiple versions of the Yes/No variables as well, maybe something like this:
SELECT DocumentID, VariableID, ValueText, RevisionNo
 ...

If RV.RevisionNo is needed in the results, just include it in both halves of the UNION ALL query in the CTE.  I didn't have a dbo.Documents table in the testing...

Are the disks directly attached to the server or are they on a SAN?  If the files are located on a SAN then splitting things out into separate logical drives...

Are we really OCD?  Or is it CDO... keeping the letters in their proper alphabetical order 😉

I had to invent my own data to try this, so it's not well tested, but maybe something like this:
WITH VarYesNo AS
(SELECT V.DocumentID, V.VariableID, V.ValueText, CAST(1...

I might see a problem in your subquery for V2, I'm thinking it probably should include DocumentID in the SELECT and GROUP BY, and in the JOIN.  It might make...

I think the example query you provided accidentally swapped VariableID and ValueText columns in your PIVOT clause.  You probably want:
PIVOT
(
MAX (ValueText)
FOR VariableID IN
(...

I think a part of the problem is the way people approach it.  When I work with developers, they already have preconceived notions coming into a design session of what...

I almost fell for Extended Attributes, but did guess the right answer.  I think that page of my memory might have been pushed out by the least recently used algorithm

Can you give an example of what you were comparing for windowed function compared to select group by approach?  Is there an index on the windowed function's PARTITION BY and...

When I try running this query after SET STATISTICS IO ON, it shows logical reads but not physical reads, even for a server that hasn't been logged into today.  How did...