that's the right query, but you truncated the trailing spaces in counter_name, they are needed for the query to work:
SELECT * from sys.dm_os_performance_counters where object_name='SQLServer:Databases' and counter_name='Transactions/sec                                     ...

given the new listing for Vijay's query, maybe something like:
DELETE FROM Table1 t1
WHERE NOT EXISTS
  (SELECT NULL FROM Table2 t2
   WHERE t1.col1...

SQL Server only stores execution information for a query for all users for the duration the execution of the plan is cached in sys.dm_exec_query_stats.  If you need specific user for...

I'd say a key point in making the determination of using virtualization is the knowledge the IT department already has about virtualization.  While it's easy to setup new virtual servers...

I'm not sure offhand why some would not script with the binary part, when I script mine through Object Explorer, they always come out like:
CREATE ASSEMBLY [myAssemblyName]

I'm not sure I understand the reason you need to keep recreating the assembly in SQL Server, but if you're just looking to avoid referencing the DLL file every time...

This was a nice demonstration of using partition switching to solve the problem of "loosing" the previous version of the data.  I suppose this solution would make a bit more...

For something like that, I'd typically use SSIS, with a Foreach Loop Container, such as described here:
http://microsoft-ssis.blogspot.com/2011/02/how-to-configure-foreach-loop-file.html

I'm not quite sure about dealing with the different...

I don't think the logic for last_outcome is correct.  Maybe something like this:
SELECT job_name = j.name, run_count, total_failures, total_cancellations, run_status AS last_run_status, run_datetime AS last_run_datetime
...

maybe it would be best to figure out the list of potential dates first, then compare?
DECLARE @rundate date = '2017-10-17';
DECLARE @comparedate date = CASE WHEN DatePart(dw,@rundate)=2...