how do you control the max size of a heap table? : Sql dba



how do you control the max size of a heap table? : Sql dba..

Answer / Shiva Nand Prasad

In SQL Server, you can control the maximum size of a heap table by setting the MAXSIZE option when creating or altering the table.

Is This Answer Correct ?    0 Yes 0 No

Post New Answer

More SQL PLSQL Interview Questions

What is a boolean in sql?

1 Answers  


Can we use ddl commands in pl sql?

1 Answers  


Can one improve the performance of sql*loader? : aql loader

1 Answers  


explain mysql aggregate functions. : Sql dba

1 Answers  


What is difference between a PROCEDURE & FUNCTION ?

6 Answers   Satyam,


What is the usage of nvl function?

1 Answers  


What is the use of primary key?

1 Answers  


what is column? : Sql dba

1 Answers  


what is a tablespace? : Sql dba

1 Answers  


How to call a javascript function from pl sql?

1 Answers  


How do you explain an index?

1 Answers  


How many disk partitions should I have?

1 Answers  


Categories