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
1
vote
2 answers

Loading files with dynamically generated columns

I need to create a SSIS project that loads daily batches of 150 files into a SQL Server database. Each batch always contains the same 150 files and each file in the batch has a unique name. Also each file can either be a full or incremental type.…
MayowaO
  • 380
  • 4
  • 12
1
vote
1 answer

Error in SQL Log: Timeout occurred while waiting for latch: class 'FCB', type 3,

We are running SQL Server 2014 SP2. Our server is under heavy transactional load and recently we found these messages in the SQL Server Error Log: Timeout occurred while waiting for latch: class 'FCB', id 000000235CA78238, type 3, Task…
SQL_Guy
  • 333
  • 4
  • 15
1
vote
1 answer

SQL Server 2014 - displaying vertical data in horizontal format

This is my first time to post on stackoverflow. I hope I’m doing it correctly. I have a SQL Server 2014 table that contains “verticle” data I need to rotate into a single record with multiple columns. bluefeet's answer (SQL Server 2008 Vertical data…
Frank
  • 43
  • 8
1
vote
0 answers

Cannot add new subscription to remote SQL Server Publication

I have this setup: A publisher SQL Server Standard 2014 instance named GMSSERVER\SQLSTANDARD on Server A A subscriber SQL Server 2014 Express instance named CLAUDIOGMS\SQLEXPRESS2014 on Server B When I try to add a new subscription from…
Clamari
  • 353
  • 4
  • 17
1
vote
1 answer

Perform a Bulk Insert and Decrypt Symmetric Key in SQL Server 2014

I have a stored procedure that performs a Symmetric Key decrypt then an insert into a table if the decrypted value matches a value in another table. I would like the procedure to be modified to perform a bulk insert, instead of opening and closing…
erikpasta2073364
  • 13
  • 1
  • 4
1
vote
1 answer

TRANSACTIONS Call Stored Procedure of another database

Related to this question: Executing a stored procedure inside BEGIN/END TRANSACTION I am calling my stored procedure via BizTalk. Because BizTalk is creating a TRANSACTION my stored procedure has no TRANSACTION handling. However, I have to call…
Mario
  • 978
  • 2
  • 11
  • 31
1
vote
1 answer

How to get performance monitor in SQL Server Mangement Studio

I just asked about performance monitor VS 2015 and got perfect answer. I wish there could be performance monitor available for SQL Server Management Studio also. Is it available for any version of SQL Server Management Studio? If yes where is it?
Leena
  • 35
  • 3
1
vote
1 answer

SQL Server not releasing memory after execution completes

I am using SQL Server 2014 Developer edition. SQL Server is running on server and it's occupied around 60 GB memory while execution and after completion of execution it's not releasing it. Please suggest on this. I want to reduce it to normal.
Dhaval Lakhani
  • 29
  • 5
1
vote
3 answers

Switch Partitioning failing due to mismatch in file groups of source and destination tables

I am trying to implement switch partitioning on one of the tables and I made sure that the partition function,scheme,file groups are working fine. But I get the file group error when I run the below command. Can someone share your thoughts on…
Teja
  • 13,214
  • 36
  • 93
  • 155
1
vote
3 answers

MS SQL 2014 TSQL pulling 3 records

I am trying to pick the 3 rows that have the 3 unique GUID's below: SELECT number AS 'ID #', line AS 'Line #', network AS Network, …
StealthRT
  • 10,108
  • 40
  • 183
  • 342
1
vote
3 answers

SQL 2014 - amalgamating rows into single row, multiple columns with CASE statements

SQL Server 2014 using T-SQL. In our database, customers have issues(!) and each issue assigned against a customer has a separate row in the table I'm querying. I'm looking to create an single row for each of these issues (along with some other…
Impresario
  • 35
  • 3
1
vote
1 answer

Can't received a result in C# code when run a Stored procedure through SqlCommend

Please find my tables, data, SP and C# code. Table structure: create table ExTest ( Id int Identity(1,1) primary key, IsDeleted BIT default 0, DeleteDate DateTime ) ===================================================== Table data: Id IsDeleted …
LTA
  • 191
  • 3
  • 16
1
vote
0 answers

SQL Server backup error. Operating system error 3(The system cannot find the path specified

I have an azure drive mapped to SQL Server. I have verified that SQL Server is using a service account called SQLBI and this account has SA access to the server and SQL Server and sees the azure drive which is mapped as the B drive. When I try to…
equipe9
  • 11
  • 1
  • 2
1
vote
1 answer

T-SQL Consider timestamp ordering to determine group

I have an interesting grouping case for which I really can't figure the best way to proceed with. I'm dealing with a lot of data so I'm trying to find the most effective way to perform my query. Here's an example of data I could have |Line …
Chris
  • 13
  • 2
1
vote
1 answer

If row exists then delete else Insert into a table using SQL Server stored procedures in SQL Server 2014

I have two tables Table1 and Table2. Now I want to write a stored procedure where if the record exists it will delete that record and if the record doesn't exists then it will insert the record. NOTE: I don't have any primary key in the table. I may…
user2885188
  • 11
  • 1
  • 3
1 2 3
…
99 100