SQL Server :: Slqce Query Performance?
Oct 21, 2010I use slqce database to store master-detail table.It took too long to insert byte array data. how to improvement the query performance?
View 2 Replies
Similar Messages:
SQL Server :: How To Increase The Performance Of Query
Jul 19, 2010How to increase the performance of query in sql server2008
View 4 RepliesSQL Server :: How To Do Query Optimization And Performance Tuning
Dec 6, 2010I have database with 40 big tables.In each stored procedure query is containing minimum 6 joins.The query is taking too much time to execute.I didn't implemented views and indexes.
View 2 RepliesSQL Server :: To Check Query Performance In Sqlserver?
Feb 27, 2011how to check query performance in sqlserver 2008 r2
View 1 RepliesSQL Server :: Monitor The Query Performance As It Is Run From The Webpage?
Mar 11, 2011isnt there performance analysis tools that i can use to monitor and trouble shoot things like timeout expired (slow query execution)?
I mean is there a way for me to monitor the query performance as it is run from the webpage. It runs perfectly in the SMS but it's slow when it's running from the webpages so it throws Timeout expired exception.
SQL Server :: How To Increase The Performance Of The Select Query Fetching Data From Huge Temp Table
Jan 25, 2011I have one Store Procedure that generating report ..
For storing the data there , i used many temp. tables. There is many Select Query , little less insert and delete query.
Now if there is huge data around 1 lac in temp table my select query taking to much time and also may be insert and delete query
I added Primary key to all auto Increment Field in temp table. Also defined Clustered index on that primary key as unique Clustered index to improve the performance .
But there is not so much improvement in case of huge temp table.
Right now the whole Store Procedure is taking time to complete around 1.5 days or around 30 hours ..
So i want to increase the performance as much that it completes on nearly 3-4 hours.
Better Performance To Query The DB Or Cache Small Result Sets?
Mar 14, 2011Say I need to populate 4 or 5 dropdowns w/ items from a database. Each drop down will have < 15 items in it. These items almost never change.
Now I could query the DB each time the page is accessed or I could grab the values from a custom class that would check to see if they already exist in ASP.Net's cache and only if they don't query the DB to update the cache.
It's trivial for me to write but I'm unsure if the performace would be better or not. I think it would be (although not likely anything huge).
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 RepliesConfiguration :: .Net Website Performance Of 2 Sites - Rectify The DB Performance While Insertion?
Sep 20, 2010I have developed a website in asp.net framework 2 . This website is being hosted in two different servers without any change in code. My issue is about the performance of these 2 sites. One website is taking much time for inserting datas to the DB (SQL server 2005). 2 websites are having different DB server.
I think the issue is for the DB server. How can we rectify the DB performance while insertion and Is there any other cause for this permance issue?
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.
WCF / ASMX :: Wcf Performance Vs Page Events Performance?
Mar 20, 2011I am creating a service oriented application where trying to have everything using services....however there is something I am not sure of , I am having a page that calls the database at the page load...so what would be better and faster?? to call database in pageload , or to call wcf service from javascript during javascript load ??btw , I am using a repeater in the page , but I have created somekind of an engine to create the suitable html so...I'll be creating the repeaters html using the wcf and resend it back to the page If I am using a wcf service at the start.
View 1 RepliesDataSource Controls :: Can't Find Query's / By Right Clicking On Database Created A Query In Server Explorer?
May 17, 2010By 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 RepliesSQL Server :: Sub Query In Cross Table Query To Create Statistics
Mar 2, 2011I 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
SQL Server :: Query Slow In Loading / Trying To Display Query Result?
Feb 1, 2011I 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
SQL Server :: Is There A Difference In Performance Between Express And Web Editions
Nov 19, 2010I would like to build a site and use SQL Express database. Ny question is that is there a difference in perforamcne betweeen Express edition and Web edition?
View 2 RepliesSQL Server :: Increase Performance Of Stored Procedure?
Oct 2, 2010I 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
Databases :: Oracle Query Convert To Sql Server Query
Sep 3, 2010I 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
Configuration :: Application Performance Declined After Deploying In Server?
Aug 13, 2010My application is working well in localhost, but it became very slow after deploying in server.
I have used session which stores 2 string values. What might be the reason? Its taking too much time to retrieve page
SQL Server :: How To Copy Result Query To Another Query
Nov 4, 2010i have tow query in one stored procedure
first query and the second one every of them return only value
i want to copy the result of tow values in a new row in new table
as i want to check on this tow values in ado.net
i want to get only this tow values as a row not first and secon query
only a row has result of first and second query results
[Code]....
SQL Server :: Select Second Query If First Query Returns Nothing?
Oct 14, 2010How can I SELECT second if first SELECT returns nothing?
View 8 RepliesSQL Server :: Reading File Csv And Inserting Into SqlCE Performance Improvement?
Dec 15, 2010NOTE: Code and names simplified for post. Elimination of try catch and other best practices also limited for post.
I have a simple SqlCE database one table consisting of 4 columns (specialvalue, name, state)
I am using a streamreader from a file.txt that contains 3000 lines of csv data, looping the below.
s[] = {id,name,specialvalue,state) //(SAMPLE DATA-displaying names)
while(!sr.EndOfStream)
{
[Code]....
This code works as expected but I would like to increase the performance since it takes over 30 sec to complete. I will be moving to a stored procedure later but would like to find out how to optimize the current code. This is more for experience than anything. It is a project that I am working on for codeplex.
Configuration :: Folder Size On Hosting Server Affect Performance?
Dec 14, 2010we host the web application on a server and the structure is..
Root
Module1
page1.aspx
Module2
page4.aspx
Temp
archivedImages
image1 image2
The temp folder size is increased every month as we manually add images.
Except the Temp folder every page is requested from the browser...
We dont use the Temp folder for any other purpose other than archive.
Does this affect the performance of the web application i.e. constant size increase?
how different would it be if we moved the temp to some other location out of the Root?
SQL Server :: Vastly Different Performance Of Table Update On Similar Machines?
Oct 21, 2010Two machines. One a little faster than the other. The slow one runs windows xp, visual webdeveloper express 2010, sql server 2008. The fast one runs windows server 2008, visual wev developer express 2010, sql server 2008.The code in queston involves an automatically generated update function in one of the table adapters, called 'adapter'. Our C# code generates a data table called 'table', with which we update our 'datatable' in the table adapter.
The table has about 100 entries.We then update our datatable in the .xsd file by calling.
int rowsaffected = adapater.Update(table);//this is the line that takes long on fast computer return rowsaffected > 0;//since function returns a bool On the slow machine this line of code takes a few milliseconds.One the fast machine it takes 5 seconds.These results are consistent. It has nothing to do with one machine being busy, the other idle.
What could be the reason and how could it be solved? How can the same code, on the same platform, on a faster machine take 500 times longer than on a slower machine?
SQL Server :: Insert Data Into Temp Table Will Occurs Wrong Order By Performance?
Jan 3, 2011i just create table simply like this: create table tblDemo
(
PK_intID int primary key identify(1,1),
intHits int not null
[code]...
Configuration :: Trigger IE9 To Render In Compatibility Mode Negatively Affect Performance On The Server?
Mar 17, 2011Would adding "X-UA-Compatible: IE=EmulateIE7" as an http header to trigger IE9 to render in compatibility mode negatively affect performance on the server? I made the change today, adding it, but now some areas of our site are behaving sluggishly, though we did have a large number of changes come in overnight. I know that we can't single out this as the problem, but my boss seems to think it is.
View 3 Replies