SQL Server 2012

External Article

SQL Server 2012 Window Function Basics

  • Article

For some time, Microsoft had a few window functions, but not the full set specified in the SQL 2003 standard. Now, in SQL Server 2012 we have the whole range, and extremely useful they are too. There's no longer an excuse to avoid them, particularly now you have Rob Sheldon's gentle introduction.

2013-04-04

5,033 reads

External Article

SQL Server 2012 AlwaysOn: Multisite Failover Cluster Instance

  • Article

SQL Server Failover Clustering, which includes support for both local and multisite failover configurations, is part of the SQL Server 2012 AlwaysOn implementation suite, designed to provide high availability and disaster recovery for SQL Server. The multisite failover clustering technology has been enhanced significantly in SQL Server 2012. The multisite failover cluster architecture, enhancements in SQL Server 2012 to the technology, and some best practices to help with deployment of the technology are the primary focus of this paper.

2012-11-16

2,732 reads

SQLServerCentral Article

SQL Server 2012’s Information on Parallel Thread Usage

  • Article

In the SQL Server 2012 execution plan we can see better the true thread reservations for a query and not just information on the maximum degree of parallelism and row distribution across parallel threads; thanks to the new parallel thread usage information.

4.47 (17)

You rated this post out of 5. Change rating

2012-08-09

5,750 reads

SQLServerCentral Article

SQL Server 2012 Database Recovery Advisor: Simplified Point in Time Recovery

  • Article

The aim of the new Database Recovery Advisor in SQL Server 2012 is to simplify the task of piecing together a recovery sequence from multiple backup files, comprising full, differential, and log backups. In this article, I'll demonstrate how the tool makes it easier to plan for, and perform, a point in time recovery from a series of backups, in order to recover data that may have been lost due to an application bug, or user error.

4.46 (13)

You rated this post out of 5. Change rating

2012-07-13

2,627 reads

SQLServerCentral Article

Simplified Restores with SQL Server 2012 Recovery Advisor

  • Article

Occasionally, a DBA may need to restore a database from a multiple backup files that originated from multiple servers. This requirement might arise, for example, in a database-mirroring configuration, where backups may be from either of the servers.

4.33 (12)

You rated this post out of 5. Change rating

2012-06-27

2,944 reads

Blogs

A New Word: Foilsick

By

foilsick – adj. feeling ashamed after revealing a little too much of yourself to...

Accelerated Database Recovery for tempdb in SQL Server 2025

By

Accelerated database recovery was introduced in SQL Server 2019 and provides fast recovery, instantaneous...

Measuring What Matters: Operationalizing Data Trust for CDOs

By

Trust is the currency of the data economy. Without it, even the most advanced...

Read the latest Blogs

Forums

Create an HTML Report on the Status of SQL Server Agent Jobs

By Nisarg Upadhyay

Comments posted to this topic are about the item Create an HTML Report on...

Where are the stylish points for Flats For Sale In Vadodara City?

By reeltorseoo

Stylish points for Flats For Sale In Vadodara City are Alkapuri, Gotri, Karelibaug, and...

ETL Framework In Production

By Rahulmsb5

Hello, I am leveraging Python within SQL Server Integration Services (SSIS) packages, primarily through...

Visit the forum

Question of the Day

SQL Server Ghosts

For Halloween, what are ghost records?

See possible answers