Sometimes we needs to find out the last executed commands on the database server.
Below is the SQL script share by one of my friend Ken Watson to find out the last executed queries.
Below is the SQL script share by one of my friend Ken Watson to find out the last executed queries.
SELECT usecounts, cacheobjtype, objtype, text
FROM sys.dm_exec_cached_plans
CROSS APPLY sys.dm_exec_sql_text(plan_handle)
WHERE usecounts > 1
ORDER BY usecounts DESC;
About Ken
He is working as SQL DBA.
Blog:- interflextech.com/blog
Twitter:- @interflextech
Nice Article !
Really this will help to people of SQL Server Community.
I have also prepared small note on this, Script to find last executed query in SQL Server.
http://www.dbrnd.com/2015/11/sql-server-script-to-find-the-last-executed-query-using-spid/
Pingback: CD Printer in Lagos Nigeria
Pingback: gazebo
Pingback: Marketing Consultant
Pingback: Dentist in Weslaco Texas 956-969-2960
Pingback: polished concrete floor cost
Pingback: Whatsapp Marketing Pro (Instant download link)
Pingback: Istanaimpian2
Pingback: Welding Equipment
Pingback: New York Realtor
Pingback: บาคาร่า
Pingback: Sexual Function
Pingback: Pflegematratze kaufen
Pingback: https://www.wasseem.org/
Pingback: Casa em Orlando
Pingback: Online Casino
Pingback: didi promotion code
Pingback: Small business website designs and marketing
Pingback: xembongda tructiep
Pingback: decals for road cases
Pingback: weight loss tracker
Pingback: https://soundproofingcontractorsusa.info/usa/soundproofing/la
Pingback: The Fylls (GoFundMe)
Pingback: 바카라
Pingback: Massage Danmark
Pingback: social impact marketing
Pingback: Dream Market
Pingback: Tochka Market
Pingback: mansion88
Pingback: ebenin amini türkce dublaj izle