A small retake on the popular script which tells how much more time a running session will take to complete (only if the session reports percent_complete status).
SELECT servername = @@SERVERNAME, der.session_id, der.start_time, der.[status], der.percent_complete, dbname = Db_name(der.database_id), der.last_wait_type, der.blocking_session_id, runningsince=Datediff(MINUTE, der.start_time, Getdate()), runningforanother = CASE percent_complete WHEN 0 THEN 0 ELSE ( ( ( Datediff(MINUTE, start_time, Getdate()) * 100 ) / percent_complete ) - ( Datediff(MINUTE, start_time, Getdate( )) ) ) END, der.command, st.[text] FROM sys.dm_exec_requests der CROSS APPLY sys.dm_exec_sql_text(der.sql_handle) st WHERE session_id > 50 AND session_id <> @@SPID
SQL Server Databases are made up of physical and logical names. This article goes over the logical names, where you might need to know them, and then how to change them.
2015-07-20
8,326 reads
Constraints on a table in SQL Server are evaluated in a specific sequence. Knowing this sequence can help us leverage them to realize various business requirements.
2014-01-27
2,899 reads
Find the country, region and city of a user from an IP address using SQL Server. Oscar Garcia provides some code and resources if you want to dig into your analytics on your own.
2012-07-20 (first published: 2009-07-09)
54,566 reads
Use of event handlers provided in SSIS package to handle runtime errors while the package is running and logging the error information in the database.
2009-06-26
13,483 reads
Learn about the benefits of SQL Server 2008 consolidation on Windows 2008, with details on the different consolidation strategies available to organizations.
2009-04-07
2,707 reads
