Hi tripri,

The DB Design is a not a simple task.IF u design a Normalized Db for OLTP then you will get better performance while the DB is in Production.You can...

Hi,

This s a Gud site to share ur knowledge and expand ur Knowledge.

You can visit

[/url]

[/url]

http://www.sqlinfo.in/category/databaseadministration/heap-vs-clustered-vs-non-clustered/

Hi,

You can use a another table with columns doctorid,searchcount which should be updated on each search and it will improve the performance; since transaction act on another table.

Reagrds

varun R

since u r using windows authentication,your user should be valid windows user to login to the DB.Thats y i told to check whether ur user s a valid windows user.Hope...

1.I Hope your user is not a member in windows group

or

2. check the named pipes,sharedmemory,TCP/IP ports enable.

I think !st one is the reason.

Thanks

Thanks my dear friends for helping this,

i solved out this problem of high cpu uilization.The reason is one select query with inner...

use [dbname]

DBCC CHECKDB

now u will get the DB related results