Microsoft SQL Server

Below is a collection of Microsoft SQL Server Scripts   Find Orphaned User Accounts: select    dp.name [user_name]    ,dp.type_desc [user_type]    ,isnull(sp.name,'Orhphaned!') [login_name]  ... Read More

SELECT       percent_complete ,       start_time ,   ... Read More

HOW MANY CPU's ARE ONLINE FOR SQL: select scheduler_id, cpu_id, status, is_onlinefrom sys .dm_os_schedulerswhere status = 'VISIBLE ONLINE'   HOW MANY CPU's DOES SQL SEE: select cpu_count from sys. dm_os_sys_info Read More

New query: Select @@version Read More

This Can Be Used To Determine All Current Tasks SELECT                ... Read More

Used to determine the amount of memory be used by all DataBases   SELECT DB_NAME(database_id) AS [Database Name], COUNT(*) * 8/1024.0 AS [Cached Size (MB)] FROM sys.dm_os_buffer_descriptors --WHERE database_id > 4 -- system databases -... Read More

Use below script to determine the Top 5 waiting tasks and sorted by percent of use in the top 5     WITH [Waits] AS         Â... Read More