Data Engineering – Learn from the experts
-
Dedicated Administrator Connection
SQL Server 2005 provides a special diagnostic connection for administrators when standard connections to the server are not possible. This diagnostic connection allows an administrator to access SQL Server to execute diagnostic queries and troubleshoot problems even when SQL Server is not responding to standard connection requests.
-
Types of backup in SQL 2005
One of the most important roles of a DBA is performing regular backups of SQL Server data. Creating backups of critical business data should be one of the foremost concerns of a database administrator (DBA) because backups provide a way to restore data that otherwise could be completely lost. Now let us discuss the types…
-
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.
Got any recommendations?