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.

 All Forums
 SQL Server 2000 Forums
 SQL Server Development (2000)
 Performance Resolution

Author  Topic 

RoyalSher
Yak Posting Veteran

95 Posts

Posted - 2003-04-23 : 03:03:15
hth,

I have a typical situation, here it goes as a doubt....

Is it advisable to have identical entities [tables] in the same or different database[s] to resolve performance issue ?

Ne advice on this is highly appreciated.





RoyalSher.
*********
The world is the great gymnasium where we come to make ourselves strong.

ValterBorges
Master Smack Fu Yak Hacker

1429 Posts

Posted - 2003-04-23 : 08:38:16
I think you refer to horizontal partioning

http://www.sqlteam.com/item.asp?ItemID=12458
http://www.sqlteam.com/item.asp?ItemID=1498
http://www.sqlteam.com/item.asp?ItemID=684
http://www.sqlteam.com/item.asp?ItemID=751

Go to Top of Page
   

- Advertisement -