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...

  1. Categories >> Software >> Databases >> SQL Server
  2. Suggest New Category

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

Question Posted / kum anshu


you have a table with close to 100 million records recently, a huge amount of this data was updated ..

Answer / Jagesh Kumar

To quickly address this issue, consider implementing database indexes, partitioning the large table, or optimizing the queries by using query hints. Also, analyzing and reorganizing the indexes can help improve performance. Lastly, upgrading to a more powerful server could also be an option.

Is This Answer Correct ?    0 Yes 0 No

Post New Answer

More SQL Server Interview Questions

How to Run a Query on a Remote SQL Server?

2 Answers  

What is faster join or union?

1 Answers  

What is the command used to recompile the stored procedure at run time?

1 Answers  

Create a dts package to produce a text file using the ‘update statistics’ command for the tables in a database with obsolete statistics.

1 Answers  

What are dml (data manipulation language) statements in ms sql server?

1 Answers  

What is model database? : SQL Server Architecture

1 Answers  

What is GUID in sql server?

1 Answers   BirlaSoft,

Let us say the SQL Server crashed and you are rebuilding the databases including the master database what procedure to you follow?

2 Answers  

What is the use of attributehierarchyvisible ? : sql server analysis services, ssas

1 Answers  

Write a query to include a constraint, to check whether the employee salary is greater than 5000?

1 Answers   TCS,

How to check if a table is being used in sql server?

1 Answers  

What does ss stand for sexually?

1 Answers  

For more SQL Server Interview Questions Click Here
Categories