A Fine Slice Of SQL Server
Grant Fritchey shows us that Azure SQL Database does not support trace flags at this time:
Bad news. The error message is the same.
Working within Azure SQL Database, trace flags are not a part of your tool set.
Everything with Azure needs a timestamp. Come back in a year and this may be different.
Comments closedGail Shaw on how clustered indexes do not guarantee physical order:
Do indexes (clustered or non-clustered) define the physical storage order of the rows?
No, absolutely not.
What indexes do is provide a logical ordering, a collection of pointers, that allow the storage engine to retrieve data from an index ordered by the index key, but that’s logical ordering, it specified nothing regarding the physical ordering.
Read the whole thing.
Comments closedCurated SQL is a simple premise: act as a clearinghouse for high-quality SQL Server material. Basically, we want to distill the tremendous number of articles and blog posts and make it easy for you to find the best of the web. This is a curated site, so all posts are lovingly hand-crafted, with nary a bot to be found.
If you want to learn more, read our About page. Also follow us on Twitter. And then, scroll up and enjoy the show.
Comments closed