I 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
I 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?
I 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?
I 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.
Initially, I have tried to use stored procedure. But I changed my mind and preferred to call sql query in codebase with command text. However, it stills tries to find initially-called stored procedure (which is neither called or exists).I think that it is related caching. But I tried it with different browsers it did not work.What might be the reason?
I have written one store procedure for fetching huge data like this. there are nearly 2000 records. It is taking nealy 50 sec to execute. Could you tell me best method to fetch large no of data ?
ALTER PROCEDURE bulls_orbit.BuySellUpdateFetchData AS Select Id,Message,EndDate,RefId from tblBuySellUpdate Order By Id Desc RETURN
The database I am using has a schema called EQB and as such, my stored procedures are named as EQB.usp_SelectFunds, EQB.usp_SelectAccount, etc.
On the select tab of the Configure Data Source screen, I choose to use a stored procedure. The dropdown shows my stored procedures, however, the schema name does not show up in front of the stored procedures in the drop down. I see only usp_SelectFunds, usp_SelectAccount, etc.
I select one of the stored procedures and when I click TEST, I get the message that the stored procedure is not found. If I instead choose to use a SQL statement instead on the configuration screen and enter EXEC EQB.usp_SelectFunds and click TEST, it works fine.
Why are my stored procedures not showing up correctly in the stored procedure drop down and how can I fix this?
I 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.
I am trying to speed up a Gridview on my page that reads 8,000 records using an AccessDataSource. So I am trying to implement caching. I have used the information given here: [URL] but it has made no difference in the response time. Can anyone direct me on this? Is there something you have to specify in the gridview (besides the datasource). Would it work if I went to SQL Server?
This is my AccessDataSource code. You can see the 3 relevant lines starting 6 lines from the top.
i am using data gridview asp.net control and i bind it dynamically, gird displayed 80,000 thousands records so i am using paging techniques,on each page gird display 10 record so when i am change page each time gird should filled 80.000 thousands records so how could i bind gird from pageIndex,pageSize rather than bind it whole records
Code]....
it works properly but when i change page or grdTender_PageIndexChanging event fire each time gird fill with 80.000 records now i want to bind it from current pageIndex to current page size to improve the performance of datagird
I created a database on SQL Server 2005 developer edition with MS SQL Server Mangement Studio Express. Now I created code that accessess a stored procedure named 'pS_TableData'. However I have one problem the code raises an exception "Could not find stored procedure 'pS_TableData 'Letters''."the code looks like this:
[Code]....
Note I am using (for now) the same connection that I used to create my database so in essence my web site is the administrator. I tried a simple SELECT from a table with the same connection and it raised no exceptions!When I run EXECUTE ps_TableData 'Letters' in SSMS it has no . I also tried EXECUTE ps_TableData 'Letters' as the command paramated for SqlCommand but it had the same effect
I call this stored procedure with a dataset. It always returns a 0 but should return a 1 or 2. Does anybody know why it isn't returning a 1 or 2.
ALTER PROCEDURE dbo.sp_InsertLinkVote @LinkId int, @LinkVoter nvarchar(50), @LinkVotesDateTime datetime, @LinkVotesGoodBad bit AS /* SET NOCOUNT ON */
If EXISTS (SELECT * FROM LinkVotes WHERE LinkId=@LinkId and LinkVoter = @LinkVoter )RETURN 1 ELSE INSERT INTO dbo.LinkVotes (LinkId,LinkVoter,LinkVotesDateTime,LinkVotesGoodBad)VALUES (@LinkId,@LinkVoter,@LinkVotesDateTime,@LinkVotesGoodBad)RETURN 2
Here is were a call it in my code behind. Dim VoteCheck As Integer Dim InsertVote As New DataSetStoredProceduresTableAdapters.QueriesTableAdapter VoteCheck = InsertVote.sp_InsertLinkVote(LinkId, User.Identity.Name, DateAndTime. Now, True) '0 is a good vote. If VoteCheck = 0 Then
It seems to insert and not insert correctly, I just cannot get it to return the correct value.
I am developing a page in ASP.Net where I have the user enter a letter into a textbox. They then click a submit button and I all of the userids that start with that letter are to be displayed. So I need the SP to go through the database and match first letters with what was entered. Here is what I have as my code for the SP:
CREATE PROCEDURE dbo.exp2 @testchar Char(1) declare @flag as char(2) set @flag = @testchar + '%' select userid from ex_database where userid like @flag
So I'm working with SQL Server 2005 and I'm having trouble saving a stored procedure. (I've only used an Apache server before, and for nothing as complex as the project I'm working on)
Nonetheless, the problem is that I don't know where to actually save the stored procedure I create. In my Object Explorer, I go to the database I want to create it in, expand Programmability, right click on Stored Procedures and choose to create a new one. That's all nice, but when I'm ready to save and test it from my webpage, it asks where to save it. This is probably dumb of me, but I don't know where to. I try to save it on the desktop and click/drag to the Stored Procedures folder in my database, but all that does is open it, not actually store it in the database. Maybe I'm getting the point of stored procedures wrong? Let me know what I should do to save it in the right place so I can access it.
I'm trying to create a stored procedure that does two things:1st - Insert a new record in the contactus table.2nd - Gets the last primary key value from table contactus.I've created the following Stored Procedure but this is giving me an error when being executed.
I have a button which the admin will click on every new acad year to update the student's study level.
I have written a SP to do this process, however, it was working fine. But I faced problem when I did testing.
This is my student update study level stored procedure:
UPDATE Student SET acadLevel = (CASE WHEN acadLevel < '3' THEN convert(char,acadLevel + 1) ELSE convert(char,'G') end ) WHERE acadLevel between '1' and '4';
Error: Conversion failed when converting the varchar value 'G' to data type int.