Identity columns are widely used as primary key columns in SQL Server tables. They can be … Identity columns that are about to overflowRead more
Tips & Tricks
Toggl Time entries to SQL Server
Toggl is a very simple to use cloud based time tracking application. Time entries on projects … Toggl Time entries to SQL ServerRead more
Split strings to columns
A short demo on how to split strings with delimiters into columns.
Send email when log or data file grows
One way to keep track of your data- and log file sizes in SQL Server, is … Send email when log or data file growsRead more
sys.dm_exec_cached_plans
The dynamic management view sys.dm_exec_cached_plans returns information on query plans currently in memory. This information can … sys.dm_exec_cached_plansRead more
How to fill in gaps in time series
In some cases it is necessary to have an unbroken time series, for instance to have … How to fill in gaps in time seriesRead more
Calculating Earned Premium in SQL Server
In most business, when a company receives payment for a sold product, that payment can be … Calculating Earned Premium in SQL ServerRead more
Sending HTML tables in mail from SQL Server
This post contains a template for sending HTML tables via mail in T-SQL. A prerequisite is … Sending HTML tables in mail from SQL ServerRead more
Mass editing of SQL Server objects
Ever had the need to replace a piece of code in multiple SQL Server objects (Stored … Mass editing of SQL Server objectsRead more
Max or min value from a set of columns
The min and max aggregates in SQL Server are normally used to work over rows, getting … Max or min value from a set of columnsRead more