Showing posts with the label sql server

SQL Server - Aggregate Functions

Aggregate functions will find out a calculation process on a collection of values and return a re…

Stored Procedure best practices

A stored procedure is a named and precompiled set of SQL statements and procedural logic that is …

Database Security :

Designing Instance-level Security A]. Configuring Service Account : (1) In SQL Server 2005, when…

Cache object in ASP.NET designs

An effective caching strategy is a key element of any application design. It increases performance…

That is All