Category: SQL Server 2012

• The sys.dm_db_database_page_allocations DMF

  

  2014-07-09 - General, Series, SQL Server 2012, SQL Server Internals, Storage Wednesday

  Are you looking for an alternative to DBCC IND? Read on to see how the new sys.dm_db_database_page_allocations DMF can be used to return all pages for a particular table (or even all tables in a database).

  [more…]

• Comparing System Objects between SQL Server 2012 and SQL Server 2008R2

  

  2012-07-21 - General, SQL Server 2012

  This post shows a way to compare the system objects between a SQL Server 2008R2 and a SQL Server 2012 instance.

  [more…]