Vipul Shah's SQL Blogs

SQL Server Blogs

May, 2007

  • /3GB /PAE and AWE on 32-bit Systems

    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...
  • Data Scripter Utility for SSMS

    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...
  • "Transparent" Benefits of SQL Server 2005

    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 ...