THE SQL Server Blog Spot on the Web

Welcome to SQLblog.com - The SQL Server blog spot on the web Sign in | |
in Search

Browse by Tags

All Tags » SQLCLR   (RSS)
  • Re-Inventing the Recursive CTE

    Working with hierarchies in SQL Server never fails to be absolutely fascinating. On the face of things they’re super-easy to model and seem to fit perfectly well: parent_key, child_key, self-referencing FK, and you’re done. But then you go to query the thing and there is a complete breakdown. Prior to SQL Server 2005 the product included zero ...
    Posted to Adam Machanic (Weblog) by Adam Machanic on April 7, 2015
  • CloudSeeder: CLR Stored Procedures For Creating CPU Pressure

    Sometimes, in the interest of testing various scenarios that your server might encounter, it's useful to be able to quickly simulate some condition or another. I/O, memory, CPU pressure, and so on. This latter one is something I've been playing with a lot recently. CPU pressure in SQL Server creates all sorts of interesting side-effects, such as ...
    Posted to Adam Machanic (Weblog) by Adam Machanic on October 23, 2012
  • T-SQL Tuesday #001: Exploring "Fuzzy" Interval Islands Using SQLCLR

    When working with time intervals, we often want to ask a couple of basic questions: Which time periods are not covered by our intervals? These are known as ''gaps''. What are the time ranges that we are fully covering? These are known as ''islands''. If you're unfamiliar with ''gaps'' and ''islands'' I highly recommend reading some ...
    Posted to Adam Machanic (Weblog) by Adam Machanic on December 8, 2009
  • SQLCLR String Splitting Part 2: Even Faster, Even More Scalable

    Two days ago, after posting what I thought was a pretty solid SQLCLR string splitting method, I received a comment telling me about a big thread on SQLServerCentral dedicated to the question of how best to split strings. So I jumped in, and went back and forth, and back and forth, and back... and forth... Many, many messages and several ...
    Posted to Adam Machanic (Weblog) by Adam Machanic on April 28, 2009
  • Faster, More Scalable SQLCLR String Splitting

    It seems like every couple of months we see yet another post on SQLCLR string splitting routines. Many bloggers, I suppose, are still struggling, even three years later, to find that ''perfect'' use case for SQLCLR. Is string splitting it? Probably not. And with SQL Server 2008 table-valued parameters now available, SQLCLR string splitting has ...
    Posted to Adam Machanic (Weblog) by Adam Machanic on April 26, 2009
  • Running sums yet again: SQLCLR saves the day!

    Back again!  Fourth post for the month of February, making this my best posting month in, well, months.  Expect this trend to continue.After yesterday's post on running sums and the evils of cursors, Jamie Thompson came up with a faster solution than the curser I posted.  Alas, Jamie's solution uses an undocumented form ...
    Posted to Adam Machanic (Weblog) by Adam Machanic on February 28, 2006
Privacy Statement