Jay's notes on SQL

[coding, debugging, and troubleshooting SQL Server 2K#]

January, 2011

  • Jay's notes on SQL

    How does SQL Server perform deletes in my table?

    • 4 Comments
    In this post we’ll look at how SQL Server deletes records in a table.  In this example, we’ll be using a clustered index.  For performance, SQL Server does not actually delete a row of data when requested by a transaction.  By not incurring...
  • Jay's notes on SQL

    Why do we need trace flag 3604 for DBCC statements?

    • 0 Comments
    For many DBCC statements, we need to enable trace flag 3604 before executing the DBCC command.  This is done via: DBCC TRACEON(3604) GO But why do we need this?  Some DBCC commands are designed to send the output to the log, attached debugger...
  • Jay's notes on SQL

    What is a slot array?

    • 0 Comments
    What is a slot array?  Though it sounds like a line of gambling machines at the nearest casino, the slot array in SQL Server serves a crucial role in record management on a page.  A database page (and all other page types) in SQL Server is 8KB...
Page 1 of 1 (3 items)