Oh. I was assuming that value is inaccurate has they are all set to the current file sizes. And they are all slightly different. Hovering between 15 and 25 GB...

Tiny. 64MB I am told.

No one knows if that's per file or total. But assuming total that is less than a GB.

Is the initial size stored...

It was built with the Installers recommended/default -- the number of files match the number of virtual processors. And growth is set to 1024 MB.

We had a report get run against the wrong instance. Tempdb grew from 50-ish GB to 160GB.

I've used a couple, VSS back in the day. Most recently CVS/Perforce/Tortoise...

From what I've been reading of GIT I quite like it. I like how everyone has a...

Hiya Thom, thanks for such a quick reply.

 I like what you've said and your reasoning. Our current DPO (who leaves in a couple of week) is very knee...

I presume the original designer never expected to ever reach Z, or didn't care. Or perhaps by the time one gets to Z you have archived/deleted A. The back story...

No. That character is static and stable.

Ultimately it is 1 character per year and we're currently on J, which will turn into K on 1 January. But K...

No. Clustered on a bigint surrogate.

I am partitioning for two reasons:

firstly so that entire partitions can be phased out, that is put on slower storage (non-ssd) until that partition is deleted. Though saying...

Absolutely. Agreed.

I am only providing a shell of a database so that they can decide what data they want to add in that represents a reasonable spread of...

Just look up data.

As this database has had a few years of abuse, I am going to get a known good version, script out all the objects and...

Hiya, thanks for your reply.

Yes, this is indeed meant to be a one-off clone to set the new standard, a blank slate if you will. In this case...

Jeff, (and others),

I've not go to testing this yet but just had the thought: would the db's remain synchronised that are in availability groups, or would I need...