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.
Specify the several types of Strategies?
Illustrates the case statement present into stored procedure?
Write down brief note on the issues for database performance?
Define the efficient data structure used within the internal storage representation in RDBMS?
What is Data Manipulation Language?
Elucidate what are the tasks which Load manger process will do?
Briefly describe the new features of SQL Server 2005 Analysis Services (or SSAS)?
Describe some of the chrematistics of good data definitions.
Write down the brief note on the differentiations between Normalizer and Normalizer transformation?
Specify the types of dimensions which are available in the Informatica?
18,76,764
1939563 Asked
3,689
Active Tutors
1417524
Questions Answered
Start Excelling in your courses, Ask an Expert and get answers for your homework and assignments!!