Did you check the default trace for any hints?

😎

Good on you, care to share the solution?

😎

wenger.noah (11/4/2016)

---

Hi,

I have a network share folder containing 99 .csv files, all with different headers and all with quoted identifiers which I want to load into a SQL Server 2012...

jellybean (11/4/2016)

---

Hi - I'm looking for a code parser for SQL Server 2014 - ie something that I can point at a sproc or view or function and get feedback...

sgmunson (11/4/2016)

---

And here's an alternative that achieves the desired output (however conflicting with the original post that may be...), and shows the performance characteristics, as I'm guessing this sample data...

ChrisM@Work (11/4/2016)

---

This also matches the somewhat ambiguous and vague requirements:

;WITH SAMPLE_DATA(Client,fields,value) AS

( SELECT X.Client,X.fields,X.value

FROM ( VALUES

...

sgmunson (11/4/2016)

---

Your output misses Client 111, who does meet the required conditions. However, the original poster also has stated output that disagrees with their initial statement, and I've asked...

sindhupavani123 (11/4/2016)

---

My output should look like this:

Clientfields value ...

GilaMonster (11/4/2016)

---

Eirikur Eiriksson (11/3/2016)

---

GilaMonster (11/3/2016)

---

Neither page nor row compression will compress LOB columns (like XML), so it's not as easy as just ALTER INDEX (and the sp_estimate_data_compression_savings is only going...

Tommy 70494 (11/3/2016)

---

But so far, I've come up short with how to shred the XML correctly, so i can search the package definition of my list of tables. Of which...

You are very welcome.

😎

psred (11/3/2016)

---

I need to test DB compression where the SQL DB on SQL2008R2 is taking around 2TB and most of the data is XML files. So I want to test...

GilaMonster (11/3/2016)

---

Neither page nor row compression will compress LOB columns (like XML), so it's not as easy as just ALTER INDEX (and the sp_estimate_data_compression_savings is only going to estimate savings...

Can you post the full DDL, including all indices, the typical usage etc. and particularly the reason for this table being so large. Normally such a large table would be...

abhas (11/3/2016)

---

Thanks Eirikur,

your code works fine, but while inserting into TEMP_USER table, after creating username, getting issue. For first time insert it works fine but if next day again 'aarav...