This SQL Server Index Maintenance Overview contains the following 3 topics: Determining Index Fragmentation with DBCC SHOWCONTIG Fixing Fragmented Indexes Distribution Statistics Determining Inde...
Data warehouse assembles data dispersed in various data sources across the enterprise and helps business stakeholders manage their operations by making better informed decisions. Most organizations ha...
Exporting data is a key activity for automation and the Select to File activity handles most basic exporting needs. But what if you have a little bit special situation that needs to be exported? In th...
For more advanced forms of formatting use Excel macros. Macros are VBA instructions that can be triggered by Toad. By default Excel disables macros. You will need to set up Excel to use macros. When...
Learn how to import connections in Toad for SQL Server, our solution for database management and administration...
Normal system backups, referred to as either Hot or Cold backups, are used to protect from media failure. A Cold backup, that is, one done with the database in a shutdown state, provides a complete co...
The flash recovery area, which allows you to centralize storage of all recovery-related files, is new in Oracle 10g. The flash recovery area is an area of disk that is defined for use for recovery-rel...
The log_archive_duplex_dest parameter allows you to define not one but two archived redo log storage locations. You can define it as a can or must succeed operation by setting the log_archive_min_succ...
Adding an ASM Disk Group ASM disk groups are the foundation of ASM. It is where your data will be stored. ASM disk groups can be allocated to raw disk, cooked disk. To add a ASM disk group you first...
DBWn – Database Writer Note that Oracle changed the naming format of the DBWR process to DBWn as of Oracle8, where n can be a number from 0 through 9. If you use multiple DB writer processes, you shou...
Oracle V11.1 Description v────────────────────────────┐ >──STORAGE─(──┬─INIITAL──size_clause─────┬┴─)──> ├─NEXT──size_clause────────┤ ├─MINEXTENTS──integer──────┤ ...
Here is a report that uses pivot grids. For this report I export the data to a specific area on another worksheet. I define the pivot grid to take the data from that area. In this use case you can ...
