Stack Overflow
Stack Overflow

Questions tagged [sql-server-2014]

Use this tag for questions specific to the 2014 version of Microsoft's SQL Server database engine. SQL Server 2014 is the predecessor of the later SQL Server 2016.

SQL Server 2014 (codename Hekaton, version 12.00), released in April 2014, is the successor to SQL Server 2012 and the predecessor of the newer version of Microsoft's SQL Server database engine SQLServer 2016.

This tag covers questions specific to the 2014 version of the database engine. It is recommended that the tag is also used when tagging questions with this version specific tag.

Read more about SQL Server 2014 from MSDN.
Get SQL Server 2014 from here.

4735 questions
12
votes
3 answers

Data transfer from SQL Server to ElasticSearch Node

I was using Elastic Search 1.7 version for my application and by using the concept of river i was filling up the data from SQL Server to ElasticSearch using the following article :…
amrit
  • 315
  • 1
  • 2
  • 11
12
votes
4 answers

Return random value from the list

I'm using SQL Server 2014, and would like to take advantage of new function CHOOSE and RAND. Basically would like to return random color from the list. Something like: Select CHOOSE(RAND(29), 'bg-blue', 'bg-blue-madison', 'bg-blue-hoki',…
Whistler
  • 1,897
  • 4
  • 29
  • 50
12
votes
5 answers

Insert into multiple tables

A brief explanation on the relevant domain part: A Category is composed of four data: Gender (Male/Female) Age Division (Mighty Mite to Master) Belt Color (White to Black) Weight Division (Rooster to Heavy) So, Male Adult Black Rooster forms…
Ortiga
  • 8,455
  • 5
  • 42
  • 71
12
votes
7 answers

How to restore SQL Server 2014 backup in SQL Server 2008

Were there any changes in this area with SQL Server 2014? I’ve seen this post Is it possible to restore Sql Server 2008 backup in sql server 2005 and I know that this was not possible as a scenario for 2012 -> 2008 but I wonder if MS made any…
Jon Mallow
  • 396
  • 1
  • 4
  • 7
11
votes
2 answers

The SQL Server Network Interface library could not deregister the Service Principal Name (SPN)

I've set up a SQL Server service account with permissions to read and write service principal names. When SQL Server starts up I get the expected message in the logs showing that the service account has successfully registered the SPN: The SQL…
paulH
  • 1,102
  • 16
  • 43
11
votes
1 answer

Select from sequence with SqlCommand.ExecuteScalar() returns NULL when high disk usage

I encounter that SqlCommand.ExecuteScalar() returns NULL sometimes in production environment. I've crossed a lot of similar questions here, the most close one is: SqlCommand.ExecuteScalar returns null but raw SQL does not. But the advice given is…
flam3
  • 1,897
  • 2
  • 19
  • 26
11
votes
6 answers

An error occurred while executing batch. Error message is: Exception of type 'System.OutOfMemoryException' was thrown."

I have one table(Sql server 2014) with 60 million data. while fetching the data i am getting "An error occurred while executing batch. Error message is: Exception of type 'System.OutOfMemoryException' was thrown." Can any one please help here?
Mukund M
  • 121
  • 1
  • 1
  • 4
11
votes
1 answer

Azure Recovery Services and SQL 2014 Managed Backups not playing well together

I started using Managed Backups on my SQL server. It has been working well for over a year. It seems to backup the dbs once a week, and take incrementals every 2 hours. A month ago, we changed our VM backup solution to Azure Recovery Services. We…
Eric Wild
  • 641
  • 5
  • 12
11
votes
1 answer

Get list of columns in a temp table in SQL Server

I am creating a temporary table on-the-fly using Select * Into #temp from SomeChangingSource in a stored procedure. I need to then list the resulting columns. Handling this for a regular (permanent) table is as simple as: select COLUMN_NAME from…
John Joseph
  • 1,003
  • 1
  • 10
  • 20
11
votes
1 answer

Is it possible to change the user account of the localdb instance in SQL Server?

Is it possible to change the user account of the localdb instance in SQL Server? We changed our domain and it is using my old domain account so I can no longer login anymore. Also, I don't believe that you can login with SQL auth, so the sa account…
bkorzynski
  • 541
  • 1
  • 5
  • 15
11
votes
4 answers

Convert IS NULL to BIT

This might be a very basic question but I just came over it while writing a query. Why can't SQL Server convert a check for NULL to BIT? I was thinking about something like this: DECLARE @someVariable INT = NULL; -- Do something SELECT CONVERT(BIT,…
diiN__________
  • 7,393
  • 6
  • 42
  • 69
11
votes
4 answers

Changing SQL Server DB from tabular to multidimensional

I have following problem: When I try to deploy my SSAS project (with cube, dimensions and all that jazz) to sql-server, it throws error saying that You cannot deploy the model because the DB deployment server is not running in multidimensional…
Krzysztof Piszko
  • 1,355
  • 3
  • 12
  • 17
11
votes
2 answers

Why is SQL Server Agent not starting?

I just installed my SQL Server 2014 on the top of Windows Server 2012. But after installation SQL Agent is not starting. Can someone tell me like what can I do to solve this? PFA screenshot for the same.
Jason Clark
  • 1,307
  • 6
  • 26
  • 51
11
votes
1 answer

Error = [Microsoft][ODBC Driver 11 for SQL Server]Warning: BCP import with a format file will convert empty strings in delimited columns to NULL

I upgraded our Windows Server from 2008 to 2012 and the SQL Server from 2008 to 2014. I have a process that uses the BCP command to export data from the database. The command is below: bcp "exec db_name.dbo.table_name 20160204, 0" queryout…
nobody
  • 10,892
  • 8
  • 45
  • 63
11
votes
1 answer

set based approach to remove contained points

I have this data: IF OBJECT_ID('tempdb..#temp') IS NOT NULL DROP TABLE #temp CREATE TABLE #temp ( Id INT IDENTITY(1, 1) , X FLOAT NOT NULL , Y FLOAT NOT NULL ) INSERT INTO #temp (X, Y) VALUES (0, 0) INSERT INTO #temp…
cs0815
  • 16,751
  • 45
  • 136
  • 299
1 2 3
…
99 100