I’m doing a little series on some of the nice features/capabilities in Snowflake (the cloud data warehouse). In each part, I’ll highlight something that I think it’s interesting enough to share. It might be some SQL function that I’d really like to be in SQL Server, it might be something else.
Today I have a small blog post about a neat little function I discovered last week – with thanks to my German colleague, who wants to remain anonymous. The function is called ILIKE and it is syntactic sugar for the combination of UPPER and LIKE. Let’s try it out. First we create a small table with some sample data:
Next we want to return all strings starting with “Hello”, so we whip out the LIKE function:
Alas, it returns only one row, because Snowflake is case-sensitive by default. What a treat. Normally you would use UPPER on the column (which is a bad idea in SQL Server, because then no index can be used), but here we can just use the ILIKE function:
Hooray! All three rows returned. ILIKE this function! (Sorry)
I was asked to do a review of the book Microsoft Power BI Performance Best…
This is a quick blog post, mainly so I have the code available if I…
Praise whatever deity you believe in, because it's finally here, a tenant switcher for Microsoft…
This book was making its rounds on social media, and the concept seems interesting enough…
I'm hosting a free webinar at MSSQLTips.com at the 19th of December 2024, 6PM UTC.…
The slides and scripts for my session "Tackling the Gaps & Islands Problem with T-SQL…