/explore
|
You are here 
|
blog.crossjoin.co.uk | ||
| | | | |
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... |
|
| | | | | ||
| | | | |
datasavvy.me
I have a client who was upgrading some servers from pre-2022 versions of SQL Server to SQL Server 2022 CU7. They had some multidimensional SSAS cubes that were to go on the new server. But they ran into an issue after the upgrade. After restoring a backup of an SSAS database to the new server... |
|
| | | | | ||
| | | | |
gqbi.wordpress.com
Last week there was not a lot on the go, but it seems to have picked up this week, so here are the latest insights. Power BI - August Power BI Desktop Update As I am sure some of you would have already seen and heard and I personally have to echo what other people... |
|
| | | | | ||
| | | | |
curatedsql.com
|
|
| | | |||
