Interested to Buy Any Domain ? << Click Here >> for more details...
What are the factors you will check for the performane
optimization for a database query?
- 7 Answers
- 11689 Views
- CarrizalSoft Technologies, DELL, SoftSol, I also Faced
- E-Mail Answers
Answer Posted / pushpendra kumar
The important factors for performance optimization are as
follows:
1. Proper data type assignment;
2. Selection of proper data reader;
3. Proper command to retrieve the data from the database.
| Is This Answer Correct ? | 2 Yes | 3 No |
Post New Answer View All Answers
What is the difference between a check constraint and a rule?
How do I find information about the install locations for the various instances running on a computer?
What is the difference between varchar and nvarchar datatypes?
What will be the maximum number of indexes per table?
What is ssl in sql server?
Can we shrink data file in sql server?
Which autogrowth database setting is good?
What are the components of dbms?
How to create sub reports?
How many tables can be joined in SQL Server?
What is precedence constraint?
Can you give me some DBCC command options?(Database consistency check) - DBCC CHECKDB - Ensures that tables in the db and the indexes are correctly linked.and DBCC CHECKALLOC - To check that all pages in a db are correctly allocated. DBCC SQLPERF - It gives report on current usage of transaction log in percentage. DBCC CHECKFILEGROUP - Checks all tables file group for any damage.
What are entities and relationships?
Can a rule be bound to any column of any data type?
If the job running very slow what is the action you do
