@MaxVernon already gave all the info you need. Just some addition from my side. The bigger the transaction the harder the (pre)calculation for the SQL Server. That's why your remaining time in ...

Good question. The integrity check in the maintenance plan is enough since it will run a dbcc checkdb. From MSDN: integrity check The Check Database Integrity task encapsulates the DBCC CHECKDB ...

The use of the differential Backup is simple. Instead of restoring a huge amount of log backups in a row, you restore a full, a diff and a small amount of transaction log backups instead. Yes you ...

You most probably re-index your database between the log backups. This means your log backup contains a lot of transactions from these maintenance operations. Please check your maintenance plans. The ...

Deprecated functions / features work fine in your current SQL Server Version. It is just a hint for you that in future versions of the SQL Server these functions will be dissmissed or replaced by ...

I can recommend to use Robocopy, it has the support of multi threaded copy. And it won't take ages to calculate the packages before. Your syntax would be as follows: robocopy "C:\SOURCE\Folder\...

There is no other way than shrinking a db to claim back unused space. No matter if you truncate or delete data or update with smallers length of data, the .mdf file will stay the same size. Which is ...

I guess you are looking for a T-SQL command called "set statistics io on" USE YOUR_DB_NAME; GO SET STATISTICS IO ON; GO if put that before your query you will see the read pages the ...

Using performance monitor in windows you can for example watch the redo queue. Also any other db monitoring tool would help. The next sentence explains the redo queue, since I can't do it better than ...

First of all, signal wait time is the time a query is ready to run, but waiting for a CPU "slot" to be ready. When you are under CPU Pressure everything will be slowed down. To determine which query ...

Your error seems more related to memory pressure. Maxdop is a CPU setting. The Max degree of parallelism is heavily depending on your queries and your needs. You need to try it out. What should know ...

Please run SET STATISTICS IO ON and run one of your queries and check the number of pages beeing read in your message tab. A lower execution time doesn't mean that it was more efficient, there are ...

There are several things which are needed to know here. Some EC2 Instances on AWS are using shared CPU, this could be one reason why your instances are performing different. Also the same EC2 ...