AZURE DATA STUDIO NOT SHOWING ALL ROWS AFFECTED IN A QUERY

Question

I am using Azure Data Studio notebook to query an Azure database. On some of the queries, it will say that it runs 96 rows for example, but only shows 8. I run the same query in SSMS and it shows all 96 rows. What's going on here? The query size is not that great either, and some more expensive queries run fine in ADS while others have this error.

Version: 1.47.1 (system setup)Commit: b6f7beb01f92adaa4b79b6b6f3ac704e95cafe6e Date: 2024-01-10T02:15:02.628Z VS Code: 1.82.0 Electron: 25.8.4 Chromium: 114.0.5735.289 Node.js: 18.15.0 V8: 11.4.183.29-electron.0 OS: Windows_NT x64 10.0.19045

Answer 1

ADS has an option to provide feedback directly to that team. You should report it to them. You can also find it here. However it is very important that you report issues using the provided menu option in the application. It captures important information about your install that they need.

To save you some time be aware that ADS is notorious for mangling query results. It sometimes doesn't render anything or partially renders some things. If you have multiple query windows open then it gets worse. In many cases if you are running a query in one window and you switch to another window it doesn't show the results of the other window until the running query finishes. There are lots of issues with it. Even worse is that updates tend to break things that previously worked but fix new issues. It's like whack-a-mole in my experience. That is one reason why I teach database programming using SSMS but personally use ADS for basic querying and switch to SSMS when ADS starts having issues.