sql runs fast in ssms slow in asp.net

by

Chances are that you are hitting on a problem with parameter sniffing.

I suggest reading Slow in the Application, Fast in SSMS? by Erland Sommarskog to get a full understanding of the issue (long article but very good).

More Related Contents:

  1. sql server 2008 management studio not checking the syntax of my query
  2. SQL Server 2008: how do I grant privileges to a username?
  3. Converting Select results into Insert script – SQL Server
  4. Restrict varchar() column to specific values?
  5. Insert local .csv data in remote SQL Server via already working connection string
  6. Syntax combine two stored procedure into one [closed]
  7. How to delete duplicate rows in SQL Server?
  8. CROSS JOIN vs INNER JOIN in SQL
  9. How to cast the DateTime to Time
  10. How can I schedule a job to run a SQL query daily?
  11. Reset identity seed after deleting records in SQL Server
  12. How to avoid the “divide by zero” error in SQL?
  13. Multiple INSERT statements vs. single INSERT with multiple VALUES
  14. Real life example, when to use OUTER / CROSS APPLY in SQL
  15. How to convert an integer (time) to HH:MM:SS::00 in SQL Server 2008?
  16. What is the order of execution for this SQL statement
  17. Splitting delimited values in a SQL column into multiple rows
  18. How to import text files with the same name and schema but different directories into database?
  19. Split values over multiple rows [duplicate]
  20. How can I alter this computed column in SQL Server 2008?
  21. How to get the size of a varchar[n] field in one SQL statement?
  22. SQL Server: should I use information_schema tables over sys tables?
  23. Closing connection when using Dapper
  24. TSQL – How to use GO inside of a BEGIN .. END block?
  25. SQL take just the numeric values from a varchar
  26. Cumulative Total in MS Sql server [duplicate]
  27. How to write a WHERE Clause to find all records in a specific month?
  28. How to make a view column NOT NULL
  29. Flattening of a 1 row table into a key-value pair table
  30. SQL Server equivalent of WM_CONCAT function [duplicate]

Leave a Comment