Thank for the reply and pointers 🙂

As always, it comes down to what people want from their cube, and this certainly will help the discussion move along. 😀

Hi Ken,

I was perhaps trying to be provocative to make a serious point 🙂

Re:- "In my opinion, *less* code is almost always a good thing - assuming it reduces complexity,...

The trouble is though that the CRUD procedures auto-generated are effectively line-item procedures? i.e. the processing is done RBAR.

Creating procedures to do this, means effectively grinding through programming data into...

Some of the against views (both in this discussion and in blogs referenced in the original editorial) indicated that data / entities used originally for one purpose, eventually get...

Most replies so far seem to be in favour of schemas.

Any more from those with a contrary view? 🙂

Simple and stupid sometimes works.

There are multiple scenarios ( I think ) where use of multiple schema seem to make sense (to me).

For example, consider partial projects A and B....

? ... from BOL ...

"Statements that make a simple assignment always set the @@ROWCOUNT value to 1. No rows are sent to the client. Examples of these statements are: SET...

I enjoyed working this one out, line by line 🙂

Good little puzzle to start the day. Thanks!

Good question :).

Forces thinking about why you might not want to, and that that executing DDL statements without understanding the underlying context can lead to unexpected results.

I don't think there...

Any cheap and cheerful mechanisms for testing this issue in a non-production environment are most welcome. Brute force will reveal issues that really need sorting.

What do the various published SQL standards have to say about this behaviour?

Surely, it is no more of a glitch, than say SQL being relatively lenient over implicit type conversion...

🙂 The right way to do things Gary

50% of people are of average or below average intellect. Seems quite a good 'excuse' for people to be average / below average at their job!

Here in the UK, I...

Indeed plenty of people will put huge amount of energy into other things ... family, children, social activities, community activities, and these will have a profound affect on their career...

There is a certification forum here that may be able to give good advice.

Generally the MS Press books covering an exam are a good place to start.

In addition, head over...