Recently I had to create a simple query to lookup a single row in a table containing ranges that do not overlap. Consider this table design and example data:

CREATE TABLE MyRanges (
    id         INT IDENTITY(1,1) PRIMARY KEY,
    RangeFrom  INT NOT NULL,
    RangeTo    INT…

Read more

My colleagues and I often joke around with “If it takes less than a second, then it’s okay!”. The reason for that is, that it is actually quite often we encounter pieces of t-sql code that does not perform good enough for what it will be used for when it…

Read more

A few weeks back we wrote about a query to tell you which database is using up most CPU time. A natual follow up question is: Which queries are using all my CPU? I have modified the query a bit so we now get a row per execution plan instead… Read more

All developers know, that it is very important to encapsulate code in classes and methods to be able to reuse bits and pieces for other purposes than they were originally made for. The same goes for t-sql development, by using stored procedures and functions. But often you need to slightly… Read more