Browse by Tags

• Performance
• Prime number challenge

• Just stuff it!

  I’m sure you’ve all heard it, and probably even said it, many times: “SQL Server sucks at string manipulation”. And with good reason – it is true. But not quite as true as many seem to believe. I notice that many people who complain about SQL Server lacking Read More... Posted Thursday, October 12, 2006 8:50 PM by Hugo Kornelis | 12 Comments Filed under: Tricks, T-SQL

• The prime number challenge – great waste of time!

  No sane person would even consider using SQL Server to construct a list of prime numbers. So just to prove that I’m not sane (as if there could be any doubt!), this post will be about finding prime numbers. First a bit of history. Ward Pond wrote about Read More... Posted Saturday, September 23, 2006 10:54 PM by Hugo Kornelis | 9 Comments Filed under: Performance, Prime number challenge, Tricks, T-SQL

• Relating unrelated rows

  A recurring question in the newsgroups is: “How do I output unrelated rows side by side?” I’ll use the AdventureWorks database as an example. Suppose that my manager wants a report listing, for each order, all products ordered and all reasons the customer Read More... Posted Friday, July 14, 2006 10:23 PM by Hugo Kornelis | 3 Comments Filed under: Performance, Tricks, T-SQL