SQL Server :: How To Make Sql Query Run Faster
Jul 20, 2010
How to make sql query run faster . Below is my query:
SELECT [FieldValue2] = case isdate(FieldValue2) When '1' then
case isdate(FieldValue4) When '0' then
dbo.GetCountagingDay(FieldValue2, getdate(), '') -1
else
'0'
end
else
'0'
end
FROM test
View 6 Replies
Similar Messages:
Dec 11, 2010
i find a lot of websites that have some parts in the page that uses ajax much more faster than i used to see ajax requests
like changing views using tabs when i click a tab it changes content very fast than i used to in my web applications using Asp.Net and Ajax Control Toolkit
and also a very quick paging in repeaters or grids than i ever developed in my web apps
like this website [URL] i need to know which technology used to achieve this this website is developed using .net
so
but i need to know is this needs another technology to learn (from where can i learn it)
or is it just asp.net + ajax or whth other technology
is it MVC
also i want to know if MVC is better than asp.net + ajax in concern with performance
View 4 Replies
Dec 11, 2010
i find a lot of websites that have some parts in the page that uses ajax much more faster than i used to see ajax requests
like changing views using tabs when i click a tab it changes content very fast than i used to in my web applications using Asp.Net and Ajax Control Toolkit
and also a very quick paging in repeaters or grids than i ever developed in my web apps
like this website [URL]
so i need to know which technology used to achieve this this website is developed using .net
but i need to know is this needs another technology to learn (from where can i learn it)
or is it just asp.net + ajax or whth other technology is it MVC
also i want to know if MVC is better than asp.net + ajax in concern with performance
View 5 Replies
Feb 12, 2010
I am using the tab control and basically I have 4 buttons. Each button will load a seperate ascx control into a brand new tab. After about 4 tabs, since it has to regenerate all 4 tabs, the speed in order to add tabs just becomes too long for my tastes. Is there any way to remedy this and make it go faster?
EDIT2:Using Internet Explorer 7.0 and 8.0
EDIT: Some Code, I store the i in viewstate and loop through this every time for each panel per regeneration
private void BuildNewTab(int i)
{
TabPanel newPanel = new TabPanel();[cod]....
View 1 Replies
Mar 17, 2011
When I'm building my web project it takes about 20 seconds to compile. Then when I try to browse to a web page in project, asp.net does its runtime compilation(another 20 seconds). I know I can't escape these steps because thats how asp.net works, just want to see if anyone has some kind of optimization to make these builds faster.
Trying to improve Edit-Compile-Test loop
My machine details:
-Intel Core i7 processor @2.80GHz
-8GB of RAM
-HD @ 7200 RPM
View 4 Replies
Dec 22, 2010
I have a problem with a sql server query, what am I missing - why doesn't it work? This is what I want to retrieve:
tblMeetings: ID, subject, description
tblOccasion: dateStart, dateStop
WHERE Meetings.status = 'bokad'
AND Meeting.ID = Occasion.meetingID
Below is two alternatives for the same result, with different error messages:
[Code]....
[dbo].[Meetings](
View 3 Replies
Nov 3, 2010
this script work with join and sum
and works good,but i want to make total sum of the result of this query for all rows of sum column
[Code]....
View 4 Replies
Jan 4, 2010
Which processing is fast Client-side or Server-side? for client side processing browser need to download every JavaScript first and in server side programming everything happens on server without downloading anything to user PC? if for a particular functionality we have solution in both javascript and php/asp then what should be chosen and why?
View 3 Replies
Dec 16, 2010
I need to update bulk values (more than 20000 each time) from my web form into sql server 2005 .I have a web page , from which when i click submitt button values from the form should be inserted . For that i tried normal method as shown below
[Code]....
But this is also slow (Adding to datatable make its slow I suppose ) .Is there any other method so that my insertion can be made faster .
View 10 Replies
Apr 22, 2010
Why Server.Transfer()is faster than the Response.Redirect(). Can anyone explain in details.
View 6 Replies
Oct 31, 2010
i need to make 2 funtions on an ASP.NET c# page working with an SQL server (using Visual Web Developer 2010 Express) the 1st one is a simple serach and i've done the 2nd thing is an update , the sp is like:(it works in SQL)
UPDATE [lens] SET [qty] = @b+@c WHERE [id] = @a
@a is the id which user input in the textbox1
@b is an number user input in the textbox2
now @c should be the result of an query "select [qty] from [lens] where [id] = @a"
so ,the new value of [qty] will be the "old valus"+"valus in textbox2"
View 2 Replies
May 17, 2010
By right clicking on my database i created a query in server explorer. But where are this query stored can't find them back. I should aspect that their is a folder query's like there is a folder tables but this isn't the case.
View 10 Replies
Mar 2, 2011
I am trying to create statitics for game downloads and am having dificulty with a sub part of my query. the goup by command is not having the disired result and i think i have been looking at it too long to see what i am doing wrong. [Code]....
At the moment it is producing each result in many rows when only 4 rows should appear. its the download column that is doing it. needs to be sub queried or something to display total in relation to month,gameid,userid.
Month-download-GameID-UserID
1 1
1 1
1 1
1 1
View 2 Replies
Feb 1, 2011
I am trying to display this query result in an aspx page.
It is very slow in loading. Here is the query. The inner query inside the outer quesry is the problem.(Please see the underlined part in the query) - (If I remove that part it is very fast.)
select
top 500
--This column is the issue
,Governing_Class=( case when exists (select top 1 tqc.class_code from
t_quote_class tqc
inner join t_quote_class_premium tqcm on tqc.class_code =tqcm.
class_code
where tqc.appid=pi.appid and tqc.class_code not in('8742' ,'8810','7380')
order by tqcm.premium_amt desc
)
then ( select top 1 tqc.class_code from
t_quote_class tqc
inner join t_quote_class_premium tqcm on tqc.class_code =tqcm.
class_code
where tqc.appid=pi.
appid
order by tqcm.premium_amt desc
)
......... From tables
View 7 Replies
Oct 6, 2010
I was use SQL Connection to Access Data Base in Past and When Select Data in DataSet make it static & than it can avaliable on class level.I click on Edit Button its avalibale because its Static.Than now i think try it with LINQ it's provide easy Access to Data Base; in Insert/Update/Delete than SQL Connection it look's me great when i use it.
But i don't know how to make var Query Static for its class level avaliability. i can define it by my code
public static DataSet DsCustomers;
protected void Page_Load(object sender, EventArgs e)[code]....
in LINQ example i want to make sure that SelectQuery is avaliable on Class level & want to make it static
View 3 Replies
Jan 8, 2010
i have a SQL Query. It works fine in Sql server. let me know how to make it work in Oracle.
You can run below code in Sql server and check. It will work fine. But in Oracle,( I am using TOAD for Oracle )it is giving some errors.
Code]....
View 4 Replies
Sep 3, 2010
I am a biggner in SQL DB . but i started a complicated and painfull work in SQL SERVER 2008. the problem convert Oracle hierarchical query to SQL query. the query
SELECT DISTINCT
LEVEL LVL,
SCH.NSCHEDULE_SL,
SCH.NSCHEDULE_SL_FM,
SCH.CSHED_CNAME
FROM FA_SCHEDULES SCH
WHERE LEVEL = 1
AND NSCHEDULE_SL_FM IS NULL
AND NBRANCH_SL = 2
CONNECT BY PRIOR SCH.NSCHEDULE_SL_FM = SCH.NSCHEDULE_SL
AND NBRANCH_SL = 2
View 1 Replies
Oct 26, 2010
I want to make a serach system in my website, In which user select the various fields of tables through checkbox & after selecting the desired fields he clicks on the serch button, & the desried result set is comes. Can any buddy tell me the code that how i implement this functionality.
View 7 Replies
Apr 11, 2010
in my application i should make an union query thay union 15 tables
and this query begin with 150000 rows and will grow .
i need get just 10 rows from this query
i want make this query as best as possible
2 qustion
-----------------------------------------------------------1------------------------------------------
********View1*******
select id, lang, active from table1
union
select id,lang,active from table2
...--same way to all other 15 tables
*******SP***********
select top 10 from View1 where active=1 and lang='he' order by id desc
or
********View1*******
select id, lang, active from table1 where active=1 and lang='he'
union
select id,lang,active from table2 where active=1 and lang='he'
...--same way to all other 15 tables
*******SP***********
select top 10 from View1 order by id desc
---------------------------------------------2---------------------------------------
becauseof that this query is very complicate i want to know if i need take just 10 from each table
------------------------------------------------3--------------------------------------
if there is an idea how make this query better, i will glad to know.
View 7 Replies
Dec 4, 2010
I have this query for getting data through Entity Framework, which works today. Thing is, i want to create the query dynamically, i.e build it up in blocks, but i can't figure out how exactly to do it. I believe if i can somehow save one of the values that i retrieve in the beginning i can do it, but now i retrieve it twice (probably a bit slow as well? Unless the compiler fixes it before quering). Makes sense? Here is the LINQ:
[code]....
I.e based on if various variables have values.
View 1 Replies
Sep 9, 2010
is it possible to make a Linq query dynamic in the following pseduo code (to show what I'm trying to do)
[Code]....
where a2 and a3 and a4 are being populated from user controls and only one will apply. So query is done by state, zip or by city, but not by more than one, so the other two would be null. So the operator is really "OR" but I haven't found anything on a "or" or "whereOr" operator.
View 9 Replies
Aug 15, 2010
I have a read-only text-box with text in it. How to make it editable on mouse-over using J query ?
View 1 Replies
Feb 1, 2010
I'm writing an Asp.Net WebForms app where I am calling an edit page an passing in the data about the record to be edited using query string parameters in the URL.Like:
http://myapp.path/QuoteItemEdit.aspx?PK=1234&DeviceType=12&Mode=Edit
On a previous page in the app, I have presented the user with a GridView of screened items he can edit based on his account privileges, and I call the edit page with these above parameter list, and the page know what to do.
View 6 Replies
Feb 1, 2010
I'm writing an Asp.Net WebForms app where I am calling an edit page an passing in the data about the record to be edited using query string parameters in the URL.Like:http://myapp.path/QuoteItemEdit.aspx?PK=1234&DeviceType=12&Mode=EditOn a previous page in the app, I have presented the user with a GridView of screened items he can edit based on his account privileges, and I call the edit page with these above parameter list, and the page know what to do. I do NOT do any additional checking on the target page to validate whether the user has access to the passed in PK record value as I planned to rely on the previous page to filter the list down and I would be fine
View 7 Replies
Jun 10, 2010
I have a gridview which I connect by C# and SqldataSource. I use asp.net 2.0 - 3.5.
I want to parameterized the queries and how do I do this in the C# file ? how do I set the selectparameters in C# ?. I do not want to do this in the aspx fil.
My code in C# is:
SqlDataSourceMachineName.SelectParameters.Clear();
SqlDataSourceMachineName.SelectCommand = "Select MachineName from tblMachine inner join tblLocation on tblMachine.MachineLocationID = tblLocation.LocationID where tblLocation.LocationName = 'New York' and
tblMachine.StatusID = '1'";
View 9 Replies