Month: June 2016

Just Misc

–clear wait stat DBCC SQLPERF(“sys.dm_os_wait_stats”,CLEAR) –To setup the template –You will have to change your username XCopy “\\serverName\e$\SQL_Template\*.*” “C:\Users\loginname\AppData\Roaming\Microsoft\SQL Server Management Studio\11.0\Templates\Sql\” /E /Y –root block SELECT p.sid ,convert(char(12), d.name) db_name , program_name , convert(char(12), l.name) login_name , convert(char(20), hostname)

SQL Server 2012 Diagnostic Information Queries — Glenn Berry (copied)

— Copied from http://sqlskills.com/blogs/glenn/ — SQL Server 2012 Diagnostic Information Queries — Glenn Berry — June 2016 — Last Modified: June 8, 2016 — http://sqlserverperformance.wordpress.com/ — http://sqlskills.com/blogs/glenn/ — Twitter: GlennAlanBerry — Please listen to my Pluralsight courses — http://www.pluralsight.com/author/glenn-berry —

Top