Server Fault Stack Exchange
Server Fault Stack Exchange

Questions tagged [sql-server-2012]

Microsoft SQL Server 2012 (often abbreviated as SQL Server 2012 or MSSQL 2012) is a version of Microsoft's SQL database server software. It includes new features and upgraded functionality from its predecessor, SQL Server 2008 R2, went RTM on March 6th, 2012 and to general release on April 1st, 2012.

SQL Server 2012 logo

Microsoft SQL Server 2012 (often abbreviated as SQL Server 2012 or MSSQL 2012) is the latest version of Microsoft's SQL database server software. It includes new features and upgraded functionality from its predecessor, SQL Server 2008 R2, went RTM on March 6th, 2012 and to general release on April 1st, 2012.

SQL Server 2012 is available in several "mainstream" editions, as well as some "special" editions not widely available for wide, such as a Development edition, an Azure edition and a Massively Parallel Processing Edition.

The mainstream editions are:

  • Enterprise Edition
  • Business Intelligence Edition
  • Standard Edition
  • Express Edition
  • Web Edition
  • Compact Edition

The complete feature set of SQL Server 2012 is massive, and probably too big to list, but Microsoft has a large page devoted to the topic, and includes feature comparison across the various mainstream editions. SQL Server 2012 adds new features focused on increasing the availability and scalability of the SQL Server product line, most notably a "AlwaysOn High Availability" feature, a dedicated Disaster Recovery feature, "scale-out reads" functionality and database mirroring capabilities.

268 questions
3
votes
1 answer

Is SQL Management Studio 2012 avaliable, without Engine itself?

On my dev machine, I have SQL Management Studio 2008 R2 installed. I tried to upgrade to SSMS 2012 Express, setup finished but nothing happened. Is it possible to get SQL Management Studio 2012 without occurring a license on the Database Engine…
abatishchev
  • 531
  • 1
  • 9
  • 31
2
votes
0 answers

Importing data from Informix DB to SQL Server

Configured Informix drivers (32-bit) ODBC on my local machine and trying to import the data to SQL Server using SQL Server IMPORT and export wizard. I selected source tables and views(steps in SQL import): When I click on preview I'm getting the…
aditya y
  • 21
  • 2
2
votes
1 answer

SQL Server 2012 installation shared feature directory and instance root directory

During installation, is it ok to choose different Drives (say D and E) for Installation shared feature directory and Instance root directory or they should be on the same drive, or should any of them be on the OS drive (usually C)? UPDATE: OR, what…
nam
  • 217
  • 1
  • 11
2
votes
1 answer

Cant connect to sql server database using ip

I've created a sql server database on server A. I was always using Windows Authentication to connect, but now I want to connect to database from server B. Then, I added a new user to database and turned Sql Authentication ON. Now, I can connect to…
Damian
  • 21
  • 1
  • 3
2
votes
0 answers

Client to IIS to SQL Server Kerberos authentication

I would like to have a setup where my IIS web server sits on a different virtual server from where my SQL Server is installed, and Windows Authentication should be used for all connections. I am currently getting the dreaded Login failed for user…
Paschover
  • 121
  • 2
2
votes
1 answer

Classic asp site, randomly slow DB connection

We are running a site with classic asp and ASP.NET MVC 4 (C#) side by side. During high traffic, database queries are running really slow in the asp pages. At the same time, in the same site, C# pages are always connecting normally to the same…
Dough
  • 21
  • 4
2
votes
1 answer

Manage SQL Agent Jobs On Multiple Servers

Is there a way to deploy/modify/remove//manage SQL Agent Jobs across multiple servers within a domain without third-party software?
totalfreakingnoob
  • 145
  • 1
  • 6
2
votes
1 answer

Hyper-V Guest data encryption

I have a new requirement to encrypt the data inside an sql database while it is at rest. So far I've looked at Bitlocker (see below), and other commercial products (I won't name because I'm not looking for this product is best answers). I've also…
Drifter104
  • 3,693
  • 2
  • 22
  • 39
2
votes
2 answers

Can we use FILESTREAM in case of SQL Server cluster

I saw this point on Technet article about RBS. The local FILESTREAM provider is supported only when it is used on local hard disk drives or an attached Internet Small Computer System Interface (iSCSI) device. You cannot use the local RBS…
Frank Martin
  • 721
  • 2
  • 10
  • 23
2
votes
3 answers

SQL Server Management Studio 2012 - password lag and failure

In a new installation of SQL Server 2012 Standard, we have mixed-mode authentication enabled. Using Windows authentication, I can authenticate and use SQL Management Studio as expected. Using SQL authentication, SQL Management Studio will not let me…
kpollard
  • 21
  • 4
2
votes
0 answers

Azure Variable Table v Temp Table

This is a bit long; but I have been working through queries figuring out where a performance issue is coming from. Appreciate you taking the time to read it. I have an application running on a Dedicated Server which is in Turn running SQL Server…
u07ch
  • 73
  • 1
  • 9
2
votes
1 answer

SAN Synchronous Replication and SQL Server - Is RPO of 0 possible?

I am working on a solution that is using SQL Server 2012 SP2, but without the use of AlwaysOn availability groups. This is due to cross-database transactions, that does not work for this scenario. Note: This is being addressed as we speak, but…
Dominic Zukiewicz
  • 141
  • 1
  • 8
2
votes
0 answers

SQL Server Background Task Running?

I am developing a web application, which consists of a .NET application, using Entity Framework, and MS SQL 2012 back end. Every now and then we experience a slowdown in the system, which causes certain pages to become extremely slow at loading (10+…
Gavin Coates
  • 410
  • 1
  • 6
  • 17
2
votes
2 answers

Is it possible to store a credential for Windows Authentication to an Analysis Services server?

SQL Server Analysis Services uses Windows authentication for server connections. Typically, you assign your domain account to a role (or the server administrator list), and then connect to the server from a user session using the same domain…
NReilingh
  • 472
  • 3
  • 9
  • 24
2
votes
1 answer

5.7.1 SMTP error when running stored proc using DB Mail in SQL Server 2012

I am getting an error in SQL Server 2012 Database Mail when executing a stored proc to send an email from a specified address to a specified address using Office 365 as the SMTP server. The mail could not be sent to the recipients because of the…
medina
  • 135
  • 1
  • 3
  • 11
1 2 3
…
17 18