Performance Questions

Hello, I have a couple questions.
1) Are there issues with tables where the row-size is so large, that insert
performance is degraded? For example, if the row-size exceeds some page
size, this may affect insert performance.
2) Are there issues with stored procedure performance based on the number of
parameters being passed to the stored procedure? We use a stored procedure
to insert data, and if we have a lot of columns in a table, we would be
passing the stored procedure a lot of parameters.
Comments Inline
Geoff N. Hiten
Microsoft SQL Server MVP
Senior Database Administrator
Careerbuilder.com
I support the Professional Association for SQL Server
www.sqlpass.org
"nupee" <nupee@.discussions.microsoft.com> wrote in message
news:679BF0F1-DD36-4E6F-804B-B47756CD4B83@.microsoft.com...
> Hello, I have a couple questions.
> 1) Are there issues with tables where the row-size is so large, that
insert
> performance is degraded? For example, if the row-size exceeds some page
> size, this may affect insert performance.
Row-size cannot exceed page-size, except for BLOB data which is stored away
from the main row-oriented data. Page splits are more likely with a large
row size and that may have a performance impact.

> 2) Are there issues with stored procedure performance based on the number
of
> parameters being passed to the stored procedure? We use a stored
procedure
> to insert data, and if we have a lot of columns in a table, we would be
> passing the stored procedure a lot of parameters.
I see that all the time with .NET clients 'under the covers'. I haven't
noticed any problems.

>
>