3. SQL Administration tasks. Objectives Keep the databases long time running Contents Update distribution statistics Rebuild indexes Maintain full-text indexes Alerts Maintenance Plan Practicals Rebuild and update database indexes Making Alerts Making Maintenance Plan Summary.
Download Policy: Content on the Website is provided to you AS IS for your information and personal use and may not be sold / licensed / shared on other websites without getting consent from its author.While downloading, if for some reason you are not able to download a presentation, the publisher may have deleted the file from their server.
$ man man
$ man –k tcp
$ man passwd
$ man 5 passwd
Update statistics northwind.dbo.customers
Create statistics stats1 on northwind.dbo.customers (customerid) with fullscan, norecompute
Drop index dbo.customers.northwind_customers_id
Create index northwind_customers_id
On northwind.dbo.customers (customerid)
Double click or right click on any full text catalogue to change its properties/scheduling and so on
Management -> SQL Server Agent -> Alert (right click to make new or click on event)
The Database Maintenance Plan Wizard allows you to configure the following tasks to execute automatically according to specified schedules.
1. click Database Maintenance Planner,
or in the console tree, right-click Database Maintenance Plans, in the Management container
2. then click New Maintenance Plan to display the Welcome To The Database Maintenance Plan Wizard page.