Cumulative sum of previous rows

I had an update statement that took 3 minutes to run after this code change it took 6 seconds.

Recompile in a stored procedure?

Selecting from sub-queries as tables

Using sub-queries as tables only requires an alias

Never give up

When facing a problem you aren't sure you can solve, keep working on it and believe in yourself.

Why Primary Keys can be important on large tables

I inherited a database that was getting large and not performing well. After adding primary keys life got better.

The Last Line of Defense

How do you deal with being the last line of defense at your company?

Try to focus on the positive

When we focus on negative things we get more negative. Be thankful for something positive.

What is your default database set to?

Some people set their default database to the database they use most often. This can cause issues when a restore fails.

What will the max id be?

A simple math expression solver

Ben Kubicek wrote a recursive function that solves simple math expressions in a select statement. Read about this creative use of T-SQL.