jwcolby
jwcolby at colbyconsulting.com
Sun Sep 2 12:22:23 CDT 2012
I hate to say it but SQL Azure is just the cloud counterpart to SQL Server. There are a millions of local SQL Server instances which can use help in things that TSQL is not optimized for. In my specific case today, I have a field in a table returned to me by third party software. This field has one or more (up to 6 or 8 possibly) comma separated error codes. I need to split these error codes and analyze them against a table of these error codes and make decisions about what to do with the record based on these codes. Simple right? Except I have to do this against a billion records a month. Suddenly doing this the RBAR way or in fact any way which isn't waaaay speedy is a non-starter. C# is optimized for these kinds of string functions and can provide among the fastest possible solutions (or so I am reading). As it happens, I do not use SQL Azure nor do I intend to anytime in the near future so I am not making decisions like this based on whether SQL Azure supports my solution. I think that you are right, it is not mainstream, though I suspect that much of the reason is that SQL Server types are not C# programmers and so it is not familiar to them. As a developer with a foot in both camps it seems a natural fit for me. John W. Colby Colby Consulting Reality is what refuses to go away when you do not believe in it On 9/2/2012 4:32 AM, Adam Cogan www.ssw.com.au wrote: > It is definitely not mainstream John. None of our customers are using it. > > Now that it is not supported in SQL Azure I would *not* use it > > Adam Cogan www.ssw.com.au www.twitter.com/adamcogan +61 4 1985 1995 > > -- In Austria (no kangaroos here), then Germany, Bulgaria and Croatia > -- Sent from my super cool iPad 4 beta > > > On 2 Sep 2012, at 02:59 PM, "jwcolby" <jwcolby at colbyconsulting.com> wrote: > >> Just a poll to see if anyone on the list is using the CLR in SQL Server. I do a lot of C# work now and mostly to automate SQL Server. I have not been using the CLR in SQL Server but I am ready to figure it out. >> >> Anyone? >> >> -- >> John W. Colby >> Colby Consulting >> >> Reality is what refuses to go away >> when you do not believe in it >> >> _______________________________________________ >> dba-SQLServer mailing list >> dba-SQLServer at databaseadvisors.com >> http://databaseadvisors.com/mailman/listinfo/dba-sqlserver >> http://www.databaseadvisors.com >> > > _______________________________________________ > dba-SQLServer mailing list > dba-SQLServer at databaseadvisors.com > http://databaseadvisors.com/mailman/listinfo/dba-sqlserver > http://www.databaseadvisors.com > >