Browse by Tags

• alter
• long
• query
• running
• security
• trustworthy
• tsql

TSQL to detect long running queries against the database
29 August 07 04:37 AM | SQL Master | 3 Comments   

When I'm performing a performance analysis on a 24/7 application and dealing with PSS I had been given the following TSQL to identify the long running queries against a database. select r.session_id, s.host_name, s.program_name, s.host_process_id, r.status, Read More...

Filed under: tsql, sql server, performance, databases, query, running, long

SET TRUSTWORTHY ON when using SP_CONFIGURE
17 July 07 02:09 AM | SQL Master | 1 Comments   

SET TRUSTWORTHY ON, from the name itself it sounds like you are not allowing anything that cannot be trusted. SQL Server 2005 has introduced a new database property called TRUSTWORTHY that is used to indicate whether the instance of SQL Server trusts Read More...

Filed under: sql server, performance, alter, security, trustworthy, databases