It all comes down to need, again with 2 nodes you need to find a way to add a 3rd vote in somewhere, Azure storage, fileshare witness.  As you have...

It's about establishing a quorum for the cluster.  Generally there is an odd number of votes needed to establish quorum to ensure things can operate correctly.

A 2 node FCI would...

If it's all staying local to one site then the quorum issue doesn't come into play. Only when you start using it for the DR purposes cross sites and have...

Not seen a company who specialises in HA, each vendor will give you their own speel on what their product can do, but I find HA comes down to what...

The you just order by JT.TRANSID.

As you've use TRANSID in two places you need to alias it correct on the order by.

You wouldn't want to create a view based on that above piece of code, what it looks like you do want is a stored procedure where you pass in a...

Unfortunately not, I could hazard a guess as to what columns are in those indexes but that's it a guess.  Without the execution plan also its hard to say whats...

@ktflash, no standard on how to answer a question.  Me personally like to point in a research direction first.  Simply handling a solution will most usually result in someone taking...

Take a look at "GROUP BY" and "HAVING" clauses, if you have any issues please post back

SELECT SUM(TRY_CAST(LEFT(RE80_VALORE, CHARINDEX('.', RE80_VALORE + '.')) AS int))
FROM dbo.RE80_MOVSCHPUNTI INNER JOIN
dbo.RE14_DOCTESTATA ON dbo.RE80_MOVSCHPUNTI.RE80_IDDOCTESTATA_RE14 = dbo.RE14_DOCTESTATA.RE14_ID
WHERE (dbo.RE80_MOVSCHPUNTI.RE80_INDTIPOMOVSCH = 1) AND (dbo.RE80_MOVSCHPUNTI.RE80_DATAMOV = CONVERT(DATETIME, 'DATA RANGE', 102)) AND
(dbo.RE14_DOCTESTATA.RE14_IDNEGOZIO_RE05 =...

OK, then please read that link I provided and provide the sample schema, tables, data and expected outcome.

It is unclear from the above how everything is tied together

Can you explain in detail what the full requirements are?

Can you please post as per this link (http://www.sqlservercentral.com/articles/Best+Practices/61537/) this will help us to get to the point your trying to...

The server can be the smallest machine you can build and can run SQL Express. 1 CPU, few GB RAM, some disk, doesn't have to be powerful by any means...

Is the server in UTC or EST?

UTC and EST are not the same time zone

EST to IST is a 10hour 30minute difference, so if you want something run at 12:05AM...

Don't do COPY_ONLY on your logs full stop. Just don't.

The only reason I would ever suggest a COPY_ONLY backup is if I wanted to sneak in a log for a...