Take the 2-minute tour ×
Database Administrators Stack Exchange is a question and answer site for database professionals who wish to improve their database skills and learn from others in the community. It's 100% free, no registration required.

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.

share|improve this question

closed as off-topic by Paul White, tblPhil, Aaron Bertrand Jan 26 at 14:44

This question appears to be off-topic. The users who voted to close gave this specific reason:

  • "Shopping list question - questions about which tool, library, product or resource you should use are off-topic here because they quickly become obsolete and often are just about the preferences of the answerer. If you have an issue with or a question about a specific tool, please revise your question to conform to that scope." – Paul White, tblPhil, Aaron Bertrand
If this question can be reworded to fit the rules in the help center, please edit the question.

2 Answers 2

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.

share|improve this answer
    
Of course I know SSMS, but I was looking for something more precise like column space allocation, and so on... I'll give you my point because I could easily be misunderstood (as you did). –  alcor Aug 23 '12 at 20:58
    
Why not just edit your question and be more specific on what you were looking for, instead of just taking the answer I provided? It will allow the question to hold more worth on the site and it won't hurt my feelings at all... –  Shawn Melton Aug 24 '12 at 3:11
    
thank you :) I didn't know if it was right (according to the site rules). –  alcor Aug 24 '12 at 16:01

I really like Idera's SQL Diagnostic Manager, although it's pretty pricey. SQL Diagnostic Manager has taught me that I can typically use the system DMVs to get the answer I'm looking for. If I persist enough, there is usually a way of finding out exactly what you want.

share|improve this answer

Not the answer you're looking for? Browse other questions tagged or ask your own question.