Dragging this one up the list again.  Hopefully someone new will have an idea what's going on.

cheers,

Michael

Robert,

Thanks for that.  That was a good process level explanation - plain english and not abstracted.  You should write the MS help files. 

Cheers,

Mike.

So are you saying that if you have a clustered index - all other indexes store their 'pointers'? in terms of the clustered index? 

How is the info stored without...

I've never actually had a close look - but have just done that on the most inserted into table and it seems that it's about 3/sec.  This will depend to...

We have to do this a lot (the clients always chasing changes) and we never drop subscription (there's way to much data over slow connections).  We use the second method in...

Thanks Andy.  I finally got around to trying it out and it worked a treat.  That sort of information should be mentioned in the general help on create table.  Did a...

Absolutely you can have old info still on the pages when you drop a column, it's one of the tricks SQL does to speed up table changes. For example,...

OK - here's the table script...

CREATE

TABLE [dbo].[tblCustomer](

[CustomerID] [int]

IDENTITY(1,1

Oh - and does someone know how to find out what page a particular record in a particular page is on so that I can use "dbcc page(etc)" to dump...

I've been tied up for a little while but have managed to do more of an investigation on this.

Thanks for your replies. David, I had seen that link but had...

Seems I asked a difficult one.

Don't worry about it. I'm going to run with the 2000 dlls and make sure the client is never intalled on the server -...

Thanks David - That works.

It's a bit messy as there's twice as much code but will do. Below is what I'm doing. I find it strange that the...

Stats have been updated, and the db reindexed.

The db's only 800M in size and we've got a gig of ram and 1 gig VM. We can copy 1gig across...

I'm confused.

Are you sure you're wanting to do an insert and not an update to specify which value is the low cost?

Something similar to this came up recently...here we go...

Thanks Julian - I'd never noticed the Full Outer Join before.

And with that knowledge in hand Julians is definately the way to go.

cheers,

Mike