That made me chortle, we clearly have similar senses of humour (or some might say lack of...

As far as I know, no.

You'll be aware that Microsoft are trying to clamp down on 'back doors'

Ypu may be lucky though .. one of the super posters may contradict...

Simply do

DBCC CHECKDB

It will perform all the checks you need.

The DATA_PURITY option just performs more limited checks.

Thanks for the feedback.

Michael, you've clearly put a lot of effort into password generation but it comes to close to 'I can't remember it without post it stickers' for...

Thanks for the feedback.

Glad it's sorted.

Tim

kupy (5/19/2009)

---

select a.*

from a left outer join on A.ref_no= b.ref_no

where b.ref_no...

Hang on .. you seem to have introduced a conditional clause now and switched back to talking about tables A and B.

I think arjun.tewari was probably referring to the fact...

icampbell (5/19/2009)

---

tried the following code

SELECT distinct * FROM srs_esd JOIN srs_cap ON srs_esd.esd_code srs_cap.cap_stuc

however the distinct doesn't seem to work

tried this also

select distinct *

from srs_esd

where...

arjun.tewari (5/19/2009)

---

icampbell (5/19/2009)

---

If you have two tables A & B

A.ref_no= b.ref_no

how do i retrieve the detail of table A which do not appear in table B. The rows which...

Less, it will gve other processes time to get in and complete.

It's a bit of a balance how big the chunks should be and how big the gap should be....

If I understood your query it should be

select distinct *

from srs_esd

where srs_esd.esd_code not in(select srs_cap.cap_stuc from srs_cap)

not

select distinct *

from srs_esd,srs_cap

where srs_esd.esd_code not in(select srs_cap.cap_stuc from srs_cap)

Depends on the hardware.

Adding a null column should be quick as only the schema is marked up.

Once you start adding the data, the column will get populated and the page...

It depends what you want to do. What you are describing is just normal behaviour for the maintenance plan.

What will happen here though is that all the tables will be...

Well, you can save some time by doing it all at once

Alter table TableA Add ColA Bigint NOT NULL Constraint CF_tableA_ColA Default (0)

However 90M rows will take some time to...

A number of ways, simplest to read is probably

SELECT * FROM A WHERE A.ref_no NOT IN (SELECT b.ref_no FROM b)

These types of query are typically not that efficient when...