GitHub

user-defined-functions-and-stored-procedures.md

Use ADOMD.NET server objects to create user defined function (UDF) or stored procedures for Microsoft SQL Server Analysis Services. With ADOMD.NET server objects, you can create user defined function ...
GitHub

clr-table-valued-functions.md

CLR Table-Valued Functions [!INCLUDE SQL Server] A table-valued function is a user-defined function that returns a table. Beginning with [!INCLUDE ssVersion2005], [!INCLUDE ssNoVersion] extends the ...
Visual Studio Magazine

A CLR Alternative to the SQL Server ISNUMERIC function

Recently I encountered a problem in a stored procedure that was caused by an unexpected result from the SQL Server ISNUMERIC() function. I was using SQL Server 2008 R2 but the issue has long been ...
Redmond Magazine

Speed Up SQL Server Apps

Developers love database programming tips, tricks, and workarounds—especially those that slash development time or boost application performance. Here's a collection of such nuggets for developing SQL ...