Log was backed up

Earlier today, I was struggling to diagnose a T-SQL job that selects info from a master db table and sends them to an email. I kept getting SELECT permission issues...

You can ignore anything under 1000 pages because performance won't be as greatly impacted. Understanding what fragmentation is will help you see why this is so, but basically its because...

MSDN has instructions on how to do just that:

https://msdn.microsoft.com/en-us/library/ms143393.aspx

You can use:

SELECT job_id, [name] FROM msdb.dbo.sysjobs;

on each server.

There are a couple of requirements for a WSFC one of which is a minimum of Windows Server 08 Enterprise or Windows Server 2012 Standard.

- Windows Server...

I just finished doing something similar with a co-worker yesterday. We used sp_WhoIsActive to find locks with

...

You can just move them from the HDD to the SSD. Make sure you move the MDF, LDF, & any NDF (if you have any filegroups or other secondary files...

You can create a trigger to do exactly that.

See this link:

https://www.mssqltips.com/sqlservertip/2864/email-alerts-when-new-databases-are-created-in-sql-server/

There was also a thread on this same website answering this:

http://www.sqlservercentral.com/Forums/Topic1071980-1550-1.aspx

Why don't you just create a job that'll drop them on the dates you specify?

Have you tried:

select * from tempdb.sys.objects

?