Does an analysis/optimization tool like SqlYog exist for SQL Server 2005 (and later)? I'm curious about effective space allocation of my tables, so:


does something like SqlYog exist for SQL Server 2005 (and later)?


Of course I know SSMS, but I was looking for something more precise like column space allocation, and so on... I'd like to find a tool for analysis and optimization of structures and queries.
Microsoft provided, for free, SQL Server Management Studio (SSMS) starting with SQL Server 2005. Is it not exactly like SqlYog but there are similarities. With regards to table space I would direct you to the Standard Reports that were added to SSMS after SQL 2005 SP2. They provided a more eye friendly look at allocation of space, index usage, performance information, etc.