More generalized matching is exactly what I always wanted, and...

Scott D. Jacobson (12/18/2012)

---

... Maybe changing the entire model is in order. Maybe it should be pay-per-feature. At least they need to consider something different in this...

The new licensing model is hurting Microsoft’s own business in the long run. Profit can be made in several ways, especially for software the best way is to have a...

shalinder.verma (12/5/2012)

---

Thanks Chris for a quick reply.

This looks to me that we are breaking a string in multiple rows and then putting the components back on the same row using...

Yes, 10% growth is a horrible setting as well.

Try to grow with fixed size chunks of 256MB-1024MB instead (depending on your database growth expectation).

For log files, set an upper...

I haven't read the article properly and just scanned it to see what it is about and if it is interesting.

But one thing I noticed quickly was a quote at...

I am of the opinion this sort of logic should be implemented in some sort of foreign keys check constraint (never seen it being present in a relational database, but...

Steve Jones - SSC Editor (9/18/2012)

---

Miles Neale (9/18/2012)

---

Of those zillion of bytes of data it would be interesting to determine what amount of that data is in relational databases incased...

Usman Butt (9/11/2012)

---

peter-757102 (9/11/2012)

---

Having to specify collations everywhere would make the function cumbersome to use. It might even throw off the optimizer in not using indexes due to collation...

The recent discussion has hit an interesting topic, namely that of collations. While I can subscribe to the idea that it is ok for the delimiter being compared by binary...

I learned something today, several things in fact, thus today is a very good day for me.

Thanks to you Paul!

I did not even knew this existed, but if it is faster, it might...

Usman Butt (8/3/2012)

---

peter-757102 (8/2/2012)

---

I did some timings on my own using the code in the article and as expected the time the baseline and the iTVF take are identical. Not...

I did some timings on my own using the code in the article and as expected the time the baseline and the iTVF take are identical. Not surprisingly I get...

It would be interesting to see how this simplified example function performs against a view with a cross join to a tally table providing the parameters. If you know paramaters...