That is normal, as tempdb will always have the same startup size per file on a given setup and will grow as needed.

I don't think we can configure its size...

xEvents are your friend !

Have a look in the attached scripts file on how I monitor hand handle failovers ....

et voila .... they already fixed it 🙂

You can get all backup / restore history from msdb database!

have a look at ....

select  BU.server_name
      , BU.machine_name
   ...

DBATools.io has a nice function called Find-DbaDbDuplicateIndex (however it has IMHO aflaw and does not report IsUnique for an index, reporting duplicate indexes composed of...

IMHO: No

It should be set to support the workload of the instance: "Why Cost Threshold For Parallelism Shouldn’t Be Set To 5"

Someone mentioned that issue on the SQL Slack community also Johan.

Unsure if that was also yourself, but if you file a feature request on http://www.DBATools.io/issues,  someone will take a...

DBATools.io has a nice function called Find-DbaDbDuplicateIndex (however it has IMHO aflaw and does not report IsUnique for an index, reporting duplicate indexes composed of the same...

DBATools.io has a nice function called Find-DbaDbDuplicateIndex

(however it has IMHO aflaw and does not report IsUnique for an index, reporting duplicate indexes composed of the same column(s) and column...

I hope you are logging failed logins somehow. In the detail information it states the actual reason for the failure.

there must be more detailed information about the failure.

Maybe my article...

You had better started a new forum post ! Whenever I see new answers to old Questions, I skip it

the point is to end the previous statement with a semi colon

and showing examples of CTE's...

you could implement a database ddl trigger handling on object creation for tables starting with those prefixes

( handle registration of create table + timestamp and drop table (+ timestamp...

I think RedGate has got some nice tools to handle that kind of operation

.....

Create another filegroup, and duplicate the table on the new file/filegroup.  Use the SWITCH command to move the data from the old to the new table.

ALTER TABLE schema.OldTable SWITCH TO...