Category: SQL Server Internals

• The Performance Impact of Forwarded Records on Table Scans

  

  2012-01-31 - General, Performance, SQL Server Internals

  Forwarded records are a mechanism that SQL Server employs to reduce the amount of maintenance work for indexes on a table without a clustered index. During an update of a record in a table that does not have a clustered [more…]

• Connections to a Database

  

  2011-09-05 - General, SQL Server Internals

  Sometimes you need to know who is currently connected to specific database. While certainly not the only reason, the need for this information arises most often after receiving an error message like this one: Msg 3702, Level 16, State 3, [more…]

• Identity Crisis

  

  2011-08-27 - General, SQL Server Internals

  I wanted to write about this one for a while now but never got around to it. Today I came across a Connect issue that reminded me of this topic again. If you have bee around SQL Server for a [more…]