Articles

SQLServerCentral Article

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.79 (28)

You rated this post out of 5. Change rating

2024-11-22 (first published: )

23,427 reads

External Article

Transactions

By now, pretty much everyone has heard the stories about the first computers. They were huge, cost a fortune, required incredible amounts of air conditioning, and perhaps more importantly, ran batch jobs submitted on punched cards and magnetic tape. But even before we had these dinosaurs, there were E.A.M (electric accounting machine) units.

2024-11-22

SQLServerCentral Article

SQL Server 2022 Build List

This is a list of the builds for SQL Server 2022. There are other build lists available here. A list of all the builds that I can find and install on my Build VM. If you find a build not listed here, please let the webmaster know (webmaster at sqlservercentral.com). All builds are listed in reverse […]

You rated this post out of 5. Change rating

2024-11-15 (first published: )

3,265 reads

Blogs

Learning Database Design and Power BI Performance

By

I spend my days working on and managing SQL Server instances—working days at least,...

Free SQL Training: Dive into Databases This December!

By

Want to learn SQL and get some real practice this December? Check out the...

Monday Monitor Tips: CIS Compliant

By

A new feature added to Redgate Monitor Enterprise automatically. CIS compliance is something many...

Read the latest Blogs

Forums

Merry Christmas 2025

By Steve Jones - SSC Editor

Comments posted to this topic are about the item Merry Christmas 2025

The Reindeer Count

By Steve Jones - SSC Editor

Comments posted to this topic are about the item The Reindeer Count

Events of System_health extended event serious or not

By IT researcher

I have listed the event names present in my system_health extended event report. Based...

Visit the forum

Question of the Day

The Reindeer Count

How many reindeer does Santa have pulling his sleigh? (according to the famous song) Hint, the answers are not base 10.

See possible answers