Nice but I would use a table variable for this rather than a temporary table.

If you have separate databases then you can move them around to suit your needs.

In a virtual environment you can tailor the virtual server to the needs of the database.

If...

Nothing provided you are running on a single server. The instant you go multi-site or employ a sharding strategy all sorts...

I would only use guids where they are necessary and never in a clustered index.

As already pointed out GUIDs are not as unique as they should be though you are...

Ah,...

When I'm running scripts like this I make sure that the failure notices print ****FAILURE as this standard out like a sore thumb when the output is echoed to a...

You've got it lucky. In my day we used to get asked to fix household appliances, rewire houses and mend video recorders. Thats if we were lucky:hehe:

I've currently got a big push from developers to allow nHibernate into the databases.

My concerns are security implicit in direct table access and performance.

The "Oh everyone uses it" argument doesn't...

We've been evaluating MySQL Vs SQL2008. So far the cheapness of MySQL means that a scaleout architecture is a practical proposition. Performance wise scale-up is not so hot....

Thanks, you have just confirmed my worst nightmares and I have to say I'm not altogether surprised.

By none functional requirements I meant things like "

a. must support x queries...

We have an experienced architect who has worked with agile development for a number of years.

He has some pearls of wisdom

1. It takes 18-24 months for the agile methodologies to...

Anyone who was in employment when SQL Slammer hit is unlikely to leave servers unpatched.

SQL Slammer caused so many problems because it attacked all editions of SQL Server so the...

The one critique I would have is this:

The article mentions quite heavily the editing process, so it would have been nice to have some kind of appendix where the reader...

Personally my favourite was "The losers"

A wise boss once told me that he was interested in assigning responsibility rather than blame. By assigning responsibility there was an expectation of some positive action such as...