the original article was written using SQL2005 but there appears to be subtle differences in SQL2008.

I'll have a look into it ASAP.

Rutulian (8/12/2011)

---

One of the more fun interviews I have had:

You are standing on the bank of the Thames.

How can you find out the flow rate, assuming the internet doesn't exist?

(10...

Thanks for the feedback. I haven't tried it with a linked server query.

Where possible I base my articles and experiments on the sample databases Adventureworks, Northwind or Pubs simply...

That's unfortunate actually. I now live in the south part of America and have been trying very hard to not pick up this southern drawl. It's horrible.

"I've got...

Not yet but close.

My experience, and I've had a lot of it, is similar to your own.

I have seen it work in an e-commerce site where there was a large...

So a bit value is 1 or 0

A date is 20110728

A Money value is 65000

If money is a whole value then why not use an INT?

If money is a decimal...

What proportion of reads do you have to writes?

Can you subdivide what you do along a product line basis?

Can you break your database out into separate DBs for customers, products...

The InnoDB engine has a default page size of 16K which is global to the engine.

The MySQL web site says you can recompile the code to anything between 4K and...

If you accept the premise that your surrogate keys are going to be BIGINT values then you could try the following

The right most 6 characters are just a sequential number

The...

Any views or procs that reference objects in your CONFIG database?

anything that uses cross database ownership chaining?

What exactly are you trying to achieve?

Are you attempting to come up with some sort of key generator?

Whereas a uniqueidentifier is 16 bytes a bigint is 8 but random keys...

This would be on my list of things to avoid.

The nearest I've seen to a "safe" solution was where the tables for which these actions were allowed were stored in...

It's taken me a long time to wean myself of querying sysobjects, using GETDATE() etc.

I'm finding I'm dealing with disparate data sources so focussing on ANSI standard commands does eventually...

Do you actually use the XML datatype within SQL Server for anything other than the storage of XML data?

What I am getting at is if all you want to do...

I take it your DOMAIN\Administrator account has permissions to both SQL Server and the file system where the replication snapshot files are kept?

Just asking because some places block network and...