Grant Fritchey (9/21/2015)

---

There are only 38k distinct values in a data set of 25 million. Add to that the fact that you're selecting a broad swath of those values. Assuming...

BOR15K (9/21/2015)

---

Hello,

Can one advise if it is possible to fully validate an XML file based on its XSD Collection please?

I do have an XSD Collection myCollection and then I validate...

Quick question, do you need an actual number...

That's quite an antique collection you got there, not certain if the backup is your real problem!

😎

Is the third party...

thomashohner (9/20/2015)

---

Hello All,

I am trying to do a very small numbers table to compare A1c's against. However I am running into a issue when recursion hits the number 2.27 it...

Quick thought, I've used free tds, http://www.freetds.org/ for years, many of my workstations are Linux/Unix and freetds provides the equivilent of sqlcmd, works quite well (most of the time:-D). Does...

Is anyone memory optimized?

😎

I've reproduced the 64/65 split using a small set of 1,000,000 rows with much higher duplication on the key than in your set, roughly 4 times higher. The difference between...

Jason A. Long (9/20/2015)

---

It's simply a renamed version of Jeff Moden's DelimitedSplit8k function. It was renamed to...

Jason A. Long (9/19/2015)

---

I won't call this an elegant solution by any stretch of the imagination, but it's the only "1:00 am" solution that's coming to mind at the moment...

IF...

vijayu (9/20/2015)

---

Hi,

I tried so hard to recreate the error 833, through simulation using different suggested method. But was not successful. Can I manually add it in the error log of...

My suspicion is that this has more to do with the selectivity, that is the number of duplicate key values in the nonclustered index.

😎

What is the output of this query?

SELECT

...

shamshad.ali (9/18/2015)

---

I have two tables for insertion in one transaction scope. Table one have 10 rows. After first table insert statement (not yet committed) if I run select on first...

No, the stats are accumulative, you will have...

vincenzo.capelli (9/19/2015)

---

Hi,

I have this task, I have to copy from one database into a remote all record which contain a specific value into a specific column. (the remote Db destination...