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? : Sql server administration


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

Post New Answer

More SQL Server Interview Questions

please can anyone answer this query Table 1 has 2 columns: EmployeeId,Age Table 2 has 2 columns: EmployeeId, Region Write SQL to Find the region who has the oldest person

10 Answers  


How do I create a stored procedure in dbml?

0 Answers  


Define full outer join in sql server joins?

0 Answers  


What is the difference between truncate and delete commands?

0 Answers  


tell me what is blocking and how would you troubleshoot it? : Sql server database administration

0 Answers  


How to rename an existing column with the "sp_rename" stored procedure in ms sql server?

0 Answers  


What purpose does the model database server?

0 Answers  


What is the beast way to write CTE in SQL Server ?

0 Answers   HCL,


What do you mean by a dependent functionality in a build?

0 Answers   HCL,


What are the difference between primary keys and foreign keys?

0 Answers  


I have a table in which phno is one of the columns.i do have some values in tht phno column.i need to update phno column values with 0(zero) as prefix.give me a correct solution plz...

7 Answers   Value Labs,


List the types of recovery model available in sql server?

0 Answers  


Categories