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
 Analysis Services (2000)
 About Server..Pls I Need your opinion

Author  Topic 

DiceK-BadMan
Starting Member

12 Posts

Posted - 2007-11-11 : 22:28:56
Can too much column in a database can get the server slower?

if a server has too many database and each database has too many unwanted column each?
What will be the cause of Slow Server?

well i just have to ask..if my theory was right?

rmiao
Master Smack Fu Yak Hacker

7266 Posts

Posted - 2007-11-11 : 23:08:08
May have some impact since need fetch more pages when access table, but shouldn't toss the server down. You should check server resource usage, table fragmentation, and so. Do you rebuild index or update statistics regularly?
Go to Top of Page
   

- Advertisement -