Golgappa.net | Golgappa.org | BagIndia.net | BodyIndia.Com | CabIndia.net | CarsBikes.net | CarsBikes.org | CashIndia.net | ConsumerIndia.net | CookingIndia.net | DataIndia.net | DealIndia.net | EmailIndia.net | FirstTablet.com | FirstTourist.com | ForsaleIndia.net | IndiaBody.Com | IndiaCab.net | IndiaCash.net | IndiaModel.net | KidForum.net | OfficeIndia.net | PaysIndia.com | RestaurantIndia.net | RestaurantsIndia.net | SaleForum.net | SellForum.net | SoldIndia.com | StarIndia.net | TomatoCab.com | TomatoCabs.com | TownIndia.com
Interested to Buy Any Domain ? << Click Here >> for more details...


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

Post New Answer

More SQL Server Interview Questions

What is a raid and what are different types of raid configurations?

0 Answers  


How secure is sql server database?

0 Answers  


How can you know if the row fetched from cursor is still valid in underlying table?

0 Answers  


How do you manipulate data?

0 Answers  


What is a Stored Procedure?

8 Answers  


Which one is faster delete/truncate? Why?

1 Answers   Infosys,


What is create command?

0 Answers  


Can we create SP inside SP ? If no Y ? If yes Y ? Explain with an example ?

3 Answers   IBM, L&T,


What is the difference between system objects and user objects?

0 Answers   HCL,


what are database files and filegroups? : Sql server database administration

0 Answers  


How can a user-defined datatype be created?

0 Answers  


What is difference between restoration and recovery in SQLServer?

3 Answers   Microsoft,


Categories