Hi

Thinking time is essential. We need to take time to sit back and think about the way forward or the big picture.

My thinking time is usually on my commute -...

Hi,

We have experienced exactly this problem in our organisation. The majority of our databases were created and maintained using Grails and Groovy scripting. It cost a fortune to hire a...

Neither do you need a join. In a view you would still be using a join.

Thanks,

John

Hi Tom,

I didn't see this as part of the natural/surrogate key debate. Is saw this...

Hi,

This was a very good demo.

I have always used a look up table in these situations, but I have used a surrogate key instead of the natural key on the...

Hi,

I have been a database developer for only two years. I have had a number of instances where I would like to define rules so for precisely the reasons that...

Hi,

I was wondering, would you say that this is the same as using a view in a query? The view is in effect a subquery. If you have tables that...

I don't know if it is used in any database for anything;...

Hi

It is not often I use the cross join, for obvious reasons, however, I hadn't thought about using it to identify records that have no match in another table before....

Hi,

I like the use of a CTE rather than a control loop structure, which is what I would have gone for.

I am curious though as to your use of the...

Hi,

I hope these references help:

http://msdn.microsoft.com/en-us/library/cc280604(v=sql.100).aspx

http://msdn.microsoft.com/en-us/library/cc280521(v=sql.100).aspx

In a nutshell, rather than allocating storage space for the sparse columns as you would regular columns which would be wasteful. All...