Microsoft SQL Server

SQL Server Core Engineer Tips

September, 2009

  • Moving Database Files on the secondary server in Log Shipping

    Moving Database Files on the secondary server in Log Shipping You are using Microsoft SQL Server Logshipping for one of your VLDB (very large database). You would like to move data files on another disk on the secondary server without reconfiguring log...
  • SQL Server Express 2008

    SQL Server Express 2008 and Service Pack SQL Server 2008 Express Edition is the new version of MSDE or SQL Server 2005 Express. This version includes SQL Server 2008 is free, easy to use and light. You can compare the various features by looking up the...
  • Configuring SSIS

    Configure SSIS When you want to use SSIS with a named instance or cluster or remote, you must configure the SSIS service in accordance with the recommendations of the article below: Configuring the Integration Services Service http://msdn2.microsoft.com...
  • How to insert data from one table to another table

    How to insert data from one table to another table by using SQL Server There are various ways to insert data from one table to another table. I will present you the most efficently. Using INSERT INTO This method is used when the table is already existing...