Browse by Tags

• alter
• blocking
• databases
• deletes
• indexes
• insert
• locks
• trustworthy
• tsql

TSQL to findout blocking and locks on a SQL Server?
07 December 07 12:08 PM | SQL Master | 2 Comments   

Have you ever performed huge operations such as deleting records of a table and processing inserts on that table at the same time? This is a common task that every application will have to perform and you can avoid by fine tuning your queries (mostly Read More...

Filed under: tsql, sql server, performance, indexes, security, blocking, locks, deletes, insert

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