|
|
|
SSC-Enthusiastic
      
Group: General Forum Members
Last Login: Tuesday, April 23, 2013 5:42 PM
Points: 192,
Visits: 506
|
|
| Wow, I wish I had known that earlier.
|
|
|
|
|
SSC-Dedicated
           
Group: General Forum Members
Last Login: Today @ 2:17 PM
Points: 32,895,
Visits: 26,777
|
|
mpradeep23 (12/14/2012) Is thier any other tools before creation of the tables logical diagram
Heh... cocktail napkins and beer coasters!
--Jeff Moden "RBAR is pronounced "ree-bar" and is a "Modenism" for "Row-By-Agonizing-Row".
First step towards the paradigm shift of writing Set Based code: Stop thinking about what you want to do to a row... think, instead, of what you want to do to a column."
For better, quicker answers on T-SQL questions, click on the following... http://www.sqlservercentral.com/articles/Best+Practices/61537/
For better answers on performance questions, click on the following... http://www.sqlservercentral.com/articles/SQLServerCentral/66909/
|
|
|
|
|
Hall of Fame
       
Group: General Forum Members
Last Login: Today @ 2:04 PM
Points: 3,574,
Visits: 5,110
|
|
Jeff Moden (12/18/2012)
mpradeep23 (12/14/2012) Is thier any other tools before creation of the tables logical diagramHeh... cocktail napkins and beer coasters!
HAH!! Yep - that is about all I use for "logical" modeling too! 
I have used Embarcadero's ERStudio for probably a dozen years now. Incredible capabilities, and if you purchase a SQL Server only license it is very reasonably priced for the functionality it brings to the table (pun intended).
Best,
Kevin G. Boles SQL Server Consultant SQL MVP 2007-2012 TheSQLGuru at GMail
|
|
|
|
|
SSCrazy
      
Group: General Forum Members
Last Login: Today @ 7:06 AM
Points: 2,621,
Visits: 2,756
|
|
Be aware that the SQL Server database diagram is a live representation of the database. If you drop a table from the diagram it is dropped from the database, so use this tool with care. It can be safer to stick with the cocktail napkins and beer coasters, plus using a phone camera to capture significant versions.
Author: SQL Server FineBuild 1-click install and best practice configuration of SQL Server 2012, 2008 R2, 2008 and 2005. 25 March 2013: now over 23,000 downloads. Disclaimer: All information provided is a personal opinion that may not match reality. Concept: "Pizza Apartheid" - the discrimination that separates those who earn enough in one day to buy a pizza if they want one, from those who can not.
|
|
|
|