Stored procedures in SQL Server provide improved performance by reducing network traffic, enabling parameterised queries, enhancing security, and promoting code reusability.