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)
 How the size of a database is affecting tables

Author  Topic 

youngster
Starting Member

10 Posts

Posted - 2007-11-28 : 23:50:08
Hello,

Suppose I have a database D consisting of two table, A and B. If I run queries on A, will these be affected as B grows (i.e. become slower to execute)? I hope you get what I am trying to say here.

Cheers

tkizer
Almighty SQL Goddess

38200 Posts

Posted - 2007-11-28 : 23:55:03
It depends. Any query uses resources on the database server which means less resources for other processes or queries.

But we'd need a lot more information to answer this question for you.

Tara Kizer
Microsoft MVP for Windows Server System - SQL Server
http://weblogs.sqlteam.com/tarad/
Go to Top of Page
   

- Advertisement -