On BNET: How to play hooky more effectively
1 Resources for

sp_lockdetail example

  • Subscribe to this listing via:
  • RSS
  • Email

TechRepublic Resources

Write your own sp_lock system stored procedure in SQL Server 2005
The sp_lock system stored procedure is a great tool for checking the amount of locking that occurs on your database system. It returns the number and types of locks that are being held by current active SQL Server sessions. One of my previous articles describes how you can use sp_lock...
Tags: Procedure, Microsoft SQL Server, Statement, Information, Session, Microsoft SQL Server 2005, LEFT JOIN, Sql_handle, sp_LockDetail Example, Tim, Storage, Databases, Hardware, Enterprise Software, Software, Data Management, Tim Chapman
Blog posts 2008-01-07
  • << Previous
  • page 1 of 1
  • Next >>


Cisco IOS Command Chart (IOS v.12+)
Becoming proficient with Cisco equipment means remembering a whole new set of commands. These command charts give you a quick way to look up the needed IOS commands and switches when you need them.
Buy Now
Windows XP vs. Mac OS X
This presentation, entitled Standardizing on Windows XP Instead of MAC OS X, provides a pre-packaged option for defending Windows XP against MAC OS X. ...
Buy Now