Author: VidhyaSagar
-
Migrating Moving SQL2005 db to SQL2000 db
There are lot of ways by which we can migrate SQL2000 to SQL2005 where we can easily copy SQL2000 databases to SQL2005. While migrating lower to higher version its possible to migrate easily, but in some cases if needed to revert back SQL2000 its a question in everybodys mind that is it possible to do…
-
How to Schedule SSIS package
Scheduling a SSIS package is not like scheduling DTS packages in SQL 2000. In SQL 2000, you will move to DTS package and then right click from there you can get the schedule menu, but for SQL 2005 its no more like that. You should schedule the SSIS packages as below.
-
Partitioning
Partitioning is all about dividing of datas to make it faster access either by reading or writing into the table. i.e improving query execution time. Partitioning can be done at Table and Index level. These are the new features in SQL server 2005 and these are supported only at Enterprise and Developer edition. The data…
-
Creating Partitioned Tables
The following are the steps to create a partitioned table. 1.) Create a partition function 2.) Create a partition scheme 3.) Create a table using the partition scheme.
-
Data Partitioning
Introduction: This article takes introduces you to the concept of data partitioning in SQL server 2005. It also gives you an example of how to start from the scratch and also how to partition an already existing table.