Top "Sql-server-2014" questions

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

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 …

elasticsearch sql-server-2014
SQL Server Data Tools 2015 installation error

I'm trying to install SQL Server Data Tools - Visual Studio 2015, but I keep getting an "Unspecified error". The log …

visual-studio-2015 ssis sql-server-2014 sql-server-data-tools
How to assign data to a user-defined table type from Select query in SQL Server 2014

I have a stored procedure which retrieves three columns from multiple tables. I want to get the results in a …

sql sql-server sql-server-2014
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 …

uninstallation sql-server-2014
Incorrect syntax near OFFSET command

Why this doesn't work and gives me a "Incorrect syntax near offset command" error SELECT o.orderdate, o.orderid, o.…

sql sql-server tsql sql-server-2014
SQL Server 2014: SSISDB vs MSDB for package deployment

I'm currently in the process of upgrading from SQL Server 2008R2 to 2014 (both Enterprise). There are a plethora of SSIS …

sql-server ssis bids sql-server-2014
Incorrect syntax near 'THROW'

IF @SQL IS NOT NULL BEGIN BEGIN TRY EXEC sp_executesql @SQL PRINT 'SUCCESS: ' + @SQL END TRY BEGIN CATCH …

sql-server tsql sql-server-2014
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 multidimensional-array ssas sql-server-2014 tabular
SQL index for date range query

For a few days, I've been struggling with improving the performance of my database and there are some issues that …

sql database indexing sql-server-2014 database-performance
The metadata could not be determined because every code path results in an error; see previous errors for some of these

I am migrating from SQL Server 2005 to SQL Server 2014 and one of the queries stopped working in SQL Server 2014: select * …

sql metadata sql-server-2014 openrowset