Quick thought, isnull is implemented as a case statement under the bonnet/hood, performance tends to be the same for equal statements.

😎

Jeff Moden (2/1/2015)

---

jarick 15608 (2/1/2015)

---

How about storing all of the data in XML in a compressed binary string and using and using am image datatype to store it in. ...

jwiseh (1/31/2015)

---

I remember the pain of working with a system where a developer had chosen the TIME data type to store the number of hours worked in a day....

Just like "The Evil That Men Do", but this time...

Don't know where to start, possibly EF choice of geography as varbinary(max) or XML as nvarchar(max). Other peculiarities would be Currency Exchange Rates as int, Social Security Number as datetime,...

Could you please check your data sample, somehow id doesn't look right or I'm missing something

😎

Quick question, is this ERD an accurate interpretation?

😎

...

Further on Jeff's answer, are you experiencing similar behaviour with other activities on this server? And other servers on the same network?

😎

My suggestion would be to use a Stored Procedure on the server, a SqlCommand object, set each parameter and exec.

😎

Next question, can you somehow test if this connection works outside the script task as if it doesn't then obviously the script task code will not work?

😎

Quick question, why are you using Script Task instead of ExecuteSQL for this if you have the values in local variables?

Second question, is the ADO.NET Connection correctly configured?

😎

spaghettidba (1/29/2015)

---

I don't think this is enough to exclude symbols and other characters...

Quick solution which excludes any columns with a character after the column prefix

😎

SET NOCOUNT ON;

USE tempdb;

GO

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

CREATE TABLE dbo.TBL_COUNT_COLUMNS

(

field1 ...

prasadau2006 (1/28/2015)

---

Hello Friends,

I need help with the following query, this query is taking more than 20mins to complete. I'm using a left join to

pull the data.

Query:

Insert into dbo.SecondTable

Select b.*...

Quick answer, you...