Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
raihan26
Starting Member
8 Posts |
 Posted - 2011-10-18 : 13:56:07
|
I want all the below information for Each ServerName Corresponding to particular dateLike For Todays Date we have to get the below information for each Server(Server Name) suppose if we have 10 servers then we need the below information for todays date for all the ten servers. In the same way for tomorrow for all the ten Servers I need all this below information corresponding to that particular date. How can I represent this model.updown docs indexsize cachehits lastcommit lastoptimize lastreplicationtime presentqueries slowqueries totalqueries So I think it is One to Many relationship model. With one as date and Many means server name. |
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2011-10-19 : 04:31:05
|
| you can have a master table for server names and master calendar table for dates. then add a bridge table to relate them which will have serverid (pk in server table) and idday(pkin calendar table) and add other attributes against it.------------------------------------------------------------------------------------------------------SQL Server MVPhttp://visakhm.blogspot.com/ |
 |
|
|
|
|
|
How to represent this data model