Quick tips for backing up and restoring Azure SQL databases:
Category: SQL rss
Posts
Is it possible for a SQL table’s index to get fragmented even if its data doesn’t get updated, inserted or deleted?
Creating successful SQL indexes is an art. I was reminded of this recently when I was looking at the indexing of a set of reporting tables, with each table expected to accommodate 100 million record.
Long story short - be careful when using Linq that you don’t include calculated fields in your where clauses, or if you do make sure you know how the query is being executed.