DTS, DTS packages, Merge replication, Reporting Services, SQL 2000, SQL 2005, SQL Anywhere Studio/M-Business Anywhere/Avantgo, SQL database, SQL error messages, SQL Express, SQL Query Analyzer, SQL scripts, SQL Server 2000, SQL Server 2003, SQL Server 2005, SQL Server 2005 (64-bit), SQL Server 2008, SQL Server 7.x, SQL Server administration, SQL Server backup, SQL Server clustering, SQL Server database, SQL Server Enterprise Manager, SQL Server errors, SQL Server Express, SQL Server import/export, SQL Server installation, SQL Server integration/interoperability, SQL Server logs, SQL Server Management Studio, SQL Server migration, SQL Server performance, SQL Server performance tuning, SQL Server replication, SQL Server reporting, SQL Server Reporting Services, SQL Server security, SQL Server stored procedures, SQL Server transaction logs, SQL Server upgrades, SQL stored procedures, SQL tables, SSIS, SSRS, SSRS 2005, Standard Edition, Standard Edition 2000, T-SQL, T/SQL >>VIEW ALL TAGS
Filegroup in SQL Server 2005
I have very large tables (5,000,000 records each year) which are frequently joined to each other, should I put each of them on a different filegroup? what about their indexes which are used in join conditions?
View Answer
| Jan 1 2008 4:53 AM GMT
| asked by
Gerayeli
Filegroup, Index, SQL Server 2005
From SearchSQLServer.com
→ Learn how to configure Database Mail in SQL Server 2005 to send mail
→ Secure SQL Server from SQL injection attacks
Related Member Blogs
SQL Server with Mr. Denny
Insight into Microsoft SQL Server that will help you build and maintain a rock solid database server.
RDBMS in Oracle/SQL
Learn the aspects of RDBMS (relational database management system) and its execution in Oracle/SQL.
Views from the P.I.T.
People in IT: Bringing the human element back into the IT profession, by Suzanne Wheeler.
