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

Unable to connect to SQL Server on live server

I have a copy of my client's database and website on my computer. There's also a matching copy of both online where my client's customers will use the website. When I test my local copy of the website with my local database, everything works. When I…
Ortund
  • 127
  • 7
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 DB failing to send server email - intermittent

Recently, we noticed an issue in SASS 2014 logs regarding the failure of some emails to send: The mail could not be sent to the recipients because of the mail server failure. (Sending Mail using Account 1 (2023-06-29T11:20:17). Exception Message:…
Gytis Varnelis
  • 1
0
votes
3 answers

"Unknown token received from SQL Server" errors since recent Windows Updates

I posted a question to Stack Overflow about this error when it started occurring for our older Delphi 7 applications on Windows 10. It is now happening on Windows Server 2012 R2 systems that had these recent…
SiBrit
  • 101
  • 3
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 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