Tag: asp

Pro Members SQL Server Standard Members

Some tips for using ASP.NET with SQL Server 2017

by

Some tips for using ASP.NET with SQL Server 2017 If you use ADO to access SQL Server data in your ASP.NET, always create a Connection object explicitly, not implicitly. This can reduce the server overhead and simplify the controlling of a connection. Set the MultipleActiveResultSets (MARS) option in the SQL Server connection string. This option makes it possible to execute...

This content is for Pro, Pro Member, Pro Member Annual - Fall Sale, Pro Member Monthly - Fall Sale, Standard, Standard Member, Standard Member Annual - Fall Sale, and Standard Member Monthly - Fall Sale members only.
Register
Already a member? Log in here
Continue Reading →
Pro Members SQL Server Standard Members

Some tips for using ASP.NET with SQL Server 2014

by

Some tips for using ASP.NET with SQL Server 2014 If you use ADO to access SQL Server data in your ASP.NET, avoid creating transactions using ADO methods. Try to create transactions inside a stored procedure on the SQL Server. By doing so, you can reduce network traffic and boost overall ASP.NET performance. When building a web page based on SQL...

This content is for Pro, Pro Member, Pro Member Annual - Fall Sale, Pro Member Monthly - Fall Sale, Standard, Standard Member, Standard Member Annual - Fall Sale, and Standard Member Monthly - Fall Sale members only.
Register
Already a member? Log in here
Continue Reading →