Doh I forgot to take off 1 for storing zero.

Just wondering why you & with 9223372036854775807 not 9223372036854775808 .

I got 9223372036854775808 by 2^63, so I'm missing something.

Thank you!

I knew about bitwise and but had only used it to test for a series of flags stored in an integer (1 = a , 2 = b, 4...

Hi Greg, thanks.

I can confilrm it loads a .dmp, I ran their demo software but it is limited to 5 records per table so gives no idea of performance!

I was...

Thanks Sabya, yes tried that. It seems to be when concatenating string variables in the vb script.

Thanks Gail - nice article - helped me understand about index seek.

Gail - Thanks for persevering with me.

I have changed both indexes (tblCustomers & tblPurchases) and now get a SEEK on both. Hurrah!

Lots learned.

Thanks again

Allen

Thanks Gail, I'll redo the index (didn't realise the order was important).

Thanks both !

Gail - got your article on actual rows vs estimated and sure enough in the actual xml the actual executions (across 4 threads) = 832 which is the...

Thanks Gail, Grant.

Interesting article on parameter sniffing. It not a stored proc just a script executed in SSMS. Exact script below. But I did learn about parameter sniffing so that...

Thanks Roy

VPN may be out of the question because of security concerns even though for me it would seem to be the simplest to administer, my other option seems to...

Thanks Gail,

I hadn't heard about ther slot table before.

Your post prompted to to have a play with DBCC IND & DBCC PAGE and I can see, running your example, that...

Thanks Gail,

I thought that it keeps rows with adjacent clustered index entries, subject to space being avaiable on the page, on the same leaf page. Am I missing something?

I...

Hi Ankur,

Check BOL here

ms-help://MS.SQLCC.v9/MS.SQLSVR.v9.en/udb9/html/c498fe0c-a0ff-4677-a419-31f0e7875b61.htm

Edit: Hmm not sure if that lik works!

Because a clustered index determins the physical order of records on disk I guess it needs to add something to...

I think at the physical level (on disk) the are the same but a primary key statement ceates a PK Constraint wheras the unique clusterd index does not create a...