DataSource Controls :: Scalar Function And Performance?
Apr 6, 2010i am calling a scalar function from a stored procedure. Does using user defined scalar finction has a negative impact on performance.
View 1 Replies
Similar Messages:
DataSource Controls :: How To Use Cursor In Recursive Sql Function (scalar-value Function)
Apr 25, 2010how can i use cursor in this function ?
ALTER FUNCTION [dbo].[GetCatIDChilds]
(
@CatID [code].....
DataSource Controls :: How To Declare Scalar Variable @UserName In Function
Jan 14, 2010How do I define @UserName in my function:
[Code]....
I believe "UserName" = Me.User.Identity.Name
but I don't know the proper way to add it to the function.
DataSource Controls :: LINQ Performance Application Performance Is Not Up To Par?
Apr 29, 2010I am not sure if this is the right forum. I can not find a forum for LINQ.
I am working on an application using LINQ. Application performance is not up to par and my tests show that it is LINQ queries that are slow. I was wondering if anybody can recommend where I can find an article about optimizing LINQ performance maybe by compilation or other methods.
DataSource Controls :: Declare The Scalar Variable @txtSubject?
Mar 24, 2011I can't figure out whats wrong with my contact page. I am getting this error when executing. It complied fine, I see the page as it suppose to. Then I enter all my contact information and click submit I am getting this error. Can someone guide me. Here is the error msg
must declare the scalar variable @txtSubject Here is the part of relevant code
Protected Sub Button1_Click(ByVal sender As Object, ByVal e As System.EventArgs) Handles btnSubmit.Click
Dim ContactDataSource As New SqlDataSource()
ContactDataSource.ConnectionString = ConfigurationManager.ConnectionStrings("ASPNETDBConnectionString1").ToString()
ContactDataSource.InsertCommandType = SqlDataSourceCommandType.Text
ContactDataSource.InsertCommand = "INSERT INTO Enquery (EnqSubject,EnqFirstname, EnqLastname,EnqContactNumber,EnqEmail,EnqMsg,EnqDateTimeStamp,EnqIPAddress) values (@txtSubject, @txtFirstname, @txtLastname,@txtPhone,@txtEmail,@txtMsg, @txtDateTimeStamp,@txtIpAddress)"
[Code]....
DataSource Controls :: Must Declare The Scalar Variable With Name Parameters?
Mar 1, 2011I'm getting "Must declare the scalar variable "@ShowTypes"." when I try to run the code below.
[Code]....
SQL Server :: Error While Executing A SQL Scalar Function?
Nov 1, 2010CREATE
FUNCTION dbo.ufnGetProductReport(@Pid
int)
RETURNS int
AS
BEGIN[code]....
This is the program. When im trying to execute it with Select * from dbo.ufnGetProductReport(1)
im getting an error Invalid object name ufnGetProductReport
Trying To Create A Scalar Function In SQL Server 2005?
Mar 22, 2010 VWD 2008 Express. Visual Basic. SQL Server 2005. I am trying to create a scalar function in SQL Server 2005 wherein I pass a string that respesents a portion of a WHERE clause in the function's SQL statement. I would be passing things like "GDate>1/1/2010 and GDate,1/1/2011" or "Year(GDate)=2010" When I try to build the function it errors out saying basically that the @WhereClause is not a boolean expression. Does anyyone know how I could accomplish this? The part it does not like is in red.
[Code]....
SQL Server :: How To Use Case Statement In Scalar Valued Function In Sql
Feb 21, 2011i want to get one value from function using case statement,i tried it but not work
CREATE FUNCTION [FATMS].[fnReturnByPeriod]
(
@Period INT
) [code]....
SQL Server :: Stored Procedure With Scalar Function Slow?
Mar 11, 2011I have the following sp that uses a scalar function to get the cost of a product
The procedure calculates profit of each bill,and using two tables
1 - Estimate Header
2- Estimate details
For each estimate invoice sp will compare items profit by comparing items rate with the rate it is purchased.I use a Scalar sql Function to get the Purchase Cost of each item in an invoice.This fuction cause the slow execution
Can this scalar function be replace with something else to get this sp execute faster....now it taking around 25 seconds there is only 1100 invoice in the database.
select BillNumber,sdate [Date],case when t1.Customer = 0 then 'Account Payable' else t2.AccountName end Customer ,case when t1.CashOrCredit = 0 then 'Cash' else 'Credit' end CashOrCredit,(select Sum(gross) from EstimateDetails where billNumber = t1.BillNumber)Gross,t1.netDisc,(select sum(TaxAmt) from EstimateDetails where billNumber = t1.BillNumber)Tax,t1.Ces, Amount,t1.roundOff,Paid Payment,
DataSource Controls :: How To Insert A Picture On A Gridview / The Error - Must Declare The Scalar Variable
Feb 28, 2010i would like to insert a picture on a gridview, but i allways get the error:
Must declare the scalar variable "@IMAGEM"
somme one can on tihs code ? here is my code:
[code]....
DataSource Controls :: Subqueries Are Not Allowed In This Context - Only Scalar Expressions Are Allowed
Mar 22, 2010i get the above error when i try to run this sql statement
INSERT INTO PSPS_Posts (Post, Date_Posted, user_ID, Thread_ID) VALUES (@Post, @Date_Posted, @user_ID, (SELECT Thread_ID FROM PSPS_Thread WHERE Thread_ID = (SELECT MAX(Thread_ID) FROM PSPS_Thread
DataSource Controls :: Must Declare The Scalar Variable "@UserId"?
Mar 30, 2010am trying to provide users with a number of options, among which, I would like them to see a sum of trips that they have talked about. I have therefore the Trips Table and the Users table. The UserId is the PK of User Table and FK of Trips Table. Trip_Id is PK of Trips Table.In order to see a sum of the number of trips that a user has post, this is the query I have wrote into SQLDATASOURCE:
[Code]....
Everything seems really simple and cannot figure out why when I try to login to test the application , the error I get is: Must declare the scalar variable "@UserId".
DataSource Controls :: SQL Performance With IN Or BETWEEN?
Apr 17, 2010I have got a table in SQL Severs as following, which contains sales data (approx 10m records), the indexes and primary keys are SalesDate, StoreNo and ItemNoSalesDate StoreNo ItemNo SalesQtyWhen I am querying the table for a given item and store's sales for the last 7 days, if I use the query:
[Code]....
The query runs almost instantly, obviously using IN is the faster mehtod here, but I have read elsewhere that using BETWEEN is the quicker method, can anyone confirm?
DataSource Controls :: How To Improve SP Performance
May 5, 2010I have one online school management application developed on asp.net 3.5 using Linq,
Now in my database i have main three talbes which uses in many store procedures,functions,linq join query
CourseMst - Master Table Have CourseID P.K.
StudentMst - Master Table Have StudentID P.K.
Student_Course - Child Table Have StudentCourseID P.K
StudentID F.K. Reference To StudentMSt
CourseID F.K. Reference To CourseMSt
Now i want to increse speed of my application for those page which have query or sp related to above tables,
I want to know about indexing procedure that how to apply indexing and on which field i have to apply indexing
DataSource Controls :: How To Improve Website's Performance
Jun 5, 2010I had created a web site with asp.net and sqlserver. How can i improve the my website's performance in with regard sqlserver connection?What's your mind about use pool connection? In this regard what the defualt values is set for 'Max Pool Size' and 'Min Pool Size'?What's your mind about use Asynchronous access to data? What's your mind about other ways that you think?
View 3 RepliesWeb Forms :: Increase The Performance Of The Function?
Mar 30, 2011In my web application i send a invoice(pdf file at least 700kb) when completing a order(create a pdf file then attach it to mail function and send it and delete the file).There are more than 10 users use this function same time. My problem is when all users login to the system and doing transactions system take more time to complete the above function. I want to increase the performance. What is the best way.
View 3 RepliesDataSource Controls :: Improve The Performance Of Time In Sqlserver?
Mar 21, 2010I have a select query where iam fetching the data from minimum of 7 different tables by using innerjoin. I have 3 lakhs of records in that table.BY using cache Iam fetching all 3lakhs of records at a time and put in cache. by using the rowfilter i use the records.firsttime when iam fetching these 3lakhs records it takes 3min. want to improve the performance of time.How to improve the performance of time?
View 1 RepliesDataSource Controls :: Performance In Stored Procdure With Cursor?
Apr 8, 2010I have created the stored procedure in SQL server 2005. i have used nested cusrsors in this SP. also many records are there. So, its performance is too low.
i forced to use cursor, because the this is calcualtion process. i have to fetch the records one by one, do the calculation and insert the result to the another relevent tables.
So it cause big performance issue.this is my sample scanario.
First i have to take the products from the customerforecast for the certain duration. (i used cursor to fetch the products)
then i need to get the list of machines can run for the each product. (i used cursor to fetch the machines)
then i have to fetch the Unit per hour value for the combination of machine and prduct.then i have to use formula and do the calculation and store the result to the 3 different tables.
DataSource Controls :: Improve Stored Procedure Performance?
Feb 3, 2010I am using Sql server 2005. I have a stored procedure, which has a select statement to retrieve thousands of data from the table.
The time taken to execute is longer and hence affecting the performance.
[Code]....
Here, id is the primary key. Clustered Index is also set.
How to improve the performance of the stored procedure?
DataSource Controls :: Improve Performance While Doing Execute Nonquery?
Feb 2, 2010I have web application in ASP.NET 2.0 and C#.I have a gridview and i have a checkbox in the gridview. I am trying to save the checked record from the gridview to the database. The time taken to save the data is becoming huge and causing performance issues.
[Code]...
DataSource Controls :: Will Multiple Tables In A DataSet Affect Performance
Apr 29, 2010I have a dataset that comprises of multiple tables (about 20) linked together with constraints to reflect the relational database. My question(s):
1) Will having multiple tables affect performance? I'm asking this as there are often times I would not need to get data for all the tables, but only for specific tables.
2) If it does affect performance, would breaking up the tables into their own datasets be the best solution. It seems to me that by doing that, you would lose the ability to apply constraints among tables and tables that might exist in multiple datasets will be subjected to replication.
I would like to have everything in one dataset as I get a view of the related tables and their relationships and also because the Fill method allow me to fill tables, maintaining the hierarchy of the data, but performance is still a key factor.
DataSource Controls :: Test The Performance Of When The Query Is Included Directly In The SqlDataSource?
Feb 16, 2011I have a query that I want to test the performance of when the query is included directly in the SqlDataSource versus when I call a stored procedure. Does anyone have suggestions on how I would be able to closely watch the actual steps here? I was thinking of turning on tracing and adding Trace.Write for each of the events that fire along the way. This doesn't seem efficient and I wanted to see if there was a better approach.
View 2 RepliesDataSource Controls :: SQL Function 'WITH ENCRYPTION'?
May 12, 2010How can I put a SQL Function as 'WITH ENCRYPTION' like you can with a Stored Procedure?
View 2 RepliesForms Data Controls :: Binding Scalar Values - Get Value In OnItemDataBound?
Jan 21, 2010I have a question on Scott's article about binding scalar values to data controls: [URL]
On the seconde example (the one using templates), how would I access the scalar value in the controls OnItemDataBound event? e.Item.DataItem seems to be null....
