You need lots more RAM and probably much faster IO. Do you really have just one disk for this??

Mirroring, and HA/DR in general, are very advanced and complex topics. I highly recommend you get a professional in to ensure you a) understand what your objectives really are...

You can go back and forth here on the forum for days or even weeks trying to isolate/fix the various and sundry causes of problems. Or you can hire...

without a lot more information you don't have enough spindles. 42ms/io isn't good for an OLTP system and is marginal for olap.

you might be able to tune poorly performing...

How about stop doing count and simply do exists.

Not sure why you would need the views to make that efficient...

That doesn't sound right. I thought SELECT...

Jeff, here was my test:

MMREFW21099: fat table, no indexes, 72667 rows

CompanyID: column on that table with 48 rows with value '20067255'

with clean buffer cache I had 2 window open...

mar1jxm (2/11/2010)

---

Here is what we do with our huge tables.

Select *

INTO Table2

FROM TABLE1

WHERE YourStatement (something like Account_Start_Date < '01/01/1980'

Drop table Table1

EXEC sp_rename 'Table2', 'Table1'

Runs much faster than Delete because there...

1) create smallest index necessary to cover your where clause. If you have lots of fields in the where clause, pick a small column or two that provide the...

sknox (2/9/2010)

---

Martin Vrieze (2/9/2010)

---

When these forecasting tools are used to base critical business decisions that impact people's lives and livelihoods, PLEASE be sure and leave this type of work to...

Let me remote...

rohdester (2/6/2010)

---

We have a SQL 2005 instance running on a dedicated server. And the last week or so we have experienced huge performance problems. Our web requests have piled up...

I wonder if the OP realizes that he/she is open to still putting in a record that already exists without proper transactioning/locking, especially if they do it in a disconnected...

You posted over 150 lines of stuff in the original post. Forums are useful for helping out with targeted, fairly straight forward/simple problems and are 'worked' by people who...

colin.Leversuch-Roberts (2/4/2010)

---

I think that sometimes the desire to achieve a goal masks the requirement. I've seen many hours spent trying to replace cursor statements on pieces of code which run...