Here's one method you could try:

 

SELECT ... /* various fields */

FROM PatientInfo

WHERE ... /* various parameters */

AND UserID IN (

   SELECT DISTINCT...

My opinions only....

1. Database Designer

Works with end users, business analysts and developers to create the logical schema. Might use tools like ERWin. Might use a pen and paper....

Are the SPs separate job steps? If so, can you determine which of the steps has increased in time?

Sounds like a different query plan is being chosen, based on...

Never realised you could put them all in one statement.

I learn something new every day.

Cheers,

- Mark

Check also that c1 is not subject to updates. If it is then all NC index entries are updated too.

Cheers,

- Mark

In QA do:

dbcc traceon(-1)

dbcc traceon (1204)

dbcc traceon (3605)

This should write deadlock info to the errorlog.

Cheers,

- Mark

Appears to be a database maintenance plan. Check for jobs called "Integrity Checks Job for DB Maintenance Plan...."

Cheers,

- Mark

Just out of interest... any relavent errorlog messages generated for that database when you started sql?

Cheers,

- Mark

Does the time coincide with the execution of any sql scheduled jobs?

...and, is it regular? eg. every hour exactly

Cheers,

- Mark

Edited by - mccork on 09/15/2003 8:17:44 PM

Brian Knight wrote an excellent multi-part clustering article. Check it out, starting with http://www.sqlservercentral.com/columnists/bknight/clustering_a_sql_server_machine_.asp and then move on to the first of several step-by-step articles http://www.sqlservercentral.com/columnists/bknight/stepbystepclustering.asp

Cheers,

- Mark

Maybe there's Windows scheduled task that kicks off every hour.

Failing that, it may be fired from another machine. You can run profiler, looking for DBCC events only, and include...

I don't understand the problem.

12.1000 is 12.10

It's also 12.1 and 12.100 and 12.10000.

The (18,4) determines how it is represented when displayed.

Cheers,

- Mark

Try:

restore database YourDBName with recovery

Cheers,

- Mark

Oh come on Phillip. Be a sport. No-one's going to use a "social" forum like....

Cheers,

- Mark

...get their posting count...

Cheers,

- Mark