Advantages of MyISAM over InnoDB
Explain advantages of MyISAM over InnoDB?
Expert
Advantages are:
a. MyISAM follows a much more conservative approach to disk space management – storing each MyISAM table in a separate file, if required can further be compresses.
b. InnoDB stores the tables in tablespace in which further optimization is difficult with them.
What do you mean by Heap tables? And also define its characteristics?
Illustrates the working of Notification Services?
Describe benefits of SQL Server 2008 for automatic auditing.
Explain about Enhanced database mirroring in SQL server 2008.
What are Union, Intersect and Minus?
What are the conditions in Isolation level ignored?
Explain about the plan freezing in SQL server 2008.
Define the term sparse column sets.
Differentiate between FLOAT and DOUBLE?
What are the primary keys of database programming?
18,76,764
1947100 Asked
3,689
Active Tutors
1419729
Questions Answered
Start Excelling in your courses, Ask an Expert and get answers for your homework and assignments!!