THE SQL Server Blog Spot on the Web

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

Browse by Tags

All Tags » performance » CLR   (RSS)
  • Splitting a list of integers : another roundup

    Last August, I wrote a lengthy post about how I handle splitting up a list of integers that are passed into a procedure as a comma-separated list.  I am still using this method today.  But since almost a year has passed, and because there have been plenty of articles written about splitting in the meantime, I've decided to try out a ...
    Posted to Aaron Bertrand (Weblog) by AaronBertrand on July 7, 2010
  • 10 lessons from 35K tps

    I’ve spent the last 6 months on a contract designing and developing a high transaction database – a couple orders of magnitude higher than the average OLTP SQL Server database. The SLA specified a hard transaction duration and the primary fetch feature required some complex business logic. That level of concurrency drives out a few lessons. Some ...
    Posted to Paul Nielsen (Weblog) by Paul Nielsen on December 13, 2007
  • Poor men see sharp - more cursor optimization

    After making my post on cursor optimization I received some comments that triggered me to do some further investigation. Adam Machanic wrote in my blog’s comments that using SQLCLR to loop over a SqlDataReader would be much faster than any T-SQL based cursor. And Erland Sommarskog wrote in a usenet thread that he has some colleagues who think that ...
Privacy Statement