C# Corner

Search
Sort By Search Results
  • SQL Query Performance - Functions and IndexesApr 02, 2015. In this article we will learn why functions should be avoided on indexed columns in where clauses of select statements.
  • T-SQL Query Performance Tuning TipsAug 09, 2013. In this article, I will discuss some useful T-SQL query performance tips and tricks for SQL server developers.
  • How to improve your LINQ query performance by 5 X times ?Jul 17, 2009. LINQ has been criticized by many early adopters for its performance issues. Well if you are just going to drag and drop using DBML code generator I am sure you will land up in to mess. Try doing this make a simple LINQ to SQL project using DBML and see your SQL profiler, I am sure you will never like to touch DBML code generator again. In this article we will first look in to how LINQ queries are executed, and then we will touch base on how compiled LINQ queries can help us improve our application performance at least 5 times. My numbers can be 10% up and down as I had come to that figure using my environmental situations.
  • Tips to Increase SQL Server Query Performance: Part 2Jun 15, 2015. This article provides more tips to increase SQL Server query performance.
  • Tips to Increase SQL Server Query Performance: Part 1Jun 11, 2015. In this article we will learn how to increase the query performance in SQL Server.

OUR TRAINING