You have several tables, and they are joined together for querying. The tables contain both clustered indexes and non clustered indexes to optimize performance, how should you distribute the tables and their indexes onto different file groups?
No Answer is Posted For this Question
Be the First to Post Answer
What is a raid and what are different types of raid configurations?
How secure is sql server database?
How can you know if the row fetched from cursor is still valid in underlying table?
How do you manipulate data?
What is a Stored Procedure?
Which one is faster delete/truncate? Why?
What is create command?
Can we create SP inside SP ? If no Y ? If yes Y ? Explain with an example ?
What is the difference between system objects and user objects?
what are database files and filegroups? : Sql server database administration
How can a user-defined datatype be created?
What is difference between restoration and recovery in SQLServer?
Oracle (3259)
SQL Server (4518)
MS Access (429)
MySQL (1402)
Postgre (483)
Sybase (267)
DB Architecture (141)
DB Administration (291)
DB Development (113)
SQL PLSQL (3330)
MongoDB (502)
IBM Informix (50)
Neo4j (82)
InfluxDB (0)
Apache CouchDB (44)
Firebird (5)
Database Management (1411)
Databases AllOther (288)