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
8
votes
3 answers

Is the sort-order of table-valued-parameters guaranteed to remain the same?

I need to know if i need to add a sort-column to my custom table-type which i could then use to sort or if i can trust that the order of parameters remains the same even without such a column. This is my type: CREATE TYPE [dbo].[VwdCodeList] AS…
Tim Schmelter
  • 450,073
  • 74
  • 686
  • 939
8
votes
1 answer

What does "Use windows fibers (lightweight pooling)" setting do in SQL Server 2014 server properties?

What does "Use windows fibers (lightweight pooling)" setting does in SQL Server server properties?
Ahsan
  • 2,488
  • 2
  • 22
  • 44
8
votes
2 answers

IsNumeric failing with "A severe error occurred on the current command." SQL Server 2014 CTE

I'm running a series of scripts which generate a database. They run to completion on SQL Server 2012 (11.0.5058.0). On SQL Server 2014 (12.0.4213.0) a script errors with: Msg 0, Level 11, State 0, Line 0 A severe error occurred on the current…
npjohns
  • 2,218
  • 1
  • 17
  • 16
8
votes
1 answer

Does EF 6 support SQL Server 2014 Types?

I have an asp.net mvc 5 web api application where I need to convert a SqlGeography instance into a DbGeography instance for querying with Entity Framework 6. I'm using the following code to do so: SqlGeography geo =…
Mansfield
  • 14,445
  • 18
  • 76
  • 112
8
votes
6 answers

Running Multiplication in T-SQL

GTS Table CCP months QUART YEARS GTS ---- ------ ----- ----- --- CCP1 1 1 2015 5 CCP1 2 1 2015 6 CCP1 3 1 2015 7 CCP1 4 2 2015 4 CCP1 5 2 2015 2 CCP1 6 2 2015…
Pரதீப்
  • 91,748
  • 19
  • 131
  • 172
8
votes
4 answers

Why Would An Outer Join Be Slower Than Separate Queries

I have a query that basically looks like this: Select * From UserSearches us left outer join Quotes q on q.UserSearchId = us.Id and q.QuoteNumber is not null left outer join ContainerDetails cd on cd.QuoteId = q.Id left outer join Surcharges s on…
Pharylon
  • 9,796
  • 3
  • 35
  • 59
8
votes
1 answer

Is it normal for the Delete key not to work when trying to rename a DB/table in SSMS?

I try to rename a database or a table in SSMS 2014 (with CU6 applied), by clicking and selecting the DB or table in the Object Explorer and then pressing F2 to edit the name. The Delete key on my keyboard will not delete the character to the right…
Michael Goldshteyn
  • 71,784
  • 24
  • 131
  • 181
8
votes
2 answers

Grouping and counting rows by value until it changes

I have a table where messages are stored as they happen. Usually there is a message 'A' and sometimes the A's are separated by a single message 'B'. Now I want to group the values so I'm able to analyze them, for example finding longest 'A'-streak…
dwonisch
  • 5,595
  • 2
  • 30
  • 43
8
votes
1 answer

How to change SQL Server 2014 Import and Export Wizard default datasource?

Starting with SQL Server 2014 the default datasource in the Import and Export wizard is .Net Framework Data Provider for Odbc. Any idea how to change this?
Arun K
  • 172
  • 1
  • 6
8
votes
2 answers

Execute SSIS package from stored procedure as proxy user without xp_cmdshell

I am trying to run an SSIS package through a stored procedure, but I am getting an Access is denied error when I try to import a CSV. I put the package inside a job and ran it and it worked as long as I used a proxy account. I am trying to replicate…
Simple Sandman
  • 900
  • 3
  • 11
  • 34
8
votes
2 answers

The operating system on this computer or its service pack level does not meet the minimum requirments for SQL Server 2014

when i am trying to uninstall SQL Server 2014, getting error as listed below The operating system on this computer or its service pack level does not meet the minimum requirments for SQL Server 2014. to determine the minimum required operating…
Radhi
  • 6,289
  • 15
  • 47
  • 68
8
votes
5 answers

SQL Server Management Studio can not connect

I have installed SQL Server Management Studio 2014. In "connect to server" window, I selected server type as "Database engine", server name as "(local)" but when I try to connect, n error is shown- TITLE: Connect to Server Cannot connect to…
sahossaini
  • 474
  • 1
  • 5
  • 11
7
votes
2 answers

How to use INSERT INTO OPENROWSET to export to Excel without being an admin on the target server

I am trying to grant a user access to export data from SQL Server into an Excel file using OPENROWSET. The user is getting the following error: Cannot initialize the data source object of OLE DB provider "Microsoft.ACE.OLEDB.12.0" for linked…
Wesley Marshall
  • 434
  • 4
  • 16
7
votes
2 answers

difference between view and indexed view or materialized view

I am confused in these two and tried to figure out the differences but didn't get something specific for which I am looking for. Where to use indexed view over an ordinary view. Some important differences between them.
IShubh
  • 354
  • 1
  • 3
  • 12
7
votes
3 answers

SQL to select consecutive records with the same value

I have a table with measurements. Measurement is done every minute. I need to select only rows having the same sample_value more than once consecutively for the same device_id. Here are initial data: sample_date sample_time device_id …
Tax Max
  • 83
  • 1
  • 1
  • 6
1 2 3
…
99 100