did you able to get the query ?

try this , it will show you the top most running queries for that server. hope you will able to find something....

nice question .... but Who Cares 😛

ChrisM@Work (3/4/2014)

---

Remove the index hint from the query whilst you are still testing and developing. Index hints are used when you've exhausted other, simpler, possibilities.

Add rua.userIsBound to the index...

Please post the actual execution plan as a .sqlplan file attachment.

Furthermore, If your queries have something like this :

select Col1

from Table1

UNION

select Col2

from Table2

Replace the 'UNION' with 'UNION ALL',...

Please post the actual execution plan of the problematic query as a .sqlplan file attachment.

++++1 :hehe:

you can definitely can do

select * from Table1

to

select * from AnothTable

you can achieve this through Variable of Type string.

Let say you define a...

Great to see that you made a working SSIS package with all the logic you have in your mind. 🙂

I think its a typo but need to highlighted,

I've set...

nice question. Thanks for sharing

Its all about making your mind 1st.

if you are having problem writing sql ( as per you stated) you can do the following

IF (SELECT Count(*) FROM DL_5010_5010 WHERE CallStatusZone1 =...

nice question ... thanks for sharing

you have to convert this nvarchar(4000) to xml 1st and then apply the code which i shared earlier. you cannot update the varchar field containing xml.

try this

declare @table table (id int identity(1,1), docxml xml)

insert into @table (docxml)

select CAST(N'<?xml version="1.0" encoding="utf-16"?> <InterfaceConfig xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xmlns:xsd="http://www.w3.org/2001/XMLSchema"> <Source>.</Source> <Archive>.</Archive> <Log>.</Log> ...

There is no 'vchConfig' tag available in the xml you shared. OR im missing something here ??

declare @xml as xml

select @xml = CAST(N'<?xml version="1.0" encoding="utf-16"?> <InterfaceConfig xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xmlns:xsd="http://www.w3.org/2001/XMLSchema"> <Source>.</Source> <Archive>.</Archive> <Log>.</Log> <Filter>PU*.csv</Filter> <Delimiter>"|"</Delimiter> <CreateAssets>true</CreateAssets>...