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?
- 2 Answers
- 5197 Views
- IBM, I also Faced
- E-Mail Answers
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
you have developed an application which uses many stored procedures and triggers to update various tables users ocassionally get locking problems which tool is best suited to help you diagnose the problem? : Sql server administration
List few advantages of stored procedure.
What are the features of Embedded SQL
which table keeps the locking information? : Sql server administration
How to create new tables with "select ... Into" statements in ms sql server?
What is a non clustered primary key?
How can you list all the table constraints in a database?
Does a full backup include transaction log?
What is the difference between set and select?
What is abstracting periodical?
What is 3nf normalization?
What is instead of dml trigger?
How to define and use table alias names in ms sql server?
How to create “dependant” parameter “make, model, year”
How to find related tables in sql server?
