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

What are the steps need to be take improve the speed of a SQLDATA Server?

Answer Posted / rajan chauhan

Check the some step
1. Space in HD
2. Use DBCC FREEPROCCACHE & DBCC DROPCLEANBUFFER
3. Cover Index

Is This Answer Correct ?    2 Yes 0 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

How do I perform an unattended install of sql server 2000?

1086


what is a correlated sub-query? : Sql server database administration

941


What is data modeling and Reterminal integrity?

1955


Do you know what is recursion? Is it possible for a stored procedure to call itself or recursive stored procedure? How many levels of sp nesting is possible?

1040


What is nolock?

983


What is coalesce and check constraint in sql server?

1122


Does transparent data encryption provide encryption when transmitting data across the network?

1047


What are differences in between sql server 2012 and sql server 2016?

1046


How many types of dimensions are there and what are they? : sql server analysis services, ssas

1068


Can we use max in where clause?

925


What is the main difference between ‘between’ and ‘in’ condition operators?

1191


List some case manipulation functions in sql?

1027


What are tables in sql server?

1039


How to remove duplicate rows from table?

1248


What are the disadvantages of indexes?

1090