"my body measures are 8 width by 10.5 height."

Your page size is also 8 width by 10.5 height. With .25 inch margins, that only leaves 7.5 by 10.0 for the...

• This reply was modified 6 months, 1 week ago by ratbak.

It sounds like you need to get your network, SAN, disks tested & fixed. Your network and/or disk I/O sound abysmal.

4TB isn't very big. I have 4-14TB backups completing in...

@@VERSION returns the SQL Server database engine version.

For SSMS, you'd just click Help - About.

SSMS 21 (now in preview) adds built-in Git support.

You are right -- source control...

@@VERSION returns the SQL Server database engine version.

For SSMS, you'd just click Help - About.

SSMS 21 (now in preview) adds built-in Git support.

You are right -- source control...

I don't understand the implementation/value of clan.parents. If you are only modeling biological parents, I would think would simply have a motherID & fatherID on clan.person, which is a self-reference...

Duplicate of https://www.sqlservercentral.com/forums/topic/data-diagrams-data-types-with-column-names

Right click on the table, select Table View -> Standard

https://www.sqlservercentral.com/forums/topic/data-diagrams-data-types-with-column-names

If you specify different paths with MOVE, it will ignore the existing paths & use the paths specified.

It sounds like you will need to generate dynamic SQL for the restores...

Is buffer pool extension enabled?

SQL Server Standard edition allows a maximum buffer pool extension size of four times the value of max server memory.

Why create or use the empty database to start with? Why not just define the new database name in the restore, avoiding any risks of database being in use by...

You said grouped index... Does that mean clustered index? Are there other indexes?

What is the compatibilbity level?

How does the execution plan compare between the two?

Can you share w/ https://www.brentozar.com/pastetheplan/?

You could preface every script w/

SELECT @@SERVERNAME, DB_NAME()

to force you to verify the environment before running anything.

If there a few server/databases you most use, you could create...

Why are you still planning to run SQL Server from a laptop instead of an actual server or at least a regular (desktop) PC?

Did you install SQL Server Express Advanced or LocalDB package (rather than "regular" Express)? They appear to be the only ones that actually install LocalDB.

On command line, what does