durai nagarajan (11/19/2012)

---

Nolock is not used.

we havent used inbuilt function also.

there is date conversion and comparison between a table column and input parameters.

i forgot to mention it is compared with...

see this for advantages ...

this can help you here http://msdn.microsoft.com/en-us/library/ms188917(v=sql.90).aspx

mah_j (11/18/2012)

---

What do you mean by...

then MAx memory can go upto 10 gb

it indicates there might be nothing to do with Sql server as if sql server behaves abnormally...

i guess you are looking for this

http://msdn.microsoft.com/en-us/library/ms162810(v=sql.105).aspx

Scott D. Jacobson (11/16/2012)

---

I've learned through that experience that it's better to executing the backup action through the job directly or, even better, create some DBA stored procedures and then...

Here do you mean that with same parameters you are getting different results (sometime right sometmes wrong )...

use different...

today i first time heard about EAV. can you post any simple example so that i can have a idea about it , i havent got any good example over...

Your COde

there are also other ways to improve the peorformance (miilions of rows case )

partiton the data.

keep the indexes on diiferent drive if possible OR use fast drives.

normalization of...

rajesh.r (11/15/2012)

---

Is there any option to improve the performance of above queries instead of creating separate index on the columns name,email,city,country

What are the options to improve the performance of above...

execution plaan need here

?????? need mmore clarification