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
How to use clusters?
What is the sql case statement used for? Explain with an example?
how you can list all the tables in a database?
What is SQL Profiler what is the use of it?
2 Answers 247Customer, Steria,
What is an index in a database?
What is an sql server agent?
What are types of scd? : sql server analysis services, ssas
How to connect PK and FK?
What is database mirroring?
What is the difference between a clustered index and a non-clustered index?
Can a trigger be created on a view?
What are the new security features added in sql server 2012? : sql server security
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)