Skip to content
LobsterPot Solutions
  • About
  • Services
    • Data Platform
    • Data Analytics
    • Data Culture
  • Blog
  • Contact Us

The problem with America – spatial data

  • Post author:Rob Farley
  • Post published:November 17, 2008
  • Post category:Uncategorized
  • Post comments:4 Comments

Continue ReadingThe problem with America – spatial data

Ordered data requires ORDER BY

  • Post author:Rob Farley
  • Post published:November 16, 2008
  • Post category:Uncategorized
  • Post comments:0 Comments

Continue ReadingOrdered data requires ORDER BY

Unique Indexes with GROUP BY

  • Post author:Rob Farley
  • Post published:November 9, 2008
  • Post category:Uncategorized
  • Post comments:1 Comment

Continue ReadingUnique Indexes with GROUP BY

JOIN simplification in SQL Server

  • Post author:Rob Farley
  • Post published:November 9, 2008
  • Post category:Uncategorized
  • Post comments:1 Comment

Continue ReadingJOIN simplification in SQL Server

A few changes…

  • Post author:Rob Farley
  • Post published:October 30, 2008
  • Post category:Uncategorized
  • Post comments:2 Comments

Continue ReadingA few changes…

Missing Index in SQL Server 2008 – should try harder!

  • Post author:Rob Farley
  • Post published:October 12, 2008
  • Post category:Uncategorized
  • Post comments:12 Comments

Continue ReadingMissing Index in SQL Server 2008 – should try harder!

Doing the maths to understand SQL optimiser choices

  • Post author:Rob Farley
  • Post published:October 12, 2008
  • Post category:Uncategorized
  • Post comments:0 Comments

Continue ReadingDoing the maths to understand SQL optimiser choices

Presenting at ADNUG this week

  • Post author:Rob Farley
  • Post published:October 6, 2008
  • Post category:Uncategorized
  • Post comments:0 Comments

Continue ReadingPresenting at ADNUG this week

Congratulations, Mitch

  • Post author:Rob Farley
  • Post published:October 6, 2008
  • Post category:Uncategorized
  • Post comments:1 Comment

Continue ReadingCongratulations, Mitch

OUTPUT clause – knowing what goes in, and what you’ve accidentally taken out

  • Post author:Rob Farley
  • Post published:October 4, 2008
  • Post category:Uncategorized
  • Post comments:1 Comment

Continue ReadingOUTPUT clause – knowing what goes in, and what you’ve accidentally taken out
  • Go to the previous page
  • 1
  • …
  • 41
  • 42
  • 43
  • 44
  • 45
  • 46
  • 47
  • …
  • 63
  • Go to the next page

Recent Posts

  • Outages to remember
  • Temp tables – a blessing or a curse?
  • SQL 2025 showing crazy-high CPU
  • Signs of potentially-bad code
  • Forgotten skills that could become critical

Recent Comments

  1. Rob Farley on Ageing code
  2. Rob Farley on String parsing
  3. Hugo Kornelis on Ageing code
  4. Thomas Franz on String parsing
  5. John Sterrett on The younger generation in the SQL community

Ready to Feel Good About Your Data? Let’s Start the Conversation.

Email

contact@lobsterpot.com.au

Call

0431 972 770

Linkedin Twitter

Sitemap

  • About
  • Services
  • Blog
  • Contact
  • Privacy Policy

Services

  • Data Platform
  • Data Analytics
  • Data Culture
Microsoft Gold Partner

© All rights reserved

Designed by Paper Sword B2B

Some of LobsterPot Solutions’ consultants are members of the Australian Computer Society’s Professional Standards Scheme for Certified Professionals, and to the extent that applies, the following statement applies to them. If you have questions regarding this, please raise them with our director, Rob Farley.
Liability limited by a scheme approved under Professional Standards Legislation.

  • About
  • Services
    • Data Platform
    • Data Analytics
    • Data Culture
  • Blog
  • Contact Us