Quick solution

😎

USE tempdb;

GO

SET NOCOUNT ON;

if object_id('Tempdb..#Element1') is not null drop table #Element1;

create table #Element1 (

[Attr1] varchar(10)

,[Attr2] varchar(4)

,[Attr3] varchar(2)

...

Does the 2008 db pass the integrity check?

😎

John Rowan (10/5/2015)

---

Number(38) is much larger than integer and I don't think they play nice together with implicit conversions. The error looks like it's happening on your destination component...

Quick solution

😎

USE tempdb;

GO

SET NOCOUNT ON;

DECLARE @TableA TABLE

(

FldA INT NOT NULL

,FldB INT NOT NULL

);

INSERT INTO @TableA(FldA,FldB)

VALUES (3,4)

...

Grant Fritchey (10/5/2015)

---

You can give the files any extension name, but it's the path and security to that path that are going to make the difference. Before you run the...

Quick question, can you post the DDL (create table script) for those two tables?

😎

chancrovsky (10/5/2015)

---

I've been reading about the protocols and i've been trying to connect to my SQL SERVER using each one of the protocols, but i think I'm missing something, i...

Are you certain those are full backups and not transaction log...

Quick questions, are the backups successful (check the log)? Any cleanup tasks scheduled or running? Is it the right drive?

😎

Thanks Jason, nice job testing this.

😎

Quick suggestion, have a look at this article When is a Seek not a Seek? by Paul White, sounds...

erb2000 (10/4/2015)

---

Our application has serious problems after upgrading to Sql Server 2014. We tracked it down to the huge IN clauses running very slowly. It's not easy to...

Two possible solutions

😎

USE tempdb;

GO

SET NOCOUNT ON;

--- First Create two tables

IF OBJECT_ID(N'dbo.tabA') IS NOT NULL DROP TABLE dbo.tabA;

CREATE TABLE dbo.tabA

(

cola1 NVARCHAR(100) NULL

,cola2 NVARCHAR(100) NULL

...

Quick question, can you supply some more details, the data and query posted need a little bit more explanation as the result is simply a Cartesian produce of the two...

sqllearner1234 (10/3/2015)

---

I'm using this to create a view for duplicates , but no of records coming out of this view are more than I'm passing in:(this query works fine in...