3 ms·
isqlw (aka SQL Query Analyzer), the client for Microsoft SQL Server 2000 had an amazing visual explain tool. To this day, that's probably my favourite ever GUI
by petepete 7y ago
isqlw (aka SQL Query Analyzer), the client for Microsoft SQL Server 2000 had an amazing visual explain tool. To this day, that's probably my favourite ever GUI SQL client, it was just so damn responsive and well-thought-out. I never made the switch to SQL Server 2005 so never really properly tried the later Visual Studio-esque version, but it seemed slow by comparison.
Screenshots:
https://www.sqlshack.com/wp-content/uploads/2016/09/machine-generated-alternative-text-execution-plan.png https://www.sqlshack.com/wp-content/uploads/2016/09/machine-...
- manigandham 7y agoSQL Server Management Studio still has a great GUI for query plans and the database engine reveals more than ever. There's also Azure Data Studio for a cross-platform version: https://docs.microsoft.com/en-us/sql/azure-data-studio/what-is https://docs.microsoft.com/en-us/sql/azure-data-studio/what-...