102 instead of 101 ?

https://docs.microsoft.com/en-us/sql/t-sql/functions/cast-and-convert-transact-sql?view=sql-server-ver15#date-and-time-styles

Please select Johan's post as the correct answer (not mine). He did all the work.

• This reply was modified 3 years, 10 months ago by homebrew01.

If you're really wanting to examine growth rate, maybe you can look at backup history and see the size of the database backups over time.

Backups are usually smaller than the...

• This reply was modified 3 years, 10 months ago by homebrew01.

Select *

, stuff( ( select rtrim(T2.Postcode) + CASE WHEN T2.id = T1.id + 5 then '' else ', ' end

from Postcodetbl T2

where T2.id between T1.id + 1 and T1.id +...

• This reply was modified 3 years, 10 months ago by homebrew01.

Johan's code assumes postcode is entered sequentially and uses ID  to order them.

But if LL15 was Inserted before LL14 then you will get different results than you want because the...

• This reply was modified 3 years, 10 months ago by homebrew01.

Never say "Never" !  Why is postcode varchar(50) ?

Also, Doesn't seem like a good idea to have the table name the same as a column name.

• This reply was modified 3 years, 10 months ago by homebrew01.

PostCode is varchar(50). 50 x 5 = 250 plus commas ( and spaces ?).

#TMP is your table name. Johan did not know the name of your table at the time.

Using...

• This reply was modified 3 years, 10 months ago by homebrew01.
• This reply was modified 3 years, 10 months ago by homebrew01.

PostCodeNext is not long enough to hold 5 PostCodes, commas and spaces.

• This reply was modified 3 years, 10 months ago by homebrew01.
• This reply was modified 3 years, 10 months ago by homebrew01.
• This reply was modified 3 years, 10 months ago by homebrew01.
• This reply was modified 3 years, 10 months ago by homebrew01.

Red cars are faster.

Performance issues with maintenance tasks like update stats takes forever

This is SQL 2014, so we can have only 1 index on the table..

I tried implementing partitionning in dev, but...

• This reply was modified 3 years, 10 months ago by homebrew01.
• This reply was modified 3 years, 10 months ago by homebrew01.

Any time this combination of values changes, you will get a new line. So pare down the fields in your select and group by until you only get what you...

That documentation seems to suggest that it's only available on Azure instances and not "standalone" instances.  Can someone...

Were the backups working, and just started failing ? Configuration change ?

What tells you they failed ?

• This reply was modified 3 years, 11 months ago by homebrew01.

I use the first 2 fingers on each hand, and also the ring finger on my left hand for the 'A' key and the <shift> key. I use my thumbs...

That might work if I can figure out how to get line breaks after each row.