SQL Server According to Bob

JANUARY 11, 2020

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. SNITrace, formally BIDTrace, is an ​​ deeper ​​ level of tracing for the ​​ Microsoft SQL Server ​​ TDS ​​ consumer

Network 40

Network Servers Processing Software Engineering 40

SQL Server According to Bob

JANUARY 11, 2020

Microsoft SQL Server I/O Basics: Chapter 2 Microsoft SQL Server I/O Basics ​​ Chapter 2 SQL Server 200 0 ​​ SP4 and SQL Server 2005 Author: ​​ Bob Dorr ​​ (SQL Server ​​ Senior ​​ Escalation ​​ Engineer) Reviewers:   Mike Zwilling ​​ (SQL Server Development Manager) Paul Randal ​​ (SQL Server Lead Program Manager) Mirek Sztajno ​​ (SQL Server Program M

Servers 40

Servers Cache Database Media 40

SQL Server According to Bob

JANUARY 11, 2020

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.

Servers 40

Servers Cache Media Hardware 40

SQL Server According to Bob

JANUARY 11, 2020

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.

C++ 40

C++ Storage Servers Retail 40