Database Administrators Stack Exchange
Database Administrators Stack Exchange

Questions tagged [sql-server-2014]

SQL Server 2014 (major build version 12.0.xxxx). Please also tag sql-server.

Major releases:

  1. 12.00.2000 - RTM, April 2014
  2. 12.00.4100 - Service Pack 1 (SP1), released May 2015

SQL Server 2014 will leave mainstream support on 2019-07-09 and extended support on 2024-07-09.

SQL Server 2014 contains the following major new features:

Database Engine

  • Memory limit for Standard Edition increased from 64GB to 128GB
  • Clustered columnstore indexes & archival data compression
  • Memory-optimized tables (aka In-Memory OLTP, codename Hekaton)
  • Buffer pool extension to SSD
  • New cardinality estimation model
  • AlwaysOn replicas increased from 4 to 8
  • Delayed durability
  • Parallel SELECT INTO
  • Inline index specification for CREATE TABLE
  • Rebuild individual partitions of a partitioned table online
  • Lock priority for online operations
  • Backup Encryption
  • Incremental statistics update
  • Database data files hosted on Windows Azure
  • Deploy a SQL Server Database to a Windows Azure Virtual Machine Wizard
  • Backup to URL / Managed backup to Windows Azure
  • Resource governor physical IO control

See Features Supported by the Editions of SQL Server 2014

Analysis Services & Business Intelligence

  • PowerView for multidimensional models
  • BIDS becomes SQL Server Data Tools for Business Intelligence (SSDT-BI)

No major changes to the following feature sets in SQL Server 2014:

  • SSIS (Integration Services)
  • SSRS (Reporting Services)
  • Replication

Note: Windows Vista is not a supported operating system for SQL Server 2014.

2756 questions
4
votes
3 answers

Add Login NT AUTHORITY\NETWORK SERVICE to SQL Server

I installed a SQL Server 2014 Developer Edition on a VM, because the Express Edition is limited to just 10GB. Now I've tried to conncet to that server remotely from my VM with SSMS. But I get an error that I cannot connec: (provider: SQL Network…
FredM
  • 155
  • 1
  • 1
  • 8
3
votes
2 answers

Mystery Backup Database Job

I'm running SQL Server 2014. I was checking logs to ensure the automated nightly Backup Database job that was scheduled was completing okay. I noticed another BACKUP DATABASE job had been running nightly. I would like to see if I can disable this…
Don
  • 161
  • 1
  • 7
3
votes
1 answer

Data Analytics SQL Query method

I need every 13th row as new column. I am not sure how this can be done using Pivot or transpose. Number of rows are not fixed. Please guide me the way. Thanks Data is as shown below where every 4 row gets repeated ID   Value AA   A BB   …
Prasad
  • 33
  • 3
2
votes
1 answer

Adding a leading zero to single digits in a comma separated string of numbers

I have a table with two columns. ID and VALUE. The VALUE column contains a combination of a string of numbers from 1 to 45. EG :- ID VALUE T123 1,6,7,9,17,22,43 T456 2,3,5,7,8,13,28,32,41 T789 1,2,4,5,6,7,9,11,15,23,34,42 I'm…
UK1539
  • 25
  • 4
2
votes
1 answer

Drop the last character of string, if the last character is s

Working through an odd issue that the moment and trying to find a solution. If we have a string variable (@string) how might we drop the last character of the string, ONLY if the last character is an s?
MattC
  • 33
  • 1
  • 8
2
votes
1 answer

identify queries experiencing sos_scheduler_yield

Is there a way to capture the queries experiencing the SOS_Scheduler_Yield wait type as it is happening. My cpu is pegging out at night and I suspect its some xml processing that is causing it by chewing up all my processor cycles; however, the…
Lumpy
  • 2,109
  • 8
  • 32
  • 43
2
votes
0 answers

sp_send_dbmail sends query results from one server but not a second server

Both servers are able to normally send email without issue server a is able to send the email for the query below, but server b has an error message saying, "mail could not be sent to the recipients because of the mail server failure. Exception…
Jamie
  • 21
  • 1
2
votes
1 answer

User is not showing for abc database under security folder but when we query from sys.databases it showing as a db owner

Below Steps I Did EXEC sp_changedbowner 'domainname\user' ... to change the principal owner. It was executing for a long time so i cancelled it. While closing the tab it asked me to save the uncommitted transactions, so I saved them. Later when I…
Debashis
  • 31
  • 1
  • 5
2
votes
1 answer

Adding a prefix to PIVOT columns

I'm PIVOTing a table such that the column names in the final table are based on the "organization name" in the source table. The problem is, the "organization name" is data-driven and could be any set of values; I use dynamic SQL to build up the…
Jez
  • 685
  • 9
  • 19
2
votes
1 answer

Maintenance plan in AlwaysOn environment

I need to create below three jobs in AOAGs SQL Server. CheckDB integrity, Update stats, Re-organize index My question is ,Do I need to create in only Primary Replica or all the secondaries also ?
Learning_Learning
  • 1,590
  • 23
  • 47
1
vote
1 answer

How to convert a VARCHAR DD/MM/YYYY H:MM:SS AM into datetime and then to Json date?

So I know this question is crazy. I just spent days trying to solve this but i think it's impossible. I have a table with a CreatedDate as a VARCHAR field. 10/7/2019 7:12:59 AM What I need to to is to convert this date into those dates we see on…
Racer SQL
  • 7,386
  • 14
  • 69
  • 128
1
vote
2 answers

How to find a specific column name in table design view?

I have a table in my database in SQL server 2014 with a lot of columns, and when I want to find a column for modify properties, it is difficult to find that column, how can I find that column (ex: column name = "Birthdate"), has SSMS have any tools…
Masoud Sadeghi
  • 123
  • 5
1
vote
0 answers

Error writing to file c: windows\syswow64\mfc100.dll during installation of SQL Server 2014

During installation of SQL Server 2014 there is error appears Error writing to file c: windows\syswow64\mfc100.dll verify that you've access to that directory as you can see below image, I navigate to that directory and not found mfc100.dll file…
zohaib
  • 11
  • 1
1
vote
1 answer

Sql servr 2014 instant to sql server 2008 r2 instance linked servers query problem

I'm getting the following error on some of the linked server,when I try to query a table using a link server. The link server is created on SQL2014 instance to connect to an SQL2008r2 instance.
eaon03
  • 11
  • 1
1
vote
0 answers

SUSDB appears to be in a different location than shown in SQL Studio

I Have WSUS installed on a 2012R2 server. I am using SQL, not the internal windows database. I was looking at cleaning out some old files. One of the folders is named RestoreTemp (created to restore data to check). The SUSDB.mdf and SUSDB.log…
Stephen Kiddoo
  • 11
  • 1
1
2 3 4 5 6