I was reading a blog post from Chad Boyd - http://blogs.msdn.com/chadboyd/archive/2007/03/24/pae-and-3gb-and-awe-oh-my.aspx . He has very detailed and excellent information about /3GB PAE and AWE. It made my understanding more clear. Here is the summarized...

You can generate a script for a data within a table - whole bunch of insert statement. There is an external plug-in available at http://www.codeproject.com/useritems/enisey.asp . I downloaded it and installed it on my machine, it works great. After installing...

Did you know? In SQL Server 2005: DBCC - uses snapshot framework avoiding locks - no table level schema locks sys.dm_db_index_physical_stats replaces DBCC SHOWCONTIG - Both of these tools doesn't require S lock. It only require IS lock ...