Tell me more ×
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.
up vote 1 down vote favorite

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

2 Answers

up vote 3 down vote

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
up vote 1 down vote

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

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.

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