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
0
votes
1 answer

6 GB/s SAS RAID 10 (6 Drive) vs. 3 GB/s SAS RAID 10 (14 Drive)

I am running MS SQL 2014 Standard and have a Dell MD 3000i iSCSI SAN. Rough specs: Dell R610 With PERC H700 controlling 6 x 2.5" 15K SAS drives (6 GB/s) Dell MD3000i with 14 x 3.5" 15K SAS drives (drives are 6 GB/s but MD3000i only supports up to 3…
Neal
  • 399
  • 1
  • 5
  • 13
0
votes
0 answers

SQL Server 2014 enterprise edition suddenly stop accepting the connections

We are seeing that our server will suddenly stop accepting new connection from SQL Server. The server itself is still accessible via RDP, but sharepoint portal/SSMS and any other remote SQL connection will timeout. Configuration manager shows that…
James
  • 1
  • 2
0
votes
0 answers

error 17054 severity 16 state 1 sql server 2014 enterprise edition

Our new database is just inaccessible. I have tried to find it in the error log and find this error during that time. So when we went to the Configuration manager. we were seeing Browser service, SQL Agent, and SQL Server services were stopped, and…
James
  • 1
  • 2
0
votes
1 answer

How to determine the common name (CN) for a microsoft sql certificate?

I'm in the process of trying to set up a self signed certificate for connecting a jetty server to a development sql database. I'm following the instructions here:…
pbuchheit
  • 139
  • 10
0
votes
0 answers

MS SQL-Server 2014 - Is it possible to trigger an Event/Script, when a certain Query comes along?

I'd like to have the possibility to accomplish a certain routine (fi. trigger a external node script or any kind of script/method whatever), when certain queries come along in MS SQL Server 2014. Is there a way to accomplish that? (worst case -…
haemse
  • 181
  • 1
  • 2
  • 9
0
votes
1 answer

How to enable more than 4 GB in SQL Server X86 under Windows X64

I have read here that I can use more than 4 GB in X86 SQL Server Systems and X86 Windows servers via /PAE option, but my scenario is different. I have a 32 bit SQL Server std in a Windows 2019 X64 std and I am going to upgrade to Sql Server X64…
AndreaTaroni86
  • 103
  • 3
0
votes
0 answers

SQL Server: Are shared locks used for foreign key constraint enforcement, and how long are they kept?

Main question is in the subject. In more detail: Let's say we have a table T with a FK constraint to table U (for simplicity, to its PK, and both table use clustered indices on their PKs). Now, we INSERT or UPDATE a row in T, thereby writing the FK…
H.M. Müller
  • 1
  • 2
-1
votes
1 answer

SQL Server Failover Clustering (4 nodes)

I think I was able to convince my cow-erkers that jamming all the databases on one server is a good idea. So, our setup will be something like this: Production - SQL 2014 Enterprise Standby - SQL 2014 (with automatic failover from Production) (I…
Rob
  • 201
  • 1
  • 7
-1
votes
1 answer

ODBC Driver Version 03.86.3959 connection to SQL Server 2014

Ok so I have some accounting software running on a Windows Server 2003 box. This server uses a System DSN, that uses Microsoft SQL Server ODBC Driver Version 03.86.3959 to connect to a Management Information System, which is running on SQL Server…
barns.dev
  • 1
  • 2
-2
votes
1 answer

I need to fully automate sql server restores , PLease help me

I'm New to Sql server and dont have experience in automate restores I need a script to restore a database from a .bak file and move the logical_data and logical_log files to a specific path. I can do: restore filelistonly from…
DBA_Fresher
  • 1
1 2 3 4
5