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 a table with close to 100 million records recently, a huge amount of this data was updated now, various queries against this table have slowed down considerably what is the quickest option to remedy the situation?


No Answer is Posted For this Question
Be the First to Post Answer

Post New Answer

More SQL Server Interview Questions

How do I start sql server 2016?

0 Answers  


i want to create procedure for create table in sql server 2005 for example create procedure create_table @table varchar(20) as create @table( id int, name char(20) ) but it will get error what is solution?

5 Answers   Aptech,


Explain view in sql server?

0 Answers  


State the difference between union and union all?

0 Answers  


What is the optimization being performed in oracle and SQL Server?

0 Answers   Cap Gemini,


What are the types of user defined functions in sql server?

0 Answers  


how can i store resumes in database?

3 Answers   HCL,


Distinguish between nested subquery and correlated subquery?

0 Answers  


Explain how many normalization forms?

0 Answers  


Explain the new features of SQL server 2000?

1 Answers  


two tables with table name ship(name,year) and battle (name,year),how to find the latest added year in the table ship

1 Answers  


Why we are using the sql language?. What is the purpose of using this?

2 Answers  


Categories