IT and I solved the issue.  I chose a IP for the cluster that I thought wasn't in use, but apparently it was, so the cluster would go down after...

in this case, there's only one Address element per XML column row.

The issue is that this is unstandard XML, it should have been all defined as all elements in this...

The XML is really simple - it would probably be another 100 nodes more than what's on there.

Query:

SELECT

A.SOURCE_PKEY,

XmlColumn.value('(profile/entity[@name="ADDRESS"]/attr[@name="NAME1"])[1]', 'varchar(255)') NAME1,

XmlColumn.value('(profile/entity[@name="ADDRESS"]/attr[@name="STREET"])[1]', 'varchar(255)') STREET,

XmlColumn.value('(profile/entity[@name="ADDRESS"]/attr[@name="CITY1"])[1]', 'varchar(255)') CITY1,

XmlColumn.value('(profile/entity[@name="ADDRESS"]/attr[@name="REGION"])[1]', 'varchar(255)') REGION,

XmlColumn.value('(profile/entity[@name="ADDRESS"]/attr[@name="POST_CODE1"])[1]', 'varchar(255)') POST_CODE1

.

FROM Table

 

where XmlColumn...

• This reply was modified 4 years, 6 months ago by  cmoy.

since this is an exercise in synching between machines, is it possible for me to spin up a new server not using AlwaysOn, backup/restore, then set up some sort of...

> Set NEXT USED *before* doing the SPLIT.

AH!  That was the secret sauce.  Thanks!!!

in this case, not using partitions for archiving purposes at all.

What I am using it for is for physical file allocation purposes - we want to isolate certain huge part...

adding the multisubnetfailover=true didn't do much.

Strictly using SSMS, I added the multisubnetfailover=true option in the Additional Connection Properties tab and it didn't do much. Whenever it was able to...

one table in one file on a separate windows disk (E: drive )

I'm sorry that I used the word "partition"

no, I don't have a partitioned table. Just one table on a separate partition.

this was all done way before my time.

Partitioning is not feasible at this point - what would you partition on (what would the partition function be?). I...

looks like we're headed that direction, if I have my way. I was preparing for other options in case management said no.

when I transfer the temp #t1 table to the S1 server and run everything locally on S1, the query takes about 1 minute and the number of reads is about...

Hi Lynn - Unfortunately, on my production server I have a situation where I only have 500G remaining to begin with, so its a chicken and egg thing - I...

well, it's not on the default filegroup. Hmm...why do you ask and/or what info are you looking for?

Robert Davis (7/19/2012)

---

cmoy, when you're shrinking the file, it won't resize the file until it's done moving chunks around. So you're not going to see it shrinking a little at...