I just rewrote the first query a second time:

Select top 1000

a.*

from

doclist a

where

a.doccode not in...

mrbonk (6/11/2013)

---

Ok, I'll modify my original question.

Why does this first query perform so much worse than the second one?

First query:

with doc_index As

(Select ROW_NUMBER() Over (Order By docdate desc, docid...

Krishna1 (6/11/2013)

---

Hi Lynn

What you have mentioned is exactly what is present in the procedure. So in such situation we can not view the rows from the Remarks table till the...

vishalsurya50 (6/11/2013)

---

Hi ,

Last week we increased RAM and processors. now ,In our environment we have 2 processors,6 cores and hyper threading present ,so a total of 24 processors (6*2*2) available...

Duplicate post. Please post any responses here.

Please don't make multiple posts. It will simply fragment any responses you may get regarding your problem.

Why do you show us what you have tried so far. That way we know where you are at and where you are having difficulties.

Sean Lange (6/11/2013)

---

Lynn Pettis (6/11/2013)

---

Sean Lange (6/11/2013)

---

This should do it.

declare @MyDate datetime = '2013-03-08'

--set @MyDate = '2014-08-08'

set @MyDate = dateadd(month, 3, dateadd(yy, datediff(yy, 0, @MyDate), 0)) --gets April 1st for...

Sean Lange (6/11/2013)

---

This should do it.

declare @MyDate datetime = '2013-03-08'

--set @MyDate = '2014-08-08'

set @MyDate = dateadd(month, 3, dateadd(yy, datediff(yy, 0, @MyDate), 0)) --gets April 1st for the current year.

select dateadd(wk,...

krypto69 (6/11/2013)

---

No. I haven't used maintenance plans in years, but iirc you can setup the maintenance plan to delete old backups that are more than a set number of days...

Well, seeing as we can't see what you see it is hard to give you a really good answer instead of a shot in the dark.

I stick with my original suggestion, write a stored procedure that does the work with elevated permissions based on data passed into the procedure and give your co-worker execute permission...

Perry Whittle (6/11/2013)

---

IMHO backup jobs should be running on the mirror, they should at least be intelligent enough to skip databases that are not online.

The mirror may not always be...

No. I haven't used maintenance plans in years, but iirc you can setup the maintenance plan to delete old backups that are more than a set number of days...

Are you using compression at the row or page level in your database? If you are then the data would be compressed in the tables and/or indexes but I...

Looks to me that you may need to write a procedure that is granted the necessary privileges to accomplish this task for the Jr DBA's based on information they pass...