Data files and filegroups

Hi all,

Can anyone tell me direct me to any resources on the net on SQL Server data files and filegroups. I want to manage historic data (which is about 500GB and growing) for reporting purposes. I was thinking about creating a data warehouse. But first I want to build a strong file structure for database objects like tables, views, indexes etc.

I got basic information about files and filegroups from books online but I need more juice before I start actual work.

All comments are appreciated and thank you in advance.

Yogi

Hi Yogi...is this SQL 2000 or 2005? (could be some big differences in how you want to handle things between the two...).

If 2005, respond and say so...here are some articles for 2000:

For an overview on the physical architecture and general usage, these are good:

http://msdn.microsoft.com/library/default.asp?url=/library/en-us/architec/8_ar_da2_9sab.asp

http://msdn.microsoft.com/library/default.asp?url=/library/en-us/createdb/cm_8_des_02_6epf.asp

For data placement and performance (see sub-topics also):

http://msdn.microsoft.com/library/default.asp?url=/library/en-us/optimsql/odp_tun_1_2upf.asp

For moving data:

http://www.sqljunkies.com/How%20To/B9F7F302-964A-4825-9246-6143A8681900.scuk

Performance tips:

http://www.sql-server-performance.com/filegroups.asp

Also, note that there are some special considerations sometimes for backups, administration, etc. for filegroups. Go to Books Online, move to the index tab, and type 'filegroups' in the textbox...this should bring you to the top-level filegroups item which has 10-15 sub-items...look over those too, great information there.

HTH

|||

Hey,

Thank you very much but I have gone through these links already most of them are similary to BOL.
I am still collecting information comments are welcome!

sql

Data base learning resources?

Hello:

I'm a beginner in data bases and I'm looking for data base theory,learning, preactices and another resources. Can you recommend me books, e-books, journals, web sites and communities? I'll aprreciate your help.

Thanks.

You might want to start at the top of the posts; there is a listing here.

Give a look to the discussion here. A number of good books are referenced.

|||

My latest book "Hitchhiker's Guide to Visual Studio and SQL Server (7th Edition)" (Addison Wesley) is currently holding a 5-star rating on Amazon. It has helped thousands of developers at every skill level from beginner to pro.

I've written a dozen books over the years--many written while I was at Microsoft writing the data access help topics and Data Access Guides for Visual Basic versions 2-5. In my own books I wanted to provide a more independent and comprehensive set of documentation using a style and focus that Microsoft would not permit me to use. Since I focus almost exclusively on Visual Studio and SQL Server readers don’t have to be confused by irrelevant designs or features that don’t apply in their applications.

The 7^th Edition is also designed for you--the beginner. It contains content designed to bring your skills up to speed across the wide spectrum of tools and .NET Framework classes you'll need to design, code, build, debug and deploy successful applications and server-side executables. I talk about how to design applications given your and your company's skills, requirements and constraints. I talk about how SQL Server works behind the scenes in a way that makes it easy to understand how to leverage its power. I show how to best use Visual Studio to leverage this power and how to use SQL Server Management Studio and the other SQL Server tools like the Profiler to manage the databases you create. I talk about SQL Server Express, SQL Server Compact Edition and all of the other editions as well, understanding that many readers need to leverage the free versions of SQL Server as they get up to speed or work to prototype a larger application.

Key topic coverage includes:

? Data access architectures and how to choose the best strategy for Windows Forms, ASP.NET, XML Web Services, and SQL Server CLR executables. Where do these make sense and how much will they cost to build and maintain?

? SQL Server and relational database fundamentals and inner-machinery. How does SQL Server work and why is it important that developers know?

? Making the development experience more productive through judicious use of the Visual Studio toolset, and how to know when the wizards can help.

? Using the latest ADO.NET data provider efficiently and safely.

? How to protect the security of your database–and your job–by avoiding common mistakes.

? How to build secure, efficient, scalable applications in less time with fewer resources–how to create faster code faster.

? How to leverage the potential of SQL Server CLR executables and knowing

when these features make sense.

? How to work with your DBA to maintain database integrity and security.

? Working with the new Visual Studio report controls to expose your organization’s data safely and easily with or without leveraging existing SQL Server Reporting Services technology.

The book also contains a GUID that can be used to gain access to the premium area on the book’s unique support website. There I provide additional errata and a question-and-answer area for those needing direct support from me and the other readers. The book includes a DVD that contains a wealth of examples and sample databases that illustrate the points in the book.

I hope this helps.

William Vaughn

Microsoft MVP, Mentor, Author, Dad, Granddad

Data base learning resources?

Hello:

I'm a beginner in data bases and I'm looking for data base theory,learning, preactices and another resources. Can you recommend me books, e-books, journals, web sites and communities? I'll aprreciate your help.

Thanks.

You might want to start at the top of the posts; there is a listing here.

Give a look to the discussion here. A number of good books are referenced.

|||

My latest book "Hitchhiker's Guide to Visual Studio and SQL Server (7th Edition)" (Addison Wesley) is currently holding a 5-star rating on Amazon. It has helped thousands of developers at every skill level from beginner to pro.

I've written a dozen books over the years--many written while I was at Microsoft writing the data access help topics and Data Access Guides for Visual Basic versions 2-5. In my own books I wanted to provide a more independent and comprehensive set of documentation using a style and focus that Microsoft would not permit me to use. Since I focus almost exclusively on Visual Studio and SQL Server readers don’t have to be confused by irrelevant designs or features that don’t apply in their applications.

The 7^th Edition is also designed for you--the beginner. It contains content designed to bring your skills up to speed across the wide spectrum of tools and .NET Framework classes you'll need to design, code, build, debug and deploy successful applications and server-side executables. I talk about how to design applications given your and your company's skills, requirements and constraints. I talk about how SQL Server works behind the scenes in a way that makes it easy to understand how to leverage its power. I show how to best use Visual Studio to leverage this power and how to use SQL Server Management Studio and the other SQL Server tools like the Profiler to manage the databases you create. I talk about SQL Server Express, SQL Server Compact Edition and all of the other editions as well, understanding that many readers need to leverage the free versions of SQL Server as they get up to speed or work to prototype a larger application.

Key topic coverage includes:

? Data access architectures and how to choose the best strategy for Windows Forms, ASP.NET, XML Web Services, and SQL Server CLR executables. Where do these make sense and how much will they cost to build and maintain?

? SQL Server and relational database fundamentals and inner-machinery. How does SQL Server work and why is it important that developers know?

? Making the development experience more productive through judicious use of the Visual Studio toolset, and how to know when the wizards can help.

? Using the latest ADO.NET data provider efficiently and safely.

? How to protect the security of your database–and your job–by avoiding common mistakes.

? How to build secure, efficient, scalable applications in less time with fewer resources–how to create faster code faster.

? How to leverage the potential of SQL Server CLR executables and knowing

when these features make sense.

? How to work with your DBA to maintain database integrity and security.

? Working with the new Visual Studio report controls to expose your organization’s data safely and easily with or without leveraging existing SQL Server Reporting Services technology.

The book also contains a GUID that can be used to gain access to the premium area on the book’s unique support website. There I provide additional errata and a question-and-answer area for those needing direct support from me and the other readers. The book includes a DVD that contains a wealth of examples and sample databases that illustrate the points in the book.

I hope this helps.

William Vaughn

Microsoft MVP, Mentor, Author, Dad, Granddad