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. Join them; it only takes a minute:

Sign up
Here's how it works:
  1. Anybody can ask a question
  2. Anybody can answer
  3. The best answers are voted up and rise to the top

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, Phil, Aaron Bertrand Jan 26 '15 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, Phil, Aaron Bertrand
If this question can be reworded to fit the rules in the help center, please edit the question.

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.