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:

AJAX :: Make Requests With Faster

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

Jquery - How To Make Requests With Ajax Faster

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

AJAX :: Make Tabs Dynamically Generate Faster?

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

Visual Studio - Finding Ways To Make Build Faster / Trying To Improve Edit-Compile-Test Loop

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

SQL Server :: How To Make Join Query

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

SQL Server :: Query - How To Make Total Sum Of The Result

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

Php - Client Vs Server Side Processing - Faster?

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

SQL Server :: Insert Bulk Values Faster Into DB?

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

Server.Transfer() Is Faster Than The Response.Redirect()?

Apr 22, 2010

Why Server.Transfer()is faster than the Response.Redirect(). Can anyone explain in details.

View 6 Replies

How To Make A Result In A Query(with Var.)

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

DataSource Controls :: Can't Find Query's / By Right Clicking On Database Created A Query In Server Explorer?

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

SQL Server :: Sub Query In Cross Table Query To Create Statistics

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

SQL Server :: Query Slow In Loading / Trying To Display Query Result?

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

ADO.NET :: How To Make Var Query Static For Linq

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

Databases :: How Make SQL Query Run Under ORACLE

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

Databases :: Oracle Query Convert To Sql Server Query

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

Web Forms :: Make Sql Query On Checkbox Click?

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

DataSource Controls :: Make Union Query Better?

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

Simplify LINQ-To-Entity Query, And Make It Dynamic

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

ADO.NET :: Make A Linq Query Dynamic In The Pseduo Code

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

How To Make A Readonly Text Box Editable On Mouse-over Using J Query

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

Web Forms :: Query String Parameters Make App At Risk?

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

Query String Parameters Make Application At Risk?

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

DataSource Controls :: Make Parametrized SqldataSource Query In C#?

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







Copyrights 2005-15 www.BigResource.com, All rights reserved