Explain the way to select tables for partition in Sybase
Explain the way to select tables for partition in Sybase?
Expert
You must partition heap tables which have large amounts of concurrent insert activity. Because, a heap table is a table, which no clustered index. Now here are some illustrations:
1. An "append-only" table to that every transaction should write2. A tables which provide a history or say audit list of activities3. A new table in which you load data along with bcp in. When the data is loaded in, then you can unpartition the table. It allows you to create a clustered index upon the table, or give other commands not permitted upon a partition table.
Why Increase correct timeslice -201?
Briefly describe the term a Cube and Linked Cube with reference to data warehouse?
Illustrates the difference between a file server and database server?
Describe the meaning of each of the transaction stages supported by SQL Server?
Explain difference types of the stages?
Explain the term Repository Tables within the Data Stage?
Explain the term optimization and performance tuning and its work in practical projects?
Give a brief introduction of the term ‘SQL Server 2005 Analysis Services’ (or SSAS)?
Describe briefly the difference between identifier and attributes?
What are the catches?
18,76,764
1942865 Asked
3,689
Active Tutors
1422831
Questions Answered
Start Excelling in your courses, Ask an Expert and get answers for your homework and assignments!!