All About SQL Server Stored Procedures: Data Types

In this video, I delve into the often-overlooked yet crucial aspect of data types in SQL Server stored procedures-specifically focusing on how mismatching data types can lead to performance issues and other unexpected behaviors. Whether it's dealing with date/time conversions or understanding the nuances between different string data types like 'varchar', 'char', and 'nchar', I share insights from real-world scenarios and common mistakes that many developers face, often without realizing their impact until it's too late. By exploring these pitfalls, I aim to help you avoid potential headaches down the line and ensure your stored procedures operate as efficiently as possible. CHAPTERS 00:00:00 - Introduction 00:01:29 - Index Creation 00:04:28 - Common Screw-ups 00:06:32 - Links in Description 00:07:04 - DateTime Parameter 00:08:34 - Data Types Concerns 00:10:04 - ORM Data Typing 00:12:04 - Variable Length Strings 00:14:03 - Table-Valued Parameters 00:16:15 - String Splitting 00:18:03 - Predicate Pushdown 00:20:04 - Performance Difference 00:21:28 - Indexing Considerations 00:22:17 - Max Data Types ━━━━━━━━━━━━━━━━━━━━━━━━━━ 📚 TRAINING & COURSES ━━━━━━━━━━━━━━━━━━━━━━━━━━ Get AI-Ready With Erik https://training.erikdarling.com/get-ai-ready-with-erik?coupon=AIREADY SQL Server Performance Engineering Course https://training.erikdarling.com/sql-server-performance-engineering?coupon=ENGINEERING Learn T-SQL with Erik https://training.erikdarling.com/learn-t-sql-with-erik?coupon=ADVANCEDTSQL Everything Bundle: https://training.erikdarling.com/?coupon=SPRINGCLEANING ━━━━━━━━━━━━━━━━━━━━━━━━━━ 🛠️ CONSULTING & SERVICES ━━━━━━━━━━━━━━━━━━━━━━━━━━ Need SQL Server performance help? https://training.erikdarling.com/sqlconsulting ━━━━━━━━━━━━━━━━━━━━━━━━━━ 💬 CONNECT ━━━━━━━━━━━━━━━━━━━━━━━━━━ Ask questions at Office Hours https://erikdarling.com/officehours/ Become a channel member https://www.youtube.com/@ErikDarlingData/join ━━━━━━━━━━━━━━━━━━━━━━━━━━