IT & Digital Marketing Articles | Marathon Consulting

About
Blog

Filtering posts by tag: SQL

Using Temp Tables to Speed Up Large Queries in SQL Server

January 24, 2024 Laura Moss 6 minute read

An easy method for speeding up queries against large tables is by using temporary tables. Here's a quick demo on using temp tables to optimize your returns.

SQL SQL Server

Importing Data to SQL the Hard Way

February 20, 2023 Laura Moss 5 minute read

Importing data from Excel into SQL Server without a bulk import option can be a challenge. Here's how data expert Laura Moss solved this by using Excel to generate T-SQL.

Excel SQL

.jsonly { display: none }