Pulse » Recent Items from 12/9/2009
Welcome!
Pulse has a simple goal: to give you a quick view of what's happening in the SQL Server community.
-
Browse
Finding interesting content on Pulse is easy – you can drill down to a specific time period (by clicking on the bars of the chart), toggle different types of content on and off, and sort the results by popularity or recency.
-
Vote
Discovered an informative blog post or a hilarious tweet? Tell the rest of the community about it by voting it up or down. Behind the scenes, our popularity algorithm will make sure it rises to the top of the list.
-
Comment
When a simple up-or-down vote isn't enough, voice your opinions in a comment. Or check out what others are saying about something you posted or tweeted.
-
Splitting A Delimited String (Part 2)
This is part two of a two part series. In part 1 of this series I demonstrated the most popular methods used to parse/split a delimited string of values, http://jahaines.blogspot.com/2009/11/splitting-delimited-string-part-1.html. In this article I will be focusing on the performance implications of ...
-
Splitting A Delimited String (Part 2)
This is part two of a two part series. In part 1 of this series I demonstrated the most popular methods used to parse/split a delimited string of values, http://jahaines.blogspot.com/2009/11/splitting-delimited-string-part-1.html. In this article I will be focusing on the performance implications of ...
-
Using RAW Files for Staging Data in SSIS
In my last post, I mentioned that I stored staged source system data in RAW files for SSIS as part of managing metadata changes. I knew that would be "controversial", and sure enough, the first comment on that post questioned my choice. Now I'm going to take the opportunity to ...
-
Simple vs Searched CASE statements
I recently had a customer show me an MDX calculation using a CASE statement, where they had achieved a big improvement in performance when they moved from using a searched CASE to using a simple CASE. For the record, here’s an example of a simple CASE statement: CASE [Measures ...
-
Conciseness
Mike's blog has been hijacked by a duck. ... okay, maybe not. Hi, I'm K. Brian Kelley and I am guest blogging on Mike's blog. Normally I write on security topics over at SQL Server Central, but I couldn't resist following up to this excellent blog post ...
Pulse is a section of SQLServerPedia that gives you a quick view of what's happening in the SQL Server community.