|
Understanding and Optimizing ADO.Net 2.0's SQL
Level:
Intermediate
Track:
n/a
Starts:
Sep 29 2007 1:15 PM
Ends:
Sep 29 2007 2:45 PM
Room:
EBC
Speaker:
Andrew Novick
When programmers use ADO.Net 2.0 they're choosing to have ADO.Net write the SQL that interacts with their database. This presentation shows how to understand the SQL that ADO.Net writes and optimize the SQL for performance.
The SQL Profiler is a key tool for gaining insight into what ADO.Net 2.0 is doing on your behalf and we'll learn how to use it and some key events that are most useful.
Inserts can be performed in various ways using ADO.Net 2.0. We'll show everything from the slowest way: unbatched, one-by-one INSERT statements to the fastest ways: Server based statements and SQLBulkCopy.
One of the extreme optimizations that can be used for insert, update, and delete operations is a switch to SQL BulkCopy operations from standard T-SQL INSERT, UPDATE, and DELETE. The difference in improvement in performance can be dramatic. The presentation will show you how.
|