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

Goal Progress–Feb 2021

By

I set goals at the beginning of the year, and I’m tracking my progress...

How to: exec sp_help on temp tables?

By

Say you have a temp table and you want to see the columns names. For...

Daily Coping 26 Feb 2021

By

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

Read the latest Blogs

Forums

MSDTC and Always On AG

By VastSQL

Hi Experts, We are planning to implement 2 Node AO SQL Server 2019. For...

Remove Carriage Returns / Line Breaks / Any other reason the "text" moves down

By DCL

I know this has been covered ad nauseum all over the internet for years....

Better query to get count based on column value

By IT researcher

I am using SQL server 2008 R2 express edition. Out of below 3 method...

Visit the forum

Ask SSC

SQL Server Q&A from the SQLServerCentral community

Get answers