Category: General

• T-SQL Tuesday #25 – SQL Server Tips & Tricks

  

  2011-12-13 - General, T-SQL Tuesday

  T-SQL Tuesday #25 is hosted by Allen White (blog). This month’s topic is “SQL Server Tips and Tricks”. Transaction Log Reuse Wait One question that keeps coming up in forums, at user group meetings and on twitter is: Why is [more…]

• SQL 2012 RC0 is available for download

  

  2011-11-19 - General

  The SQL Server 2012 Release Candidate 0 is now available for download! If you have not started looking at the next version of SQL Server, now is the time to do so. If you are upgrading from CTP3, check out [more…]

• T-SQL Tuesday #24 – Prox ‘n’ Funx

  

  2011-11-08 - General, T-SQL Tuesday

  Performance Comparisons of different types of Functions

  A lot has been written about the performanmce impact of functions.
  Amongst other effects, functions used in a WHERE clause will prevent the use of an index seek for the columns involved.

  Sometimes however it makes sense to use functions to encapsulate a complicated calculation or to make code reuse possible.
  It is therefore important that to understand just how big the impact is, that functions have on queries.

  I would like to use this blog post to look at the call overhead of different kinds of functions in SQL Server.

  [more…]

• Missing Graphical Showplan

  

  2011-11-03 - General

  There are a few queries agains the DMVs that return execution plans in XML format. This is an example that lists the 10 the execution plans currently in cache that take up the most memory: [sql] SELECT TOP ( 10 [more…]

• T-SQL Tuesday #22 – Data Presentation – XML Concatenation

  

  2011-09-13 - General, T-SQL Tuesday, XML

  It is T-SQL Tuesday again, the 22nd incarnation and this time the topic is the presentation of data, hosted by Robert Pearl (Blog|Twitter). Every so often you run into the problem of having to display a list of items to [more…]