As you discovered, case returns an expression. It does not execute an expression.

Uncomment it? (remove the double hyphens before ,[Date])

Does that code actually work with the extra comma?

In addition to his other tips, as Lowell illustrated but didn't explicitly advise, make sure you are enabling compression on your backups.

Is server virtualized? Make sure you have sufficient I/O...

What about SQL Server native backup does not fit your requirements?

If refnum is int in both tables, why are you comparing it to a string ('123456')?

Pass it as an integer without quotes.

Are both tables in dbo schema? I recommend you...

"this is not enough of an annoyance for most people to seriously start looking at something like PostgreSQL"

Most? Probably still true. But they might want to re-evaluate their over-confidence and...

RedGate SQL Search is an incredibly valuable tool!

"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 1 years, 4 months 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