Sat.Jan 11, 2020

Using SQLBCP Native/Format File vs Text File and the BOM

SQL Server According to Bob

Using SQLBCP Native/Format File vs Text File and the BOM SQL Server Bulk Copy operations (BCP.exe, OpenRowset BULK, …) have specific abilities depending on the data file format specified. Native (-n) or Format (-f) Files The data file storage is binary allowing character strings to be stored as single or multi-byte strings on a per column definition.

SQL Server I/O Basics Chapter #1

SQL Server According to Bob

Microsoft SQL Server I/O Basics Author: ​​ Bob Dorr, Microsoft SQL Server Escalation Published: ​​ December, 2004 SUMMARY: ​​ Learn the I/O requirements for Microsoft SQL Server database file operations. This will help you increase system performance and avoid I/O environment errors. Copyright The information contained in this document represents the current view of Microsoft Corporation on the issues discussed as of the date of publication.

Cache 40

This site is protected by reCAPTCHA and the Google Privacy Policy and Terms of Service apply.

SQL Server I/O Basics Chapter #2

SQL Server According to Bob

Using SQL Server’s SNITrace to Troubleshoot Networking Issues

SQL Server According to Bob

Using SQL Server’s SNITrace to Troubleshoot Networking Issues In the process of tracking down a few TCP 10054 issues (highlighted here: ​​ [link] ) I ​​ also ​​ used ​​ the ​​ SNITrace ​​ (SNI Trace) ​​ capabilities.