What concerns me a little about your approach is that you seem to be deriving information about your source data based on the date/time the job runs.

Would it not be...

SQL!$@w$0ME (4/22/2016)

---

We are using project deployment model for SSIS. For one of the packages, which writes the log to a UNC path, I get the error when running the package...

jonathanmarenus (4/22/2016)

---

I have an SSIS package that appears to be stopping after a ForEach Loop container. The container passes in an ID returned from a query. When no...

The walking freezer is what I want to see.

Technique #2: Make your query readable by using indentation and code="sql" tags:

SELECT DISTINCT

Systems.SiteNumber AS 'SiteNumber'

, ...

mbavabohrude (4/22/2016)

---

I Need help in optimizing the query ,

Could you please throw some techniques or any valid query for replacement of this query . Help is highly appreciated as i...

j-1064772 (4/21/2016)

---

The C# bit I got from a colleague at the office who has considerably more experience than I do.

He was referring to the specific cases a dictionary structure so...

There's a lot going on here and I understand your confusion. There are several moving parts. I'll do my best to clarify some things – if anyone sees any errors...

j-1064772 (4/21/2016)

---

Having said that, C# includes very efficient dictionary structures that can be used to process data way faster than the SQL Server can, if the network can handle the...

SQL006 (4/21/2016)

---

Thank you guys

No i am not using dynamic SQL, just passing it to storeprocedure as a parameter which is used in 'IN' operator.

one doubt does REPLACE has any performance...

Indeed there is. But I see no string...

Alan.B (4/20/2016)

---

Con Alexis (4/20/2016)

---

I'd probably use a CROSS APPLY in this instance...

e.g.

WITH Data AS

(

SELECT 1 AS ID, '1/1/1900' AS Date

UNION ALL SELECT 2, '1/1/1900'

UNION ALL SELECT 3, getdate()

UNION ALL SELECT...

Luis Cazares (4/21/2016)

---

You just need to use REPLACE and escape the single quotes.

DECLARE @Codes nvarchar(500) = 'AZJ,CLC,AZF,DDD'

SELECT REPLACE(@Codes, ',', ''',''')

Are you doing this for dynamic sql coding? Are you aware...

VastSQL (4/21/2016)

---

Thanks Phil.

Do we need to consider these column which are more read intensive?

I had the same doubt as article mentioned, that instead of creating index just for FK column...

I see it too. Just need to reduce the height of the Connection Managers section to its minimum.

Whoever Mick is, we can be assured that his owner drew the tab...