Ekinlikler
31 Mar 23 - 2 Nis 23
En büyük SQL, Fabric ve Power BI öğrenme etkinliği. 31 Mart – 2 Nisan. 400 ABD doları tasarruf etmek için FABINSIDER kodunu kullanın.
Bugün kaydolunBu tarayıcı artık desteklenmiyor.
En son özelliklerden, güvenlik güncelleştirmelerinden ve teknik destekten faydalanmak için Microsoft Edge’e yükseltin.
One aspect of application development that is common to all applications is the constant need to improve performance and reliability. There are many techniques to satisfy this need with the Microsoft JDBC Driver for SQL Server.
The articles in this section describe various techniques for improving application performance and reliability when using the JDBC driver.
Article | Description |
---|---|
Understanding timeout properties | Describes the timeouts used by the JDBC driver. |
Closing objects when not in use | Describes the importance of closing JDBC driver objects when they're no longer needed. |
Managing transaction size | Describes techniques for improving transaction performance. |
Working with statements and result sets | Describes techniques for improving performance when using the Statement or ResultSet objects. |
Using adaptive buffering | Describes an adaptive buffering feature, which is designed to retrieve any kind of large-value data without the overhead of server cursors. |
Sparse columns | Discusses the JDBC driver's support for SQL Server sparse columns. |
Prepared statement metadata caching for the JDBC driver | Discusses the techniques for improving performance with prepared statement queries. |
Using bulk copy API for batch insert operation | Describes how to enable Bulk Copy API for batch insert operations and its benefits. |
Not sending String parameters as Unicode | When working with CHAR, VARCHAR, and LONGVARCHAR data, users can set the connection property sendStringParametersAsUnicode to false for optimal performance gain. |
Ekinlikler
31 Mar 23 - 2 Nis 23
En büyük SQL, Fabric ve Power BI öğrenme etkinliği. 31 Mart – 2 Nisan. 400 ABD doları tasarruf etmek için FABINSIDER kodunu kullanın.
Bugün kaydolunEğitim
Sertifikasyon
Microsoft Sertifikalı: Azure Veritabanı Yöneticisi Uzmanlık - Certifications
Microsoft PaaS ilişkisel veritabanı tekliflerini kullanarak bulut, şirket içi ve karma ilişkisel veritabanları için SQL Server veritabanı altyapısını yönetme.
Belgeler
Using adaptive buffering - JDBC Driver for SQL Server
Learn how using adaptive buffering eliminates the overhead of server cursors when retrieving large-value data using the Microsoft JDBC Driver for SQL Server.
Closing objects when not in use - JDBC Driver for SQL Server
In JDBC programming, it's important to close objects when the aren't in use. Closing improves performance and frees up client and server resources quickly.
Prepared statement metadata caching - JDBC Driver for SQL Server
Learn how the JDBC Driver for SQL Server caches prepared statements to improve performance by minimizing calls to the database and how you can control its behavior.