filegroup

This series of articles has not touched on the topic of "restore", because once involved in this topic will involve a large number of misunderstandings, more than I can not pass an article to finish the point. In fact, I would like to use the order

Here's a concrete example: if you have a single problem file. This file has a 50MB size, and your entire database runs about billions of bytes, so it makes sense to recover a single failed file. One of the things that happens when a file or

Change database name (1) ALTER DATABASE database_name Modify Name=new_database_name (2) Sp_renamedb Olddbname,newdbname Add data files and filegroups (expand) (1) Add data file Use master Go DECLARE @data_path nvarchar (256); --Get the

This article describes the concept of table partitioning and the SQL Server 2005 Support table partition, which allows all table partitions to be saved on the same server. Each of the table partitions is associated with a single file in a filegroup (

Believe that the use of Win7 32-bit pure version of users have found that under normal circumstances, the icon of the system desktop will automatically refresh with the user's operation, but because of the problem of setting up or some desktop

Server Partitioned TableScalability is an important aspect of a database management system that provides table partitioning capabilities in terms of scalability in SQL Server 2005.In fact, for the relational database products, the table, database

First, the preface See a document about SQL Server table partitioning on MSDN: Special guidelines for partitioned indexes, it's harder to understand the meaning of a document if you don't have actual experience with the table partition. Here I will