Jeff Moden

  • Interests: SQL. When Im not having fun with that, then SQL. ;-)

How to Make Scalar UDFs Run Faster (SQL Spackle)

It's a well known fact that Scalar UDFs are the stuff of performance nightmares in T-SQL. But are they really as bad as they say? SQL Server MVP Jeff Moden shows us that they might not really be as big a problem as you might think and what you can do when they actually are.

4.93 (102)

2014-06-24 (first published: )

23,864 reads

Skipping Columns (& other tricks) Using BCP Format Files (SQL Spackle)

BULK INSERT and BCP are powerful, high performance tools for importing text files. SQL Server MVP Jeff Moden gives us several nifty tips in this introduction to BULK INSERT and BCP Format Files including "Skipping Columns" and the sequestration of bad rows while still loading all the good data.

4.78 (27)

2014-01-23

15,219 reads

Tally OH! An Improved SQL 8K “CSV Splitter” Function

The Tally Table has proven to be a simple and elegant method for avoiding many varieties of RBAR. Unfortunately, one of its more common uses, that of a CSV splitter, has a well-known and serious performance problem. MVP Jeff Moden shows us what that problem is and how to correct it. (UPDATED with additional info and attachments on 5/12/2011).

4.83 (187)

2012-12-28 (first published: )

108,030 reads

Blogs

Daily Coping 17 Sep 2021

By

I started to add a daily coping tip to the SQLServerCentral newsletter and to...

Ethics in Modern Data at Music City Tech 2021

By

  On Sept 16, Christine and I presented our joint presentation on Ethics in Modern Data at...

Slides and Video from Building a Regret-free Foundation for your Data Factory Now Available

By

Last week, Kerry and I delivered a webinar with tips on how to set...

Read the latest Blogs

Forums

SQL Agent job

By Chitown

Can I run extended event session against 1 SQL agent job? I have a...

Need some help with tsql code

By Chitown

I have 4 tables (DevDB, TestDB, StageDB, ProdDB). All those tables have 2 columns...

Save Blob Storage Key in Package

By alex.sqldba

Hi Guys, Is there a way to save the Blob Storage Key into a...

Visit the forum

Ask SSC

SQL Server Q&A from the SQLServerCentral community

Get answers