A short demo on how to split strings with delimiters into columns.
Author: Tomas Lind
Tomas Lind - Consulting services as SQL Server DBA and Database Developer at High Coast Database Solutions AB.
How to align columns in Notepad++
Here’s a short tip on how to align columns (separated by comma or other character) for … How to align columns in Notepad++Read more
Swedish Standard Industrial Classification (SNI koder)
This short blog post is mostly targeted to my Swedish visitors. I have created a downloadable … Swedish Standard Industrial Classification (SNI koder)Read more
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