|
|
|
|
Adam Machanic, Boston-based SQL Server developer, shares his experiences with programming, monitoring, and performance tuning SQL Server. And the occasional battle with the query optimizer.
Browse by Tags
All Tags » SQLCLR (RSS)
-
Today at TechEd in New Orleans I delivered a breakout session entitled " Data, Faster: Microsoft SQL Server Performance Techniques with SQLCLR ." This session covered a number of techniques for using SQLCLR as a query tuning tool, especially for big, Read More...
|
-
I am super-excited to visit New Orleans next month for Microsoft TechEd; it will be my sixth time speaking at the show. My session takes an in-depth look at some of the techniques I've developed for using SQLCLR modules -- and some of the great performance Read More...
|
-
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 Read More...
|
-
A couple of weeks ago I announced a two-day advanced performance seminar in New York City, which will be delivered in July. This seminar will cover SQLCLR and parallelism techniques to help you take performance well beyond the levels that typical tuning Read More...
|
-
I am pleased to announce that I will be delivering two days of training in New York City, July 14 and 15. This seminar focuses on achieving "next-level" performance--going beyond that which you can gain via normal tuning methodologies . The vehicles for Read More...
|
-
Tomorrow at 12:00 p.m. EDT (4:00 p.m. GMT) I'll be doing a webcast for the PASS Application Development Virtual Chapter . Next-Level SQLCLR: Parallel Processing and Bulk Load The power of SQLCLR as a performance tool has been well-documented at this point; Read More...
|
-
Thank you to everyone who attended my three sessions at this year's TechEd show in New Orleans. I had a great time presenting and answering the really great questions posed by attendees. My sessions were: DAT317 T-SQL Power! The OVER Clause: Your Key Read More...
|
-
This past week I've been trying out Visual Studio 2010 for SQLCLR development. Verdict: A couple of nice things, a couple not so nice. In the interest of keeping things somewhat positive around here, we'll start with the good stuff : Pre-deployment and Read More...
|
-
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 Read More...
|
-
Since the announcement of my SQLCLR pre-conference seminar at this November's PASS conference I have received a few e-mails asking for more detail about what I will be covering. In addition to the Q&A I did with PASS , I thought it might be helpful Read More...
|
-
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...
|
-
Fall is now in full swing, and after a relatively quiet several months my speaking schedule is about to jump into fairly-packed mode. Following is a list of where I'll be headed over the next couple of months: Next week I'm really excited to be teaching Read More...
|
-
I was just reviewing my calendar for the next several weeks and noticed that the Toronto SQLTeach conference is now only a few weeks away. This conference includes quite a few interesting SQL Server-related sessions , on topics ranging from best practices, Read More...
|
-
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 Read More...
|
|
|
|
|
|