Category: General

• The Logic Problem in the EndOfMonth function

  

  2012-03-04 - General, TDD, tSQLt

  Test case heuristics can help picking the right test cases for the logic you are developing. This article is a brief introduction into that field, extending on the example of the EndOfMonth function. [more…]

• Why CXPACKET Waits are not your Performance Problem

  

  2012-02-28 - General, Performance, SQL Server Internals

  There is a lot of information out there recommending to do this or that to deal with the performance problems that you must have if you see CXPACKET waits. All these recommendations build on the notion that the CXPACKET wait is [more…]

• Deferred Deallocations of Pages in TempDb

  

  2012-02-19 - General, SQL Server Internals, TempDb

  The other day I ran into a question on msdn:Tempdb Deallocation (dm_db_session_space_usage). A person with the pseudonym DontPageMeBro noticed an odd behavior in his SQL Server installation: The sum of the reported usage of tempdb across all sessions was often [more…]

• Purge Problems [TSQL Tuesday #027 – The Big Data Valentine’s Edition]

  

  2012-02-14 - General, Performance, T-SQL Tuesday

  T-SQL Tuesday #27 is hosted by Steve Jones (blog|twitter). This month’s topic is “Big Data”. Purge Problems in Big Data – Not only a SELECT needs an index Recently I was called to an issue at a 5+ TB customer. [more…]

• Purging a Table based on a Fixed Number of Rows to Keep

  

  2012-02-07 - Archiving and Purging, General, Performance

  Purging old data out of the database usually is driven by a date. If the business does not need records that are older than a Year, and if your records have a date column, you can purge by deleting all [more…]