Skip to content

Commit bdaf3b2

Browse files
v-thepetv-thepet
committed
fix more
1 parent bbb4851 commit bdaf3b2

6 files changed

Lines changed: 36 additions & 36 deletions

File tree

‎docs/2014/relational-databases/partitions/manage-partition-wizard-f1-help.md‎

Lines changed: 8 additions & 8 deletions
Original file line numberDiff line numberDiff line change
@@ -86,7 +86,7 @@ manager: "jhubbard"
8686
**Manage partitioned data in a sliding window scenario**
8787
Appends an empty partition to the existing table that can be used for switching in data. The wizard currently supports switching into the last partition and switching out the first partition.
8888

89-
![Arrow icon used with Back to Top link](../../2014/media/uparrow16x16.gif "Arrow icon used with Back to Top link") [In This Section](#Top)
89+
![Arrow icon used with Back to Top link](../../media/uparrow16x16.gif "Arrow icon used with Back to Top link") [In This Section](#Top)
9090

9191
## <a name="SwitchIn"></a> Select Partition Switching-In Options Page
9292
Use the **Select Partition Switching-In options** page to select the staging table you are switching into the partitioned table.
@@ -101,7 +101,7 @@ manager: "jhubbard"
101101
**Switch in table**
102102
Select the staging table that contains the partition that you want to add to your partitioned table. You must create this staging table before you switch-in partitions with the **Manage PartitionsWizard**.
103103

104-
![Arrow icon used with Back to Top link](../../2014/media/uparrow16x16.gif "Arrow icon used with Back to Top link") [In This Section](#Top)
104+
![Arrow icon used with Back to Top link](../../media/uparrow16x16.gif "Arrow icon used with Back to Top link") [In This Section](#Top)
105105

106106
## <a name="SwitchOut"></a> Select Partition Switching-Out Options Page
107107
Use the **Select Partition Switching-Out options** page to select the partition and the staging table to hold the partitioned data that you are switching out of the partitioned table.
@@ -119,7 +119,7 @@ manager: "jhubbard"
119119
**Existing**
120120
Select an existing staging table you want to use for the partition you want to switch out of the current source table. If the existing table contains data, this data will be overwritten with the data you are switching out.
121121

122-
![Arrow icon used with Back to Top link](../../2014/media/uparrow16x16.gif "Arrow icon used with Back to Top link") [In This Section](#Top)
122+
![Arrow icon used with Back to Top link](../../media/uparrow16x16.gif "Arrow icon used with Back to Top link") [In This Section](#Top)
123123

124124
## <a name="StagingTableOptions"></a> Select the Staging Table Options Page
125125
Use the **Select the Staging Table Options** page to create the staging table you want to use for switching your partitioned data.
@@ -141,7 +141,7 @@ manager: "jhubbard"
141141
**Filegroup**
142142
Select a filegroup for the new table.
143143

144-
![Arrow icon used with Back to Top link](../../2014/media/uparrow16x16.gif "Arrow icon used with Back to Top link") [In This Section](#Top)
144+
![Arrow icon used with Back to Top link](../../media/uparrow16x16.gif "Arrow icon used with Back to Top link") [In This Section](#Top)
145145

146146
## <a name="OutputOption"></a> Select Output Option Page
147147
Use the **Select Output Option** page to specify how you want to complete the modifications to your partitions.
@@ -168,7 +168,7 @@ manager: "jhubbard"
168168
**Change schedule**
169169
Opens the **New Job Schedule** dialog box, where you can select, change, or view the properties of the scheduled job.
170170

171-
![Arrow icon used with Back to Top link](../../2014/media/uparrow16x16.gif "Arrow icon used with Back to Top link") [In This Section](#Top)
171+
![Arrow icon used with Back to Top link](../../media/uparrow16x16.gif "Arrow icon used with Back to Top link") [In This Section](#Top)
172172

173173
## <a name="NewJob"></a> New Job Schedule Page
174174
Use the **New Job Schedule** page to view and change the properties of the schedule.
@@ -251,7 +251,7 @@ manager: "jhubbard"
251251
**Time**
252252
Select the time for the job to run.
253253

254-
![Arrow icon used with Back to Top link](../../2014/media/uparrow16x16.gif "Arrow icon used with Back to Top link") [In This Section](#Top)
254+
![Arrow icon used with Back to Top link](../../media/uparrow16x16.gif "Arrow icon used with Back to Top link") [In This Section](#Top)
255255

256256
## <a name="Summary"></a> Summary Page
257257
Use the **Summary** page to review the options that you have selected on the previous pages.
@@ -260,7 +260,7 @@ manager: "jhubbard"
260260
**Review your selections**
261261
Displays the selections you have made for each page of the wizard. Click a node to expand and view your previously selected options.
262262

263-
![Arrow icon used with Back to Top link](../../2014/media/uparrow16x16.gif "Arrow icon used with Back to Top link") [In This Section](#Top)
263+
![Arrow icon used with Back to Top link](../../media/uparrow16x16.gif "Arrow icon used with Back to Top link") [In This Section](#Top)
264264

265265
## <a name="Progress"></a> Progress Page
266266
Use the **Progress** page to monitor status information about the actions of the **Manage Partition Wizard**. Depending on the options that you selected in the wizard, the **Progress** page might contain one or more actions. The top box displays the overall status of the wizard and the number of status, error, and warning messages that the wizard has received.
@@ -298,7 +298,7 @@ manager: "jhubbard"
298298
**Close**
299299
Close the wizard.
300300

301-
![Arrow icon used with Back to Top link](../../2014/media/uparrow16x16.gif "Arrow icon used with Back to Top link") [In This Section](#Top)
301+
![Arrow icon used with Back to Top link](../../media/uparrow16x16.gif "Arrow icon used with Back to Top link") [In This Section](#Top)
302302

303303
## See Also
304304
[Partitioned Tables and Indexes](../relational-databases/indexes/indexes.md)

‎docs/2014/relational-databases/performance/monitoring-performance-by-using-the-query-store.md‎

Lines changed: 6 additions & 6 deletions
Original file line numberDiff line numberDiff line change
@@ -86,11 +86,11 @@ JOIN sys.query_store_query_text AS Txt
8686
## Using the Regressed Queries Feature
8787
After enabling the query store, refresh the database portion of the Object Explorer pane to add the **Query Store** section.
8888
89-
![QueryStore](../../2014/database-engine/media/querystore.PNG "QueryStore")
89+
![QueryStore](../../database-engine/media/querystore.PNG "QueryStore")
9090
9191
Selecting **Regressed Queries**, opens the **Regressed Queries** pane in [!INCLUDE[ssManStudio](../../../includes/ssmanstudio-md.md)]. The Regressed Queries pane shows you the queries, and plans in the query store. Drop down boxes at the top allow you to select queries based on various criteria. Select a plan to see the graphical query plan. Buttons are available to view the source query, force, and unforce a query plan, and refresh the display.
9292
93-
![RegressedQueries](../../2014/database-engine/media/regressedqueries.PNG "RegressedQueries")
93+
![RegressedQueries](../../database-engine/media/regressedqueries.PNG "RegressedQueries")
9494
9595
To force a plan, select a query and plan, and then click **Force Plan.** You can only force plans that were saved by the query plan feature and are still retained in the query plan cache.
9696
@@ -518,9 +518,9 @@ EXEC sp_query_store_unforce_plan @query_id = 48, @plan_id = 49;
518518
519519
520520
## See Also
521-
[Monitor and Tune for Performance](../relational-databases/performance/monitor-and-tune-for-performance.md)
522-
[Performance Monitoring and Tuning Tools](../relational-databases/performance/performance-monitoring-and-tuning-tools.md)
523-
[Open Activity Monitor &#40;SQL Server Management Studio&#41;](../relational-databases/performance-monitor/open-activity-monitor-sql-server-management-studio.md)
524-
[Activity Monitor](../relational-databases/performance-monitor/activity-monitor.md)
521+
[Monitor and Tune for Performance](../performance/monitor-and-tune-for-performance.md)
522+
[Performance Monitoring and Tuning Tools](../performance/performance-monitoring-and-tuning-tools.md)
523+
[Open Activity Monitor &#40;SQL Server Management Studio&#41;](../performance-monitor/open-activity-monitor-sql-server-management-studio.md)
524+
[Activity Monitor](../performance-monitor/activity-monitor.md)
525525
526526

‎docs/2014/relational-databases/scripting/generate-and-publish-scripts-wizard.md‎

Lines changed: 16 additions & 16 deletions
Original file line numberDiff line numberDiff line change
@@ -170,7 +170,7 @@ manager: "jhubbard"
170170

171171
- **Script binding** - Generates a script for binding default and rule objects. The default is **False**. For more information, see [CREATE DEFAULT &#40;Transact-SQL&#41;](~/t-sql/statements/create-default-transact-sql.md) and [CREATE RULE &#40;Transact-SQL&#41;](~/t-sql/statements/create-rule-transact-sql.md).
172172

173-
- **Script collation** - Includes collation information in the script. The default is **False**. For more information, see [Collation and Unicode Support](../relational-databases/collations/collation-and-unicode-support.md).
173+
- **Script collation** - Includes collation information in the script. The default is **False**. For more information, see [Collation and Unicode Support](../collations/collation-and-unicode-support.md).
174174

175175
- **Script defaults** - Includes default objects used to set default values in table columns. The default is **True**. For more information, see [CREATE DEFAULT &#40;Transact-SQL&#41;](~/t-sql/statements/create-default-transact-sql.md).
176176

@@ -194,11 +194,11 @@ manager: "jhubbard"
194194

195195
**Table/View Options** - The following options apply only to scripts for tables or views.
196196

197-
- **Script change tracking** - Scripts change tracking if it is enabled on the origin database or tables in the origin database. The default is **False**. For more information, see [About Change Tracking &#40;SQL Server&#41;](../../2014/database-engine/about-change-tracking-sql-server.md).
197+
- **Script change tracking** - Scripts change tracking if it is enabled on the origin database or tables in the origin database. The default is **False**. For more information, see [About Change Tracking &#40;SQL Server&#41;](../../database-engine/about-change-tracking-sql-server.md).
198198

199-
- **Script check constraints** – Adds `CHECK` constraints to the script. The default is **True**. `CHECK` constraints require data that is entered into a table to meet some specified condition. For more information, see [Unique Constraints and Check Constraints](../../2014/database-engine/unique-constraints-and-check-constraints.md).
199+
- **Script check constraints** – Adds `CHECK` constraints to the script. The default is **True**. `CHECK` constraints require data that is entered into a table to meet some specified condition. For more information, see [Unique Constraints and Check Constraints](../../database-engine/unique-constraints-and-check-constraints.md).
200200

201-
- **Script data compression options** - Scripts data compression options if they are configured on the origin database or tables in the origin database. For more information, see [Data Compression](../relational-databases/data-compression/data-compression.md). The default is **False**.
201+
- **Script data compression options** - Scripts data compression options if they are configured on the origin database or tables in the origin database. For more information, see [Data Compression](../data-compression/data-compression.md). The default is **False**.
202202

203203
- **Script foreign keys** - Adds foreign keys to the script. The default is **True**. Foreign keys indicate and enforce relationships between tables.
204204

@@ -208,9 +208,9 @@ manager: "jhubbard"
208208

209209
- **Script primary keys** - Scripts the creation of primary keys on tables. The default is **True**. Primary keys uniquely identify each row of a table.
210210

211-
- **Script triggers** - Scripts the creation of DML triggers on tables. The default is **False**. A DML trigger is an action programmed to execute when a data manipulation language (DML) event occurs in the database server. For more information, see [DML Triggers](../../2014/database-engine/dml-triggers.md).
211+
- **Script triggers** - Scripts the creation of DML triggers on tables. The default is **False**. A DML trigger is an action programmed to execute when a data manipulation language (DML) event occurs in the database server. For more information, see [DML Triggers](../../database-engine/dml-triggers.md).
212212

213-
- **Script unique keys** - Scripts the creation of unique keys on tables. Unique keys prevent duplicate data from being entered. The default is **True**. For more information, see [Unique Constraints and Check Constraints](../../2014/database-engine/unique-constraints-and-check-constraints.md).
213+
- **Script unique keys** - Scripts the creation of unique keys on tables. Unique keys prevent duplicate data from being entered. The default is **True**. For more information, see [Unique Constraints and Check Constraints](../../database-engine/unique-constraints-and-check-constraints.md).
214214

215215
### <a name="MgProviders"></a> Manage Providers Page
216216
Use this dialog box to view, add, edit, delete, or test hosting provider connections. A hosting provider specifies the connection information for a Web service created by using the Database Publishing Service project in the SQL Server Hosting Toolkit on CodePlex.
@@ -238,7 +238,7 @@ manager: "jhubbard"
238238

239239
1. **Convert UDDTs to base types** - When **True**, user-defined data types (UDDT) are converted into the underlying base data types that were used to create them. Use **True** when the UDDT does not exist in the database where the script will be run. When **False**, UDDTs are used. The default is **False**.
240240

241-
2. **Publish collation** - Includes collation information for table columns. The default is **False**. For more information, see [Collation and Unicode Support](../relational-databases/collations/collation-and-unicode-support.md).
241+
2. **Publish collation** - Includes collation information for table columns. The default is **False**. For more information, see [Collation and Unicode Support](../collations/collation-and-unicode-support.md).
242242

243243
3. **Publish defaults** - Includes default objects used to set default values in table columns. The default is **True**. For more information, see [CREATE DEFAULT &#40;Transact-SQL&#41;](~/t-sql/statements/create-default-transact-sql.md).
244244

@@ -266,23 +266,23 @@ manager: "jhubbard"
266266

267267
**Table/View Options** - The following options apply only to tables or views.
268268

269-
1. **Publish check constraints** - Includes the creation of `CHECK` constraints in the publishing process. The default is **True**. `CHECK` constraints require data that is entered into a table to meet some specified condition. For more information, see [Unique Constraints and Check Constraints](../../2014/database-engine/unique-constraints-and-check-constraints.md).
269+
1. **Publish check constraints** - Includes the creation of `CHECK` constraints in the publishing process. The default is **True**. `CHECK` constraints require data that is entered into a table to meet some specified condition. For more information, see [Unique Constraints and Check Constraints](../../database-engine/unique-constraints-and-check-constraints.md).
270270

271-
2. **Publish foreign keys** - Includes the creation of foreign keys in the publishing process. The default is **True**. Foreign keys indicate and enforce relationships between tables. For more information, see [Primary and Foreign Key Constraints](../../2014/database-engine/primary-and-foreign-key-constraints.md).
271+
2. **Publish foreign keys** - Includes the creation of foreign keys in the publishing process. The default is **True**. Foreign keys indicate and enforce relationships between tables. For more information, see [Primary and Foreign Key Constraints](../../database-engine/primary-and-foreign-key-constraints.md).
272272

273273
3. **Publish full-text indexes** - Scripts the creation of full-text indexes. The default is **False**.
274274

275275
4. **Publish indexes** - Includes indexes on tables in the publishing process. The default is **True**. Indexes help you find data quickly.
276276

277-
5. **Publish primary keys** - Includes the creation of primary keys in the publishing process. The default is **True**. Primary keys uniquely identify each row of a table. For more information, see [Primary and Foreign Key Constraints](../../2014/database-engine/primary-and-foreign-key-constraints.md).
277+
5. **Publish primary keys** - Includes the creation of primary keys in the publishing process. The default is **True**. Primary keys uniquely identify each row of a table. For more information, see [Primary and Foreign Key Constraints](../../database-engine/primary-and-foreign-key-constraints.md).
278278

279-
6. **Publish triggers** - Includes the creation of DML triggers in the publishing process. The default is **True**. A DML trigger is an action programmed to execute when a data manipulation language (DML) event occurs in the database server. For more information, see [DML Triggers](../../2014/database-engine/dml-triggers.md).
279+
6. **Publish triggers** - Includes the creation of DML triggers in the publishing process. The default is **True**. A DML trigger is an action programmed to execute when a data manipulation language (DML) event occurs in the database server. For more information, see [DML Triggers](../../database-engine/dml-triggers.md).
280280

281-
7. **Publish unique keys** - Includes the creation of unique keys on tables in the publishing process. Unique keys prevent duplicate data from being entered. The default is **True**. For more information, see [Unique Constraints and Check Constraints](../../2014/database-engine/unique-constraints-and-check-constraints.md).
281+
7. **Publish unique keys** - Includes the creation of unique keys on tables in the publishing process. Unique keys prevent duplicate data from being entered. The default is **True**. For more information, see [Unique Constraints and Check Constraints](../../database-engine/unique-constraints-and-check-constraints.md).
282282

283-
8. **Publish change tracking** - Includes change tracking in the publishing process, if it is enabled on the origin database or tables in the origin database. The default is **False**. For more information, see [About Change Tracking &#40;SQL Server&#41;](../../2014/database-engine/about-change-tracking-sql-server.md).
283+
8. **Publish change tracking** - Includes change tracking in the publishing process, if it is enabled on the origin database or tables in the origin database. The default is **False**. For more information, see [About Change Tracking &#40;SQL Server&#41;](../../database-engine/about-change-tracking-sql-server.md).
284284

285-
9. **Publish data compression options** - Includes data compression options in the publishing process, if they are configured on the origin database or tables in the origin database. The default is **True**. For more information, see [Data Compression](../relational-databases/data-compression/data-compression.md).
285+
9. **Publish data compression options** - Includes data compression options in the publishing process, if they are configured on the origin database or tables in the origin database. The default is **True**. For more information, see [Data Compression](../data-compression/data-compression.md).
286286

287287
### <a name="ProvConfig"></a> Provider Configuration Page
288288
Use this dialog box to view or modify hosting provider settings. You can use this dialog box to do the following:
@@ -334,7 +334,7 @@ manager: "jhubbard"
334334
**Finish** - Click to close the wizard after processing has completed, or if an error occurs.
335335

336336
## See Also
337-
[Installing SMO](../../2014/database-engine/dev-guide/installing-smo.md)
338-
[Copy Databases to Other Servers](../relational-databases/databases/copy-databases-to-other-servers.md)
337+
[Installing SMO](../../database-engine/dev-guide/installing-smo.md)
338+
[Copy Databases to Other Servers](../databases/copy-databases-to-other-servers.md)
339339

340340

0 commit comments

Comments
 (0)