Much has been written about SQL Server Always On Availability Groups, but the topic of SQL Server Failover Cluster Instances (FCI) that span both availability zones and regions is far less discussed.

Within SQL Server, temporary tables are stored in the Temporary Tables folder of the tempdb database. How are transactions used? Transactions allow you to group SQL commands into a single unit.

To see how implementing the new SQL Server leads to cost efficiencies, improved business processes and innovation for RTT Group, take a look at the RTT Group SQL Server 2012 Case Study.