Hi,
try to shut down your sql server. And remove the ldf & mdf file.
Start your sql server.
And now try to attach the mdf file without the...

Hi,
I think you can't stop  a rollback. If you restart your server, the sql server will continue the rollback.
Maybe you can try to detach and atach the...

Hi,
I think, if anybody should help, we need more informations
CPU?
DISK? SSD, SAN?
Memory
Size of the database
Rowcount of the biggest table
etc.

Kind regards,
Andreas

Hi,
you are able to  get your results as a text, not as a table:
Just press CTRL+T
But remember, MSforeachdb is not an  offical way to do that, I...

Hi,
if you use always on, you are...

Hi,
have you ever tried  an other path?
On your sql server we are not allowed, to create files in the root directory.
Kind regards,
Andreas

Hi,
it depends, synchronous is a standard feature, asynchronous is a enterprise feature.
If you got a enterprise sql server, you can put one mirrored datebase to sync, the...

Hi,
yep, and this is  your fault.
If you start the sql service in the SSMS, this is a failover .

Try to initiate the failover with...

Hi,
by default, your cluster is allowed to take 1 failover in 6 hours.
If you change the value to 4, your cluster is allowed to take 4 failover in...

Hi,
it depends! No one knows your workload, or the size of your database, or that  kind of used queries.

Do you mean the index fill factor? Start with...

reported as SPAM

Hi,
never use %, set some value that fits to your database size.
But the best way, do not use autogrowth. Calculate the size of the database per year, and...

Hi
every time you select something from a view, it is fresh.
The sql server ist able to create a "static" view:
https://docs.microsoft.com/en-us/sql/relational-databases/views/create-indexed-views?view=sql-server-2017
The the default view is created...

Hi,
sorry, my post was wrong, sorry, I had to delete .
Kind regards,
Andreas