what is difference between paging and fragmentation?
Mention the differences between unique key and primary key
With DTS packaging I can store tables in Excel and convert them back to SQL. But once I copied tables to Excel I want to modify some info. How you do that without editing the Excel file?
what is the use of SYSTEM.EFFECTIVE.DATE varaible ?
What is Dedicated server configuration ?
Explain what are tp-lite and tp-heavy monitors?
Mention the types of join?
Is there some bulk load or other way to import a lot of data fast?
List few restrictions that are imposed while creating views?
What is a database in a website?
Define scalar functions.
Which dbms is best?
What is denormalization and why would someone consider doing so?