How do you fine the performance tunning?
Answers were Sorted based on User's Feedback
Answer / visala
first we have to check indexes are there or not,
check whether the statistics are updated or not,
check fragmentation is there or not,
check availability of joins,
check availability of aggregatefnctions,
may be networking problem,
may be hardware problem
then we tunne according to these problems
Is This Answer Correct ? | 5 Yes | 0 No |
Answer / shivaraj
it is depends on
Data base design.
Hardware Sizing,
Application T- SQL codes- Indexes,Stored
Procedues,constraints
no of clients
no users
Type of data and Quantity base storage capacity on daily
basis
Is This Answer Correct ? | 3 Yes | 0 No |
Why do we use sql limitations? Which constraints can we use while making a database in sql?
table:employee EID ENAME MID(manager ids) 101 rama null 102 sita 101 103 siva 101 104 ganesh 103 . . . . . . for 103 ID the manager ID is 101(RAMA) and for 104 manager is SIVA if i give employee id (EID) you have to tell the manager for that EID write query? eample:if i give 102 .The query output should be manager for 102 ID that it should print RAMA as output
How to disable stored procedure sql server?
Differentiate between a primary key and a unique key.
can you instantiate a com object by using t-sql? : Sql server database administration
What do you mean by sql server 2005 express management tools?
How to rebuild master databse?
How to connect to a sql server using odbc_connect()?
What is PROJECTION Operation?
What is the difference between set and select?
What is difference between commit and rollback when used in transactions?
Which sql server table is used to hold the stored procedure scripts?