Server Fault Stack Exchange
Server Fault Stack Exchange

Questions tagged [sql-server-2014]

Microsoft SQL Server 2014 is a version of the relational database management system designed by Microsoft, released on April 1, 2014.

Microsoft SQL Server 2014 was released on April 1, 2014, and brought with it some notable changes. They include but are not limited to:

  • New cardinality estimator
  • New In-Memory OLTP Engine
  • Enhanced Windows Server Integration
  • ...

For a full list of features, Microsoft supports and updates a comprehensive list of features, comparative to older versions of SQL Server.

The full list of editions has been updated as well in the latest version of SQL Server.
Currently they have three mainstream production editions:

  • Enterprise
  • Business Intelligence
  • Standard

A specialized edition in Web, and two breadth editions in Developer and Express.

70 questions
2
votes
5 answers

SQL Server in "Recovery Pending" status after reboot

We have quite a few programs of our own design which communicate to our SQL Server (SQL Server 2014 Express). Every now and then they start blowing up all over the place; we run around trying to figure out what's wrong, only to open up SQL Server…
Keith Stein
  • 203
  • 1
  • 8
  • 16
2
votes
3 answers

Do SQL backups run faster if you set the databases to read only first?

I have to do a backup of all databases back to back (3.25 GB of data for all .BAK files combined). Will it go faster if I configure the script to set the database to read only first before backing it up? I am using the RESTORE VERIFYONLY option to…
Michael
  • 39
  • 3
2
votes
1 answer

SQL Server Load Balancing Splitting Read/Write Operations

Hello We have 3 nodes of SQL Server 2014 Standard Edition one of them as primary and the other one as Replication of the Primary using Transactional Replication database We want to use the other 2 nodes to read operations and reduce the load of the…
Ermesto
  • 21
  • 2
1
vote
1 answer

SQL Server 2014 setup fails: SSL Provider, error: 0 - The token supplied to the function is invalid

I am attempting to install SQL Server 2014 Standard edition on a new Windows Server 2016 set up as a domain controller that replaces a retired DC. (I know it's not recommended, but we are a small operation and have combined Windows Server domain…
Brett
1
vote
1 answer

Why do I get different memory numbers using TSQL versus the GUI?

I'm preparing to bump up our max server memory value after a RAM upgrade on our server. I'm testing the commands out on a test SQL Server and I'm not sure why I'm seeing different results with T-SQL versus the GUI. I changed the memory on the test…
cspell
  • 195
  • 1
  • 2
  • 6
1
vote
0 answers

Can't build second Azure VM in an availability set without selecting managed disks

I have an Azure availability set which I built a SQL server in without managed disks, manually creating two 2TB volumes out of 1TB volumes that get assigned. If I go to build a second in the portal also without managed disks, the option to build it…
Elomis
  • 313
  • 1
  • 2
  • 13
1
vote
1 answer

Is Microsoft Sql Server 2014 certified for Windows Server 2016

I would like to update so version of my machine where is installed Microsoft Sql Server 2014, is this certified for Windows Server 2016? I don't want problems with MS assistance...
Tobia
  • 1,272
  • 9
  • 41
  • 81
1
vote
1 answer

How can I isolate data-warehouse workloads from production/on-demand queries?

I'm using VMware's vSphere 6 and I'm considering consolidating several SQL servers, these servers have different usage profiles; On-demand burst reporting (Cognos/Data-warehouse) Interactive web usage (Business hours/with variable peak usage) I…
makerofthings7
  • 8,911
  • 34
  • 121
  • 197
1
vote
1 answer

SQL Server uses CPU too much

I have a server 2012R2 with SQL Server 2014 Express SP2 installed. There are some applications and databases, but nothing too big. Databases are small, about 100MB size combined. At some moment (not from the beginning) the SQL Server process started…
yaapelsinko
  • 111
  • 3
1
vote
0 answers

Deployment fails for SQL Server 2014 SP1 Standard on Windows Server 2012 R2 VM

Apologize in advance - this stuff isn't exactly my wheelhouse. I'm trying to provision a VM with Windows Server 2012 R2 and setup SQL Server 2014 SP1 Standard using the Azure portal. I pretty much don't change any of the default settings as I am…
Jerreck
  • 111
  • 3
1
vote
1 answer

Azure SQL Express 2014 VM: Cannot update/patch SQL Express

I created a VM using the standard Azure image "SQL Server 2014 SP1 Express on Windows Server 2012 R2". I immediately ran Windows Update and all patches for the server worked but the Security Update for SQL Server 2014 Service Pack 1 (KB3070446)…
David Coster
  • 121
  • 7
1
vote
1 answer

Passing AD identity from Sharepoint Online to Analysis Services Tabular on an Azure VM

We are presenting charts & reports in Excel Services hosted in SharePoint Online. The Excel files in turn connect to an Analysis Services Tabular Model hosted in an Azure VM. In order to use Tabular Model's role-based perspectives we need to pass…
Édgar Sánchez Gordón
  • 111
  • 2
1
vote
1 answer

How to import SQL v8 (2000) DB in v12 (2014) Server

I made a backup of a db on one server and tried importing it on another server. I got the error message saying they are incompatible. I'm currently running SQL Express v12 on windows server 2012. What are my possible actions now? Can I deinstall the…
Benedikt S. Vogler
  • 125
  • 7
1
vote
1 answer

SQL Server 2014 Install Failed with The computer must be trusted for delegation and the current user error

I'm attempting to install SQL Sever 2014 newly installed Windows Sever 2012 R2 Standard edition OS. During the GUI portion of the installation it fails with the following error: There was an error generating the XML document. Looking at the…
Russ960
  • 233
  • 5
  • 14
1
vote
1 answer

MSSQL Management Studio 2014 not showing the "Tasks>Restore>Database..." Dialog

When right clicking on a database in the Object Explorer panel of SQL Server Management Studio 2014, and then expanding to "Tasks>Restore>Database...", then selecting it, the database restore dialog does not appear. Please note that: 1 - I was using…
Adam
  • 161
  • 2
  • 6
1
2
3 4 5