In an earlier post I explained how I was fetching an RSS feed from SharePoint behind an https layer using cURL and PHP. In this post I’ll show how I parsed the feed.
I came across a question on Stack Overflow in which an individual asked what using INCLUDE with your INDEX does.
Recently I encountered a table of astronomic size. The table is 27.7 GB with ~32.8 million rows. The table only had a single index and the query (below) fetches 4 columns using 3 aggregates filtering the last 6 months from… Continue Reading