The LobsterPot Blog
Insight and opinion from our team of data platform experts.
Featured Blog
Hekaton – the bad and the good, and a misconception
The SQL Server platform is a robust system, designed to handle data in a relational system through the “ACID” properties of transactions. That is, to
Blogs
LobsterPot Blogs
Blog posts by Rob Farley and other LobsterPot Solutions team members.
Popular Blogs
Handling special characters with FOR XML PATH(”)
SARGable functions in SQL Server
The SSIS tuning tip that everyone misses
Book Review – oldie but a goodie – Inside SQL 2005 Query Tuning and Optimization
I’ve moved my blog here (to sqlblog.com), and thought I’d start with a book review. This is a post that I’ve been meaning to write
T-SQL Tuesday #003 (Relationships): The round-up
Lots of blog posts for this month, for the first T-SQL Tuesday to leave the safe-haven of Adam Machanic’s blog. Some people obviously missed out,
The Query Optimizer’s handling of Relationships for T-SQL Tuesday #003
I’m feeling the pressure for this month’s T-SQL Tuesday, probably because I’m also the host. I’ll be posting a roll-up for it soon too, which
Invitation for T-SQL Tuesday #003: Relationships
It’s time for the third of Adam Machanic’s T-SQL Tuesdays, and this time, I’m the host. The first one, last December was on the topic
A CASE study in SARGability
A recent discussion on Twitter about a query that Denny Cherry was looking at led to this post by Josef Richberg: http://josef-richberg.squarespace.com/journal/2010/1/28/is-a-case-statement-considered-sargable.html, and I thought
SARGable functions in SQL Server
SARGable is an adjective in SQL that means that an item can be found using an index (assuming one exists). Understanding SARGability can really impact