Use Parameterized Queries Or Store Procedures
Parameterized queries are exactly the same as stored procedures in terms of performance and memory management. Since most ORM tools can use either stored pro...
Recent Posts
Index On Specific Columns
Performance is enhanced when indexes are placed on columns used in WHERE, JOIN, ORDER BY, GROUP, and TOP. Always test to ensure that the index does help perf...
The Definition Of Done
Code Logging Profile Test Review
Create Mandatory Updates For Clickonce Application
In this post, we will look at creating mandatory updates for ClickOnce Application.
Consider Creating Web Garden For Stateless Applications
By default each Application Pool runs with a Single Worker Process (W3Wp.exe). We can assign multiple Worker Processes With a Single Application Pool. An App...