SQL

Best 17 Easy Steps For Improve SQL Query Performance

Introduction In this article, I will discuss how can we improve SQL query performance. Several times you have seen your SQL stored procedure or query getting too much slow. which is one of the primary reasons for your application slowness. So in this article, I will discuss a few easy SQL query optimization steps by which you can improve your SQL…

Continue Reading

C#, DataTable, SQL, sql server table valued parameter performance, table valued parameter in sql server

How to pass data-table as parameter to a stored procedure in MSSQL from C# Application

Introduction Here I will discuss how to pass/send a data-table as parameter to a stored procedure from c# application.In other words, we can say how to pass table valued parameter as parameter in the stored procedure in SQL server. When we are sending one line of query to the stored procedure that time, we can send our defined variable, during…

Continue Reading