Sql server updating large databases
SQL Server is one of the few Microsoft server applications that has the potential to place a significant load on the processor, especially if your application deals with large tables or high transaction volume.
Therefore, running SQL Server in a virtual environment is an option many enterprises will want to consider.
Virtualization can take advantage of the processing power of this new generation of servers, providing significant leverage for your hardware dollar. Traditionally, SQL Servers run on dedicated hardware.
Creating a clustered index on every table is highly recommended, the challenge is to create the right index.Although the tracking will be taking place at the table level, you need to make the database aware of this capability.You can do so by executing the sys.sp_cdc_enable_db system stored procedure, as shown below: EXEC sys.sp_cdc_enable_table [ @source_schema = ] 'source_schema', [ @source_name = ] 'source_name', [ @role_name = ] 'role_name' -- Specify the gating role if gating is desired -- or set to NULL if you don't want gating.A clustered index provides more efficient search for values in a specific range.When you already have a table where the records are sorted ascending by e.g.