I did the same test with a Standalone DB which is in the same SAN when the network is slow, but that is completing fast. So I am not thinking...

No users connected to it as the servers are in project phase and no load is happening on the server during the tests. execution plan is same for both cases.

• This reply was modified 2 months, 1 week ago by  eldosepd.

We need o do it as implicit transactions to avoid any blockings on the database, we are deleting millions of records everyday in a purge operation which cannot be done...

You can install SQL Server on a computer that is already running instances of an earlier SQL Server version. If a default instance already exists on the computer, SQL Server...

Backup .. Restore will be the best option in this case. It won't impact the incoming i/os to the procduction DB unless you are hosting the duplicate db on the...

it is possible to give execute permissions without write permissions. But If the stored procedure includes insert\update statements, the user can insert\update the table by calling the stored procedure.

Even if...

As all the files are on primary file group, you can empty the below files using the command DBCC SHRINKFILE ('filename',EMPTYFILE) and remove the files using alter database remove...

Check the tablesizes on that database periodically and check is there any tables are growing abnormally.

You can remove the secondary datafiles using the below commands

USE DB1

DBCC SHRINKFILE('filename1', EMPTYFILE);

and then delete the file:

ALTER DATABASE DB1 REMOVE FILE filename1;

Create a DML trigger and send mail using sp_send_dbmail based on the condition.