contact.lash | SQLServerCentral

contact.lash

Forum Replies Created

Viewing 4 posts - 1 through 5 (of 5 total)

RE: Query Performance Impact due to FOR XML PATH and Large Data

Sergiy - Wednesday, July 18, 2018 2:42 AM
That's because you're using a correlated subquery in SELECT part of the query.Try to make...

July 18, 2018 at 6:41 pm

#1998134
RE: Query Performance Impact due to FOR XML PATH and Large Data

Chris Harshman - Wednesday, July 18, 2018 6:45 AM
I notice you have a GROUP BY clause at the end, how many rows...

July 18, 2018 at 6:38 pm

#1998133
RE: Query Performance Impact due to FOR XML PATH and Large Data

SGT_squeequal - Wednesday, July 18, 2018 1:22 AM
could you post the indexes and execution plan?
I have attached the exe plan. I have...

July 18, 2018 at 6:36 pm

#1998132
RE: Reading XML data from SQL Table

Hi Eirikur,
Thank you for your response.
I was able to load the file into SQL, the issue is how can i read the structure nodes? as you can...

October 25, 2017 at 3:28 pm

#1965241

Viewing 4 posts - 1 through 5 (of 5 total)