SQL Server Architecture

Technical Article

RE: Do you think DBA is a desirable job?

  • Reply

quote: interesting, we have some similar wording in german. I know, used to live in Wien, but 'mien Deutsch ist sehr schlekt'. As is clearly demonstrated by my awful spelling, grammar Laters *I didn't do anything it just got complicated*


1 reads

Technical Article

RE: Replacing BCP with SQLBulkLoad

  • Reply

quote: I think the BULK INSERT statement is a good substitute to bcp. From a performance perspective, it should be slightly faster. BULK INSERT runs in the memory context of SQL Server whereas bcp does not. Both of these would be faster than DTS and the described method here. K. Brian Kelley http://www.truthsolutions.com/ Author: Start […]



Hyperconverged storage tuning tip for SQL Server


We all (should) know that running SQL Server in hyperconverged virtual environments, both on-premises...

Daily Coping 25 Nov 2022


Today’s coping tip is to connect with someone from a different generation. This tip...

Snowflake Classic UI vs Snowsight


This blog post is not about which User Interface is better, Classic or Snowsight...

Read the latest Blogs


Restore takes forever

By Edvard Korsbæk

Hi all! I have som pretty smal databases - the backup is app. 250...

DML Trigger Limits

By Steve Jones - SSC Editor

Comments posted to this topic are about the item DML Trigger Limits

A week in Seattle in 8 Slides at the PASS Data community Summit 2022

By Tonie Huizer

Comments posted to this topic are about the item A week in Seattle in...

Visit the forum

Ask SSC Logo Ask SSC

SQL Server Q&A from the SQLServerCentral community

Get answers