Mark Chaffin

Mark Chaffin is Data Warehouse Architect for Encore Development (http://www.encoredev.com) and has developed numerous decision support systems for clients in such industries as technology, mortgage banking, retail, financial services and insurance. He also has experience in clickstream analytics, data mining, transactional application architecture, Internet application architecture, database administration and database design. He has completed a book about Data Transformation Services with Brian Knight (http://www.sqlservercentral.com/columnists/bknight).

Blogs

A Very Cool Benefit in SSMS 21

By

I saw a post from Erin that Preview 2 is available. I’d gotten a...

AI Helping with an API

By

Can an AI help me with some database API work? Let’s see. This is...

Creating a “Real” Copy of a View: #SQLNewBlogger

By

I saw a post where a developer was trying to read the Information Schema...

Read the latest Blogs

Forums

Topic marked as spam - by mistake?

By Phil Parkin

I received the following notification a few hours ago. It seems legit but has...

Getting blockage on Update Statement

By anshu.shikha

Hi, Need your help. I've a SP that is using Update statement on a...

Query is filling Tempdb

By Nita Reddy

I have query which is filling TEMPDB I need suggestion how to modify this...

Visit the forum

Question of the Day

The Hash Join III

In a hash join, if all the build input does not fit in memory, what type of hash join is this?

See possible answers