How can I partition any table in Sybase
How can I partition any table in Sybase? Explain.
Expert
No, you cannot partition any table in Sybase. There are some kinds of tables where you cannot partition:
1. Tables along with clustered indexes (like release 11.5 this is possible to have a clustered index upon a partitioned table)2. Adaptive server enterprise system tables3. Work tables4. Temporary tables5. Tables which are already partitioned. Nonetheless, you can unpartition and after that re-partition tables to modify the number of partitions.
Describe the difference between differential backups and SQL Server 2000 complete?
Where is the GRANT table option usually done after creating tables dynamically within the Teardata? While tables are newly created, what are the default role and default privileges that get assigned?
Specify some of the different @ Functions?
Illustrate stored procedures, and how do they are distinct from triggers?
Describe briefly the difference between pessimistic locking and optimistic locking?
Illustrates the types of Data Independence?
Which data providers can be combined in one report?
Explain the following terms: Proactive, Retroactive and immediate Update.
Explain the automated document scheduling and distribution?
What do you mean by the term Open Server in the Sybase?
18,76,764
1951741 Asked
3,689
Active Tutors
1440604
Questions Answered
Start Excelling in your courses, Ask an Expert and get answers for your homework and assignments!!