SELECT sder.session_id AS [SPID], sdes.login_name AS [Login], sd.name AS [DBName], sder.start_time AS [Start Time], sder.status AS [Status], sder.command AS [Command], sdet.text AS [SQL Text], sder.percent_complete AS [Pct Cmplt], sder.estimated_completion_time AS [Est Cmplt Time], sder.wait_type AS [Wait], sder.wait_time AS [Wait Time], sder.last_wait_type AS [Last Wait], sder.cpu_time AS [CPU Time], sder.total_elapsed_time AS [Total Elpsd Time], sder.reads AS [...]
A colleague of mine Aaron Erickson has an interesting post on how deep testing should go here. This brings up some interesting points, for example in SQL Server I might test my own function, however I don’t test SQL Functions like GETDATE, instead I assume they work properly. If I bring in CLR functions, the [...]
Often when dealing with different filegroups or even different files in SQL Server 2005, I end up wanting to know where certain objects are logically and physically located. Here’s a query that will give that information: select ‘Object Name’ = so.name, ‘Index Name’ = si.name, ‘Type Description’ = si.type_desc, ‘FileGroup Name’ = sfg.Name, ‘System FileName’ [...]