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...

vinodkm (4/21/2016)

---

Hi All,

Please help me to understand how to connect SSDT projects to TFS.

Actually my requirement is to keep version for SSIS packages, SSRS report and SSAS projects in TFS.

Thanks...

VastSQL (4/21/2016)

---

Hi Experts,

We have more than 100 Foreign Keys with no supporting index. Do we need to add index on all these Foreign Keys ?

Can someone help on fixing this...

Same again, but with my SELECT MAX() solution tagged on to the end.

CREATE TABLE temp (ID INT, Date DATE);

WITH E(n)

AS (SELECT...

astrid 69000 (4/20/2016)

---

Thanks so much.

I read and read and I understood. and it worked :-P:-P

Here is my code

declare @x xml

DECLARE @site_value INT;

SET @site_value = 0;

WHILE @site_value <= 1000

BEGIN

select @x =...

Here's an UPDATE version:

IF OBJECT_ID('tempdb..#test', 'U') IS NOT NULL

DROP TABLE #test;

CREATE TABLE #test

(

Id INT PRIMARY KEY

,dt DATE

...

Dhivya Elan (4/20/2016)

---

Hi Phil,

I tried using the ForEachLoop container. Here's what I did:

1) Made all my Excel Source tabs identical, by adding missing column headers (although they might not contain...

Dhivya Elan (4/20/2016)

---

Hi John

I've been trying to use the derived column transformation, unable to find a guide on how-to, that matches my requirement. I would really appreciate any helpful links....