The LobsterPot Blog
Insight and opinion from our team of data platform experts.
Featured Blog
AI and SQL
Pinal Dave (@pinaldave), who might always exist in my mind as the person who took me to a KFC in Bengaluru, asks us about how
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
A moving time…
For those of you who read my blog using RSS, you probably won’t even see this post, but either way. I’ve decided to move my
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
