Server Uptime

-- Get start time from SQL Server 2008
SELECT sqlserver_start_time
FROM sys.dm_os_sys_info;

SELECT create_date  AS StartTime
FROM sys.databases
WHERE name = 'tempdb';