did you have a look at "Troubleshooting Service Broker (SSB)"

Extended Events is the way to go.

Have a look at the attached script ( capturing key violations ) to get you started

Why aren't you just using 3 inividual inserts ?

Especially when those perform way better.

it depends:

Have a look at GRANT

and GRANT Server Permissions

GRANT view definition ....

vs


GRANT view ANY definition ...

Last time I checked, you could change master db to full recovery, but it did not actually use full recovery !!

This was a couple of editions ago, so I'll...

Creating a single full backup after its monthly ( or whatever frequency ) operations have been done and it has been switched to "read_only" state, would do the job.

However, you...

Can this help you out?

"Troubleshoot SQL Server 2012 Express LocalDB"

And quite an adventure it has been! ( and still is )

I would only "grant" an RPO of 24 hours for DEV systems, and even then urge then to use full recovery and persue an RPO of max 1 hour.

Don't let...

"...There is no PRIMARY KEY on this table. Its a HEAP...."

The lack of a primary key does not make the table a heap. ( it is more a lack design...

yes, if it is causing page splits

( check clustered index, sort according to clustered index of possible )

You should be asking "why has this table 50% unused space" ?

• Is the free space on the data file(s) or in the log file ?
• Indexes can be...

SQL2022 is known to not being the fasted of the versions.

Have a look at Brent's blog Which Version of SQL Server Should You Use?

Have a look at Erins blog: Category: Statistics  

and Kimberlys blog about statistics

The evolution the product made over the years is still amazing me.

Even though, its current progress has less to do with the RDBMS engine itself.

I especially like the fact that...