DBA Points
- A clustered index only reorganizes the data pages so that the rows are logically stored in clustered index order. The pages are not guaranteed to be ordered in physically
- To use template scripts, goto view>Template Explorer. Select the template & select the script. To change values press ctrl+shift+M
- Full outer Join not supported in MySql, but it could be emulated with join of Left Join & Right Join
- Avoid table names & column names that contain spaces, keyword and symbols
- Some SQL Best Practices :
- Data & Log files in different drives
- tempdb on different drive
- Proper backup schedule with point in time recovery
- Proper clean up plan
- Health checks like integrity
- Restore drill
- Restricted access
- Domain service account for sql services
- Proper memory settings
- Proactive monitoring
- Data purging schedule if possible
- Mail setup for notification
- Error log configuration
- Job history configuration
- Alert
- Disk space alert
- Backup failure alert
- Database files with threshold alert
- Long running Job alert
No comments:
Post a Comment