3 ms·

You have been able to split strings in t-sql forever. The link you are referring to splits a string by a delimiter and returns the result as a table. I've also

by NDizzle 10y ago

You have been able to split strings in t-sql forever. The link you are referring to splits a string by a delimiter and returns the result as a table. I've also used CLRs in production since SQL Server 2005. Not sure which circles you run in, but it's quite different than what I've seen. I also use Service Broker, so maybe I'm just an odd duck?!

mistermann 10y ago
> You have been able to split strings in t-sql forever. The link you are referring to splits a string by a delimiter and returns the result as a table. Generally ones wants to either extract the Nth element from a delimited string, or convert a delimited string into a table, are you thinking of a different scenario? Somewhere on an official Microsoft page, there is something to the effect that SQLCLR is "not recommended", which gives your typical DBA a perfect excuse to say "no", with no interest in the particulars of why Microsoft might have written that warning.
EvanAnderson 10y ago
In my experience the fact that you even know the words "Service Broker" makes you an odd duck. (My company uses the heck out of it, BTW... It boggles my mind that it's so unknown to most developers using the Microsoft SQL Server platform.)
- mistermann 10y ago
  What's an example use case for Service Broker?
  - EvanAnderson 10y ago
    Asynchronous processing. Service Broker has a queue-based metaphor and it can execute stored procedures asynchronously when new messages arrive. I gnash my teeth every time I see problems "solved" by the "we'll just poll the database periodically for changes" pattern that could be better-served by Service Broker. Service Broker performs store-and-forward reliably message delivery inside a single SQL Server instance and between instances (on the same machine or over a network). The inter-instance delivery is particularly nice insofar as that it can use certificates for authentication (which is very nice when you have disparate Active Directory environments in play). We've built a couple of system that use it and have been very pleased with the results. I can't figure out why it's so obscure. The documentation isn't terrible but it's definitely got a steep learning curve.

by NDizzle 10y ago

mistermann 10y ago

> You have been able to split strings in t-sql forever. The link you are referring to splits a string by a delimiter and returns the result as a table. Generally ones wants to either extract the Nth element from a delimited string, or convert a delimited string into a table, are you thinking of a different scenario? Somewhere on an official Microsoft page, there is something to the effect that SQLCLR is "not recommended", which gives your typical DBA a perfect excuse to say "no", with no interest in the particulars of why Microsoft might have written that warning.

EvanAnderson 10y ago

In my experience the fact that you even know the words "Service Broker" makes you an odd duck. (My company uses the heck out of it, BTW... It boggles my mind that it's so unknown to most developers using the Microsoft SQL Server platform.)

mistermann 10y ago
What's an example use case for Service Broker?
- EvanAnderson 10y ago
  Asynchronous processing. Service Broker has a queue-based metaphor and it can execute stored procedures asynchronously when new messages arrive. I gnash my teeth every time I see problems "solved" by the "we'll just poll the database periodically for changes" pattern that could be better-served by Service Broker. Service Broker performs store-and-forward reliably message delivery inside a single SQL Server instance and between instances (on the same machine or over a network). The inter-instance delivery is particularly nice insofar as that it can use certificates for authentication (which is very nice when you have disparate Active Directory environments in play). We've built a couple of system that use it and have been very pleased with the results. I can't figure out why it's so obscure. The documentation isn't terrible but it's definitely got a steep learning curve.