/explore
|
You are here |
blog.crossjoin.co.uk | ||
| | | | |
curatedsql.com
|
|
| | | | | ||
| | | | |
www.desertislesql.com
With the general availability release of Fabric in November 2023, I am dedicating several posts to the features that are only in Fabric and not anywhere else. The first feature is Direct Lake. Dire... |
|
| | | | | ||
| | | | |
ssbipolar.com
Important: This post was written and published in 2018, and the content below no longer represents the current capabilities of Power BI. Please consider this post to be an historical record and not a technical resource. All content on this site is the personal output of the author and not an official resource from Microsoft.... |
|
| | | | | ||
| | | | |
www.purplefrogsystems.com
Query Store is a fantastic feature of both SQL Server and Azure SQL DB. It allows you to monitor how queries execute against the database which is invaluable for troubleshooting performance issues. More than that though, it gives you the option to force an erratic query to use a particular execution plan, this helps avoid queries from running with inefficient plans and provides predictability and stability on the server. Here we can see an example of a query that hasn't been forced and the engine is free to execute it however it sees fit, as you can see, the variation... |
|
| | | |||