http://www.sqlservercentral.com/Content tagged SQLCLR posted on SQLServerCentral.comen-us360sjones@sqlservercentral.com (Steve Jones)Build an application to extract a query's estimated execution cost from its XML showplan. Users can submit only those queries costing less than a predetermined threshold to a server running SQL Server 2005, thereby ensuring it is not overloaded with costly, long-running queries.http://www.sqlservercentral.com/redirect/articles/63710/2008/08/08http://www.sqlservercentral.com/redirect/articles/63710/Using the new SQLCLR feature, managed code can use ADO.NET when running inside SQL Server 2005. Learn about SQLCLR via basic scenarios of in-process data access, SQLCLR constructs, and their interactions.http://www.sqlservercentral.com/redirect/articles/63191/2008/07/04http://www.sqlservercentral.com/redirect/articles/63191/We occasionally come up with a requirement that would be a good fit for a CLR function or stored procedure. For instance we would like to call a stored procedure to get the list of files in a particular folder. How can we return the list of files as a standard result set (i.e. rows and columns) using the CLR?http://www.sqlservercentral.com/redirect/articles/63454/2008/06/30http://www.sqlservercentral.com/redirect/articles/63454/The CLR has not been well-received and most people use it for Regular Expressions and string functions. Here is an example that goes beyond trivial uses.http://www.sqlservercentral.com/articles/SQL+Server+2005/63300/2008/06/24http://www.sqlservercentral.com/articles/SQL+Server+2005/63300/http://www.sqlservercentral.com/questions/SQLCLR/63122/2008/06/19http://www.sqlservercentral.com/questions/SQLCLR/63122/http://www.sqlservercentral.com/questions/SQLCLR/62949/2008/06/02http://www.sqlservercentral.com/questions/SQLCLR/62949/http://www.sqlservercentral.com/questions/SQL+Server+2005/62478/2008/04/02http://www.sqlservercentral.com/questions/SQL+Server+2005/62478/