Some Important Tips For SQL Query Performance

1. Always use SET NOCOUNT ON and SET NOCOUNT OFF inside a Stored Procedure. It will then not print how many records are being affected by the execution of the Stored Procedure. CREATE PROCEDURE [dbo].[usp_AllEmployee] AS SET NOCOUNT ON ———————- ———————- ———————- SET NOCOUNT OFF 2. Always use the WITH(NOLOCK) option while writing a SELECT query. Using …

ASP.NET Hosting Tips: How to Started Your First ASP.NET Web Application ?

ASP.NET is Microsoft’s free cross-platform framework for building web apps and services. The ASP.NET platform is an extension to .NET, a developer platform of tools, programming languages, and libraries used to build different applications. As you have probably guessed, ASP.NET is a fantastic framework beginners can use to build web apps. It offers a lot …