Skip to content

Commit 1698bac

Browse files
v-kentsv-kents
committed
clean warnings
1 parent d50fb6a commit 1698bac

4 files changed

Lines changed: 7 additions & 13 deletions

File tree

‎docs/2014/integration-services/change-data-capture/edit-the-advanced-properties.md‎

Lines changed: 1 addition & 3 deletions
Original file line numberDiff line numberDiff line change
@@ -25,10 +25,8 @@ manager: craigg
2525
> [!NOTE]
2626
> You can view the Advanced Properties in the viewer. When using the viewer the information is read only. The viewer also includes a list of the captured columns in the table.
2727
28-
For a description of the properties you can enter, see the available options table in [cdc.xdbcdc_config](the-oracle-cdc-databases.md#BKMK_cdcxdbcdc_config).
28+
For a description of the properties you can enter, see the available options table in [cdc.xdbcdc_config](the-oracle-cdc-databases.md#bkmk_cdcxdbcdc_config).
2929

3030
## See Also
3131
[How to Manage a CDC Instance](manage-a-cdc-instance.md)
3232
[How to Edit the CDC Instance Properties](how-to-edit-the-cdc-instance-properties.md)
33-
34-

‎docs/2014/integration-services/change-data-capture/error-handling.md‎

Lines changed: 1 addition & 3 deletions
Original file line numberDiff line numberDiff line change
@@ -14,7 +14,7 @@ manager: craigg
1414
# Error Handling
1515
An Oracle CDC Instance mines changes from a single Oracle source database (an Oracle RAC cluster is considered a single database) and writes the committed changes to change tables in a CDC database in the target [!INCLUDE[ssNoVersion](../../includes/ssnoversion-md.md)] instance.
1616

17-
A CDC Instance maintains its state in a system table called **cdc.xdbcdc_state**. This table can be queried any time to find the state of the CDC Instance. For more information about the cdc.xdbcdc_state table, see [cdc.xdbcdc_state](the-oracle-cdc-databases.md#BKMK_cdcxdbcdc_state).
17+
A CDC Instance maintains its state in a system table called **cdc.xdbcdc_state**. This table can be queried any time to find the state of the CDC Instance. For more information about the cdc.xdbcdc_state table, see [cdc.xdbcdc_state](the-oracle-cdc-databases.md#bkmk_cdcxdbcdc_state).
1818

1919
The table below describes the CDC Instance states in the xdbcdc_state table.
2020

@@ -109,5 +109,3 @@ manager: craigg
109109
## See Also
110110
[Change Data Capture Designer for Oracle by Attunity](change-data-capture-designer-for-oracle-by-attunity.md)
111111
[The Oracle CDC Instance](the-oracle-cdc-instance.md)
112-
113-

‎docs/2014/integration-services/change-data-capture/manage-a-cdc-instance.md‎

Lines changed: 1 addition & 3 deletions
Original file line numberDiff line numberDiff line change
@@ -88,7 +88,7 @@ manager: craigg
8888

8989
- **Active transactions**: The current number of source Oracle transactions that are being processed by the Oracle CDC Instance and are not yet decided (commit/rollback).
9090

91-
- **Staged transactions**: The current number source Oracle transactions that are staged to the [cdc.xdbcdc_staged_transactions](the-oracle-cdc-databases.md#BKMK_cdcxdbcdc_staged_transactions) table.
91+
- **Staged transactions**: The current number source Oracle transactions that are staged to the [cdc.xdbcdc_staged_transactions](the-oracle-cdc-databases.md#bkmk_cdcxdbcdc_staged_transactions) table.
9292

9393
- **Counters**: You monitor the following information in this section.
9494

@@ -116,5 +116,3 @@ manager: craigg
116116
[How to View the CDC Instance Properties](how-to-view-the-cdc-instance-properties.md)
117117
[How to Edit the CDC Instance Properties](how-to-edit-the-cdc-instance-properties.md)
118118
[Use the New Instance Wizard](use-the-new-instance-wizard.md)
119-
120-

‎docs/2014/relational-databases/statistics/statistics.md‎

Lines changed: 4 additions & 4 deletions
Original file line numberDiff line numberDiff line change
@@ -99,7 +99,7 @@ ORDER BY s.name;
9999
|-|
100100
|**Applies to**: [!INCLUDE[ssSQL14](../../includes/sssql14-md.md)] through [!INCLUDE[ssCurrent](../../includes/sscurrent-md.md)].|
101101

102-
![Arrow icon used with Back to Top link](../../2014-toc/media/uparrow16x16.gif "Arrow icon used with Back to Top link") [Back to Top](#main)
102+
![Arrow icon used with Back to Top link](../../2014-toc/media/uparrow16x16.gif "Arrow icon used with Back to Top link") [Back to Top](#statistics)
103103

104104
## <a name="CreateStatistics"></a> When to Create Statistics
105105
The query optimizer already creates statistics in the following ways:
@@ -191,7 +191,7 @@ GO
191191

192192
Because temporary statistics are stored in `tempdb`, a restart of the [!INCLUDE[ssNoVersion](../../../includes/ssnoversion-md.md)] service causes all temporary statistics to disappear.
193193

194-
![Arrow icon used with Back to Top link](../../2014-toc/media/uparrow16x16.gif "Arrow icon used with Back to Top link") [Back to Top](#main)
194+
![Arrow icon used with Back to Top link](../../2014-toc/media/uparrow16x16.gif "Arrow icon used with Back to Top link") [Back to Top](#statistics)
195195

196196
## <a name="UpdateStatistics"></a> When to Update Statistics
197197
The query optimizer determines when statistics might be out-of-date and then updates them when they are needed for a query plan. In some cases you can improve the query plan and therefore improve query performance by updating statistics more frequently than occur when AUTO_UPDATE_STATISTICS is on. You can update statistics with the UPDATE STATISTICS statement or the stored procedure sp_updatestats.
@@ -223,7 +223,7 @@ GO
223223

224224
Operations such as rebuilding, defragmenting, or reorganizing an index do not change the distribution of data. Therefore, you do not need to update statistics after performing ALTER INDEX REBUILD, DBCC REINDEX, DBCC INDEXDEFRAG, or ALTER INDEX REORGANIZE operations. The query optimizer updates statistics when you rebuild an index on a table or view with ALTER INDEX REBUILD or DBCC DBREINDEX, however; this statistics update is a byproduct of re-creating the index. The query optimizer does not update statistics after DBCC INDEXDEFRAG or ALTER INDEX REORGANIZE operations.
225225

226-
![Arrow icon used with Back to Top link](../../2014-toc/media/uparrow16x16.gif "Arrow icon used with Back to Top link") [Back to Top](#main)
226+
![Arrow icon used with Back to Top link](../../2014-toc/media/uparrow16x16.gif "Arrow icon used with Back to Top link") [Back to Top](#statistics)
227227

228228
## <a name="DesignStatistics"></a> Queries That Use Statistics Effectively
229229
Certain query implementations, such as local variables and complex expressions in the query predicate, can lead to suboptimal query plans. Following query design guidelines for using statistics effectively can help to avoid this. For more information about query predicates, see [Search Condition &#40;Transact-SQL&#41;](/sql/t-sql/queries/search-condition-transact-sql).
@@ -322,7 +322,7 @@ GO
322322
### Improving Cardinality Estimates with Plan Guides
323323
For some applications, query design guidelines might not apply because you cannot change the query or using the RECOMPILE query hint might be cause too many recompiles. You can use plan guides to specify other hints, such as USE PLAN, to control the behavior of the query while investigating application changes with the application vendor. For more information about plan guides, see [Plan Guides](../performance/plan-guides.md).
324324

325-
![Arrow icon used with Back to Top link](../../2014-toc/media/uparrow16x16.gif "Arrow icon used with Back to Top link") [Back to Top](#main)
325+
![Arrow icon used with Back to Top link](../../2014-toc/media/uparrow16x16.gif "Arrow icon used with Back to Top link") [Back to Top](#statistics)
326326

327327
## See Also
328328
[CREATE STATISTICS &#40;Transact-SQL&#41;](/sql/t-sql/statements/create-statistics-transact-sql)

0 commit comments

Comments
 (0)