The Tomes Of Experience

Wow lots has happened in the last 4 hours. Where do i start?

• In order to diagnose a locking/blocking issue on SQL server, start with an sp_who2 to give you the list of active PIDS, and the PIDS blocking requests. Then execute DBCC INPUTBUFFER(<BLOCKING PID>) to find the offending SQL
• In order to free space on a critical HDD, you can move the data over to a new location on the same machine and create a junction (a symoblic link for the *nix folk). New feature of NTFS 3.0 and IMO not used anywhere near as heavily as it should. Most underrated feature in Windows.
• It’s hard to come across a good music compilation, but by God someone has managed to do it

Related posts:

1. Recently Closed Tabs in Chrome A friend told me this one - I missed the...

Tuesday, July 22nd, 2008 at 1:05 pm.
Filed under IT & Software.
Subscribe to RSS 2.0.
Leave a comment or trackback.