stevecurtis3 (6/22/2009)

---

We never delete anything in one go!!! What we do is change its name by prefixing XXX to its name, and then later delete all the XXX's....

1) I agree with Mark about Drop obsolete objects. It is virtually impossible to find and properly scan all code that might run against any given database that might...

The main area where you can get in trouble with forced parameterization is when you have lots of calls against values that have widely disparate numbers of rows hit, especially...

Rob Reid (6/10/2009)

---

The page in question loads fast and runs okay 98% of the time. The query is indexed correctly and I am looking into the query plans. The problem...

I think that will require...

Novel suggestion: why don't you actually find out what is causing the problem, and then try to fix that? 😀

Seriously, monitor the various Perf Mon counters...

There are several 3rd party auditing products - ApexSQL and RedGate both have them IIRC. I think Paul Randall wrote a freebie script that will create the necessary triggers...

I believe you are mistaken if you think that MS wasn't working on SQL Server 2008 in late 2006.

Were your physical disk counters for each individual drive?

Spurious IO delays during high activity can be expected and really aren't an issue as long as they are very limited...

I wonder if the ONLINE part of this is causing lots of extra tlog activity. See here, ms-help://MS.SQLCC.v9/MS.SQLSVR.v9.en/udb9/html/eef0c9d1-790d-46e4-a758-d0bf6742e6ae.htm and here ms-help://MS.SQLCC.v9/MS.SQLSVR.v9.en/udb9/html/d82942e0-4a86-4b34-a65f-9f143ebe85ce.htm in BOL and also follow the various links...

Mad Hacker (6/4/2009)

---

Steve,

The vast majority of the SSC Community truly appreciate your efforts, including any occasional errors that might be made. I would think that a "newbie" would have...

search the web to find Paul Randall's blogs about dbcc checkdb. He litterally worked on that code in the engine at Microsoft. I also recommend you hire a...

Gail is right - if 354 and 291 milliseconds are sustained values for writes/reads then you have a serious problem. If they occurred during a 2 minute period of...

easiest is to zip the file and attach that. it then opens with the right app. 🙂

pbowman (6/4/2009)

---

OK, well I have the plans. Not entirely sure how to include them.

The base queries:

declare @topid bigint

print getdate()

select @topid = isnull(max(NotificationSequenceID),0)

from Exchange.dbo.NotificationSequence

print cast(getdate() as varchar) + ' Max...