Join Joey D'Antoni for an in-depth discussion in this video What datatype conversions do to your query performance, part of SQL Server Performance for Developers.
- [Instructor] The most important part about data types…and performance is making sure you avoid conversions.…And what do we mean by conversions?…This is where the parameter maybe…that your application is supplying…to the database and whether it's its where clause…or how you're creating dynamic sequel…or what you're passing to a stored procedure,…does not match what's actually in the database…and this can be a number of ways.…It can be passing in a number that's actually stored…as a text field.…It can be passing in a date that's not stored…as a date or not using date type on the .NET side.…
And when this happens, SQL Server has to do…what's known as an implicit conversion.…And what exactly do we mean by data type conversions?…When your application data or when data…that's passed into a query just does not match…what's in the table SQL Server will either…on its own or by you helping it with a command…like cast or convert…will change the data type to match what's in the table…so you can actually match that data.…
- Query execution
- How to read an execution plan
- What not to do with SQL Server
- Why cursors are bad
- Why scalar UDFs are expensive
- Datatypes and design
- What is a columnstore index?
- Transaction isolation
Skill Level Intermediate
1. Query Execution
2. What Not to Do with SQL Server
3. Datatypes and Design
4. Temporary Objects
7. Isolation Levels
Next steps2m 15s
- Mark as unwatched
- Mark all as unwatched
Are you sure you want to mark all the videos in this course as unwatched?
This will not affect your course history, your reports, or your certificates of completion for this course.Cancel
Take notes with your new membership!
Type in the entry box, then click Enter to save your note.
1:30Press on any video thumbnail to jump immediately to the timecode shown.
Notes are saved with you account but can also be exported as plain text, MS Word, PDF, Google Doc, or Evernote.