This short blog post is mostly targeted to my Swedish visitors. I have created a downloadable … Swedish Standard Industrial Classification (SNI koder)Read more
Year: 2015
SSISDB.catalog.create_execution
The SSISDB Catalog was introduced in SQL Server 2014. With it came a lot of procedures … SSISDB.catalog.create_executionRead more
SQL Server recovery time
SQL Server Recovery time is the time it takes for SQL Server to rollback or roll-forward … SQL Server recovery timeRead more
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
Create XML with T-SQL function FOR XML
Some time ago I demonstrated how to use XQuery to map a hierarchical XML document into … Create XML with T-SQL function FOR XMLRead 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
Capturing Blocked Queries
In a previous post, I presented a solution for monitoring and logging long running queries in … Capturing Blocked QueriesRead more