Jay's notes on SQL

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

February, 2011

  • Jay's notes on SQL

    Required rights for SQL Server service account

    • 1 Comments
    This topic comes up from time to time in my daily support work, so I thought I would make a quick post on the rights required if you do not want the SQL Server service account to be a member of the Local Administrators group on Windows.   Having...
  • Jay's notes on SQL

    Uninstalling a SQL Server Service Pack

    • 2 Comments
    Did you know that starting with service packs (Service Pack 1) in SQL Server 2008 you can uninstall them from Add/Remove Programs like any other update? But as always, backup both your user and system databases before applying any update, hot fix, cumulative...
  • Jay's notes on SQL

    Finding which queries were executing from a SQL Memory Dump – revisited

    • 4 Comments
    A message about the previous post on finding queries in a SQL Memory Dump file: Back in October I did a post on finding queries in SQL Server Memory Dumps.  It has been a popular topic, but some have had difficulties following it.  After reviewing...
  • Jay's notes on SQL

    Using DBCC PAGE

    • 0 Comments
    DBCC PAGE is an undocumented – and unsupported – DBCC statement in SQL Server for dumping the raw contents of a single database page.   It will return all the metadata stored in the page, and with the right detail level parameter – return the...
Page 1 of 1 (4 items)