The SQL 2000 forums are further down the page. They are there. I've requested a mod to move this thread there.

For statistics on SQL 2000, you can query sysindexes (that's...

Replication is not a HA technique.

By 0 RPO, do you mean absolutely 0 downtime? That's not possible. It's possible to get it to a couple seconds in favourable circumstances, but...

Joie Andrew (2/4/2010)

---

If you are unsure of the result you could always wrap the statement in a transaction. That would ensure that if it was cancelled it would be rolled...

So there are no queries that filter on AffiliateId or PartnerLocalDate without also filtering on CampaignID? Nothing that filters on just SubId?

I'm actually not sure what it is that you're...

What's the difference between pulling 50MB of data from one drive and...

Ali_SQLDBA (2/4/2010)

---

that was because of space issues with the original...

I take it you haven't read the links I gave you, seeing as the first one was a discussion of index...

Why?

i am confused. let's take an example of a million row...

Ouch.

Depends what kind of queries you're running.

Do...

abo_moaaz (2/4/2010)

---

1)As DBCC CHECKDB wasn't run before, this page corruption seems to have been present since weeks ago:w00t:. Does this entail necessity of running CHECKDB on daily basis during afterhours...

Please?

Would love to. As soon as I persuade someone to pay for it...

What do you mean by 'average of row counts'. Averages over what?

I see 4 rows in the hour 7-8, 5 in the hour 8-9 and 2 in the hour 9-10....

Please post table definitions, sample data and desired output. Read this to see the best way to post this to get quick responses.

http://www.sqlservercentral.com/articles/Best+Practices/61537/

Have a look at this blog post. Step by step for getting a DB back when the log's deleted. The process for when it's detached starts just past half way...