Find out how long the sql server service has been running, from t-sql

sql-server, sql-server-2005

Solution

SELECT
    login_time
FROM
    sys.dm_exec_sessions
WHERE
    session_id = 1

will give you a `datetime` for when the server was started.

Problem

I'd like if its possible to work out from inside sql server how long sql server has been running. Would like to use this in conjunction with one of the DMV's for unused indexes, but the counters are re-set every time sql server loads, so I'd like to know how useful they're going to be.

Original source