Interested to Buy Any Domain ? << Click Here >> for more details...
how do u do Performance tunning ?
- 1 Answers
- 5005 Views
- Infodat Technologies, Satyam, I also Faced
- E-Mail Answers
• Table should have primary key
• Table should have minimum of one clustered index
• Table should have appropriate amount of non-
clustered index
• Non-clustered index should be created on columns of
table based on query which is running
• Following priority order should be followed when
any index is created a) WHERE clause, b) JOIN clause, c)
ORDER BY clause, d) SELECT clause
• Do not to use Views or replace views with original
source table
• Triggers should not be used if possible,
incorporate the logic of trigger in stored procedure
• Remove any adhoc queries and use Stored Procedure
instead
• Check if there is atleast 30% HHD is empty - it
improves the performance a bit
• If possible move the logic of UDF to SP as well
• Remove * from SELECT and use columns which are only
necessary in code
• Remove any unnecessary joins from table
• If there is cursor used in query, see if there is
any other way to avoid the usage of this (either by SELECT
… INTO or INSERT … INTO, etc)
There are few hardware upgrades can be considered as well
like separating index on different disk drive or moving
tempdb to another drive. However, I am not suggesting them
here as they are not quick way to improve the performance
of query.
| Is This Answer Correct ? | 6 Yes | 1 No |
How to list all tables having unique constraints in any of the columns in a database.
How can you know if the row fetched from cursor is still valid in underlying table?
What are the restrictions that views have to follow? : SQL Server Architecture
How to execute multiple stored procedures at one time in sql server?
What are the benefits of normalization?
How to skip remaining statements in a loop block using continue statements?
How is sql used in sql server?
Do you know how to send email from database?
Where do we generally create INDEX?
1 Answers Ernst Young, Thomson Reuters,
Write a sql query to delete duplicate records from a table called table1
How many triggers you can have on a table?
What is database dimension? : sql server analysis services, ssas
-
Oracle (3259) - SQL Server (4518)
- MS Access (429)
- MySQL (1402)
- Postgre (483)
- Sybase (267)
- DB Architecture (141)
- DB Administration (291)
- DB Development (113)
- SQL PLSQL (3330)
- MongoDB (502)
- IBM Informix (50)
- Neo4j (82)
- InfluxDB (0)
- Apache CouchDB (44)
- Firebird (5)
- Database Management (1411)
- Databases AllOther (288)
