Adam Machanic, Boston-based independent database consultant, writer, and speaker, shares his experiences with programming, performance tuning, and optimizing SQL Server 2000, 2005, and 2008, in conjunction with related technologies such as .NET.
April 2009 - Posts
-
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 Read More...
|
-
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. Read More...
|
-
Update: Please respond here instead . Thanks for the great idea, Alex! Please respond and let me know: A) Whether you change it at all and B) If so, whether you use a fixed width font (the default font is non-fixed width) Background, in case you're curious: Read More...
|
-
TechEd North America 2009 is just a few short weeks away, and I'm really looking forward not only to the show, but also the opportunity to visit Los Angeles for the first time in several years. I'm busy putting the finishing touches on my Extended Events Read More...
|
-
Ever tried writing a more or less database-agnostic administrative script? If the experience didn't make your head spin, you either have a stronger constitution than most DBAs or your script doesn't actually work properly. The fact is, due to the way Read More...
|