Yes - definitely need more input, and I wasn't assuming SAN or DAS...

I see this a lot, and the assumption by the person is that splitting out data and indexes...

Remi - I don't disagree with you here. Just saying it may not be necessary and may be more overhead than needed.

It all really depends on the query that...

Are you logging into the server using a windows administrator account? When you state that SQL Server and SQL Server Agent are running with an administrator account - do...

lance.kentwell (8/20/2011)

---

Im using the below quiery to get the first day on the previous month. If I run it now I get the result shown.

SELECT DATEADD(s,0,DATEADD(mm, DATEDIFF(m,0,getdate())-1,0))

2011-07-01 00:00:00.000

I want...

Mike John (8/20/2011)

---

Can you just confirm something, are all 4 drive letters simly paritions on the same mirrored pair of discs?

From what you said in the original post it sounds...

I agree with Ninja...a loop here is one of those cases where it would be appropriate. You could build a dynamic string that includes all of the sp_send_dbmail calls,...

aaron.reese (8/20/2011)

---

Taking out all the left joins and replacing with joins solves the speed, but at the risk of losing records, But I think it is acceptable losses. If...

GilaMonster (8/20/2011)

---

I'll tell Grant he's wrong. He'll agree with me.

The query optimiser costs were times at one point. They were benchmark times on a specific computer in the MS testing...

So, you only want to exclude rows where varA = 1 and varB = 'Green'.

WHERE NOT (varA = 1 AND varB = 'Green')

Assuming that varA and varB are actually columns...

I am assuming this is on Windows Server 2003 and not on 2008. If you are on 2008 then this may not be correct.

No, the quorom drive does not...

Even if you cannot afford SQL Compare now - or convince management of it's usefulness, download the trial edition and use it to synchronize the systems.

Use the tool to generate...

Because the database is mirrored - you cannot access the mirrored database.

If the log file is growing on the mirror, it...

Sorry, misread this...

Welsh Corgi (8/12/2011)

---

I did not intend to offend anyone.

I just thought that this could be a practice exercise in the event of a issue in the future.

I prefer Lightspeed...

Open up the maintenance plan in SSMS - select the maintenance cleanup task and generate the T-SQL. Paste that here and we should be able to see if there...