Already asked in the appropriate Question of the Day thread

http://www.sqlservercentral.com/Forums/Topic565885-1370-1.aspx

Please don't post multiple threads with the same question. It wastes people's time, it breaks replies up and results in people...

The last 2 may help. Depends where the slow down is coming from.

Check your IO performance when the index defrags are running. I'd suggest the following counters:

Physical disk:avg sec/read

Physical disk:avg...

Get more drives.

Can you explain a bit more? What drives are filling up (and with what) and where are things configured?

If you print out the dynamic SQL before you exec it, what do you see?

I tested a section of your code out

DECLARE @Stamp varchar(25), @global_time int

SET @global_time = 25

set @stamp...

Your query, as written, cannot use index seeks. The computation in the where clause means that the only index usage possible is a scan. Also, all or your indexes are...

Depends. 😉 On the stripe size, what kind of writes are done, and a bunch of other things.

With a 4 disk RAID 5 if a write only affects one of...

I would go for option 2, simply because RAID 5 has the slowest writes of any of the commonly used RAID levels

Please don't shout (all caps)

Unless there's some form of auditing in place, there's no way to know when a table/index was last updated.

Table schema and sample data please?

I suspect what you need is a NOT EXISTS rather than a !=. You're looking for patients where there are no matching rows in the...

There's not really enough information to answer the first question. Could you post the schema of the two tables and some sample data please?

Try using replace instead of the substrings,...

You'd need to set up a linked server (Books online is your friend)

Assuming you have a linked server called server2 and database2 is on that remote server, the query would...

Yes. It will fail with EXECUTE permission denied on < Procedure name >

If you've granted the user the appropriate execute permissions then the insert will succeed. It's the concept...

sql guy (9/15/2008)

---

they are on the same server and this is what i tried. i am getting a result but its gibberish!! i am just starting off sql so may...

From object explorer, expand out security (under the server), right click, choose new login. Make sure windows authentication is selected. Under login name enter the domain and user name -...

Can you post what you've tried please?