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

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

...