Thought provoking article which I am sure will raise a lot of issues drawn from personal experience.

In my professional career I have sometimes had to try to take a 'common...

Good morning Johan,

Thank you very much for providing me with what will definitely work for me now.

Can't claim to fully understand what is going on (Recursion never being a strong...

Thanks for your prompt reply

My own probe into the issue also started with a recursive CTE (and no - the recursion limit is not a problem), but I quickly came...

Speaking as an employer I've had good and bad experiences with employee training and certification

The one we spent a LOT of money on left immediately after gaining their qualifications and...

Yes Server is on the local Lan and very under utilised with little load as just being tested by a handful of people and just the odd applet for now

As...

sorry for the confusion

In essence I don't really have concerns about SSMS app taking 5-10 secs for reasons already stated

but I do have concerns about the 5-10 secs taken...

Thanks for your answers - food for thought and plenty to test when I get back to work later today

My Notes table will only have a handful of columns:

- Id,

-...

All else being equal then it would make sense to have all notes in 1 table with NVarchar(Max), and for those 5-10% of notes that are longer than 8kb in...

Thanks for the reply

But I am not clear on this as my choice was down to whether I continue to segregate my Notes into 4 tables depending on the size...