Answer / bhaskar

Can u check the folliwing points are used in the procedure
or a Query.

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.

Answer / george

I think the first thing we need to check for the index
defragmentation, truncating transaction log and shrinking
the tempdb as well, this is because first time the query
get executed in the short time only 30 Sec, however second
day time execution increased

Find first and last day of current month in sql server

0 Answers  

---

What is an expensive query?

0 Answers  

---

How will oyu test the stored procedure taking two parameters namely first name and last name returning full name?

3 Answers  

---

Write an sql query to find the names of employees start with ‘a’?

1 Answers  

---

What is the difference between a clustered index and a non-clustered index?

0 Answers  

---

---

What is a table called, if it does not have neither Cluster nor Non-cluster Index?

2 Answers  

---

What is the datatype of rowid?

0 Answers  

---

What is the difference between DTS and SSIS?

3 Answers   Allianz,

---

What is hot add cpu in sql server 2008?

0 Answers  

---

Explain what is the main purpose of having conversation group?

0 Answers  

---

What is a result set object returned by odbc_exec()?

0 Answers  

---

select top 5 * from emp order by newid() my question is , how this query get executed?

5 Answers  

---