DataSource Controls :: How To Execution Of Top 3 Salaries Query
May 24, 2010can anyone explain me how below query will execute internally ??
select sal from emp e1 where 3>(select count(*) ct from emp e2 where e1.sal < e2.sal)
Similar Messages:
DataSource Controls :: Sql Stored Procedure Execution Timeout?
Jan 1, 2010I am working with the web application for a Money Chain business group. I have to calculate the full payout for the associate members of the website twice in a month. The problem is, when i am executing a stored procedure which obviously take a long time to process all the associate details and calculate the payout, before i get the result the timeout happens in the server. What can i do to correct this problem?
View 4 RepliesDifferent Execution Time For Same Query - SQL Server?
Jan 28, 2011I have a query:
Select a from tbl_abc where id in ( select id from tbl_xyz where mainid = 12)
When I am executing this query, it is taking 1-2 seconds to execute, but when I am using the same query in stored procedure, the below query is taking more than 5 minute:
If(Select a from tbl_abc where id in ( select id from tbl_xyz where mainid = 12))
BEGIN
-- CREATE TEMPORARY TABLE [Say: #temp1]
#temp1 => Select a from tbl_abc where id in ( select id from tbl_xyz where mainid = 12)
inserting the same value in the temp table
drop #temp1
END
what could be the reason of this? and how can I resolve this? I am running the SP from asp.net
Databases :: How To Get Query Execution Time
Sep 2, 2010I need to find out the query execution time from the front end .Where should I insert the code for that.
I am using the bleow query:
OracleConnection con = new
OracleConnection(ConnStr);
con.Open();
OracleCommand cmd =
new
OracleCommand("Stored_Proc",con);
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.Add();
....................
................
OracleDataAdapter
oda = new
OracleDataAdapter
(cmd);
Databases :: Query Execution Taking 30 To 40 Second
Mar 16, 2011when i am executing a simple query it is takeing 47 sec .... that is only for one table.. other then that remaing table perfromance is good... Help me out... and is there chance to get good perfomance through .net coding..
View 3 RepliesSQL Server :: Flow Of Query Execution?
Jan 18, 2011Can any one please provide link for flow of query exection in sql
For eg.
FROM, [JOIN CONDITION, JOIN TABLE ...], WHERE, GROUP BY, HAVING, SELECT, DISTINCT, ORDER BY, TOP
Suppose when we write query, how that query will get execute behind. I would like to know about that.
Can you please provide ariticles or link related to this
C# - Stop SQL Query Execution From .net Code
Jan 24, 2011I'm executing one stored procedure from the '.net' code. Since there is a lot of data, it is taking too much time to execute. Is there any way to stop this execution from the c# code?
In other words, if we execute the query from database itself, there is a option to stop its execution but in the code is it possible?
C# - Force Query Execution Without Flush/commit
Feb 16, 2010i am using the transaction-per-request (session-in-view) pattern for an asp.net web application. I have a couple of points in the application where i want to Save an NHibernate managed entity and then do a couple of more inserts and updates using common sql. These inserts/updates depend on the ID that the NH saved entity will take.
The problem is that the generated id does not exist in the transactions' scope. If i force a flush/commit the id is persisted but if the inserts/updates fail i have to rollback but the flushed/committed entity will not. Currently I'm doing a manual insert for these cases but that is something i want to change. So, is there a way to execute the SQL statement (inside the already open transaction) after the Save() but without forcing a flush/commit?
EDIT: I'm adding a semi-pseudocode example, i got 4 wrong answers so i think people don't understand (how NHibernate works)
At the Begin request i issue a
nhsession.BeginTransaction()
then at some point i do
FooClass fc = new FooClass("value");
nhsession.Save(fc);
ITransaction trans = nhsession.Transaction;
SqlCommand sc = new SqlCommand("some insert/update query that depends on fc's id", (SqlConnection)nhsession.Connection);
sc.Parameters.Add("id", fc.Id); //NHibernate generates the id, note i'm using assigned/hi-lo so no round trip to the db takes place
transaction.Enlist(sc);
try {
sc.ExecuteNonQuery();
}
catch (SqlException ex){
transaction.RollBack();
nhsession.Close();
}
and at the end of the Request i issue a CommitTransaction() and nhsession.Close()
Now this will do absolutely nothing: the FooClass (fc) has not been flushed/commited to the database. The Save() operation that NH has done is up to that point in-memory. That means no sql command has been issued by nhibernate and that means that the SqlCommand (sc) that i fire afterwards will fail miserably as the id does not exist.
If i do a flush/commit between Save() and the SqlCommand the FooClass(fc) _cannot_be_rolled_back_ and that is a bad bad thing.Currently, for this to work i make vanila sql insert using an SqlCommand, and i want to change that. (Why? because i don't want to make vanilla inserts they are susceptible to errors due to schema/model changes, and i got the OR/M for that)
How? i want to notify NHibernate somehow to execute the SqlCommand to corresponds to the Save() insert (hell, it can do all the SqlCommands it has gathered) but without it commiting or flushing!.
Currently i'm also searching for the prepared sql statement that nhibernate produces when flushing/commiting a saved object. Maybe i can just take that string and run it in my SqlCommand that is enlisted in the Transaction.
C# - Delaying Linq To SQL Select Query Execution
Jun 14, 2010I'm building an ASP.NET MVC site that uses LINQ to SQL. In my search method that has some required and some optional parameters, I want to build a LINQ query while testing for the existence of those optional parameters.
Here's what I'm currently thinking:
using(var db = new DBDataContext())
{
IQueryable<Listing> query = null;
//Handle required parameter
query = db.Listings.Where(l => l.Lat >= form.bounds.extent1.latitude && l.Lat <= form.bounds.extent2.latitude);
//Handle optional parameter
if (numStars != null)
query = query.Where(l => l.Stars == (int)numStars);
//Other parameters...
//Execute query (does this happen here?)
var result = query.ToList();
//Process query...
Will this implementation "bundle" the where clauses and then execute the bundled query? If not, how should I implement this feature?
VS 2010 - Stop Execution Of MSSQL Query
Nov 21, 2013i have a complex MSSQL query in my ASP.NET page with rows showing in GridView control.
I want to know what is the best solution for stopping the query if it takes more than X seconds to show in GridView.
DataSource Controls :: How To Handle Error Unhandled Exception Occurred During The Execution
May 31, 2010string connectionstring = WebConfigurationManager.ConnectionStrings["AdventureWorks"].ConnectionString;
SqlConnection con = new SqlConnection(connectionstring);
DataSet ds = new DataSet();
DataRelation dr = new DataRelation("show", ds.Tables["HumanResources.Employee"].Columns["EmployeeID"], ds.Tables["HumanResources.EmployeeAddress"].Columns["EmployeeID"],false);
ds.Relations.Add(dr);
foreach (DataRow row1 in ds.Tables["HumanResources.Employee"].Rows)
{
Response.Write("customertitle:" + row1["Title"].ToString());
foreach (DataRow row2 in row1.GetChildRows(dr))
{
Response.Write("customer add" + row2["ModifiedDate"].ToString());
}
}
Object reference not set to an instance of an object. Description: An unhandled exception occurred during the execution of the current web request. Please review the stack trace for more information about the error and where it originated in the code. Exception Details: System.NullReferenceException: Object reference not set to an instance of an object. Source Error:
[Code]....
Line 31: Line 32: DataSet ds = new DataSet();Line 33: DataRelation dr = new DataRelation("show", ds.Tables["HumanResources.Employee"].Columns["EmployeeID"], ds.Tables["HumanResources.EmployeeAddress"].Columns["EmployeeID"],false);Line 34: //ds.Tables["HumanResources.Employee"].ParentRelations.Add(dr);Line 35: ds.Relations.Add(dr);
Source File: d:databaseDataset showing selected
field of 2 tables.aspx.cs Line: 33
Stack Trace:
[Code]....
[NullReferenceException: Object reference not set to an instance of an object.] dataset__with_two_tables.Page_Load(Object sender, EventArgs e) in d:databaseDataset showing selected field of 2 tables.aspx.cs:33 System.Web.Util.CalliHelper.EventArgFunctionCaller(IntPtr fp, Object o, Object t, EventArgs e) +15 System.Web.Util.CalliEventHandlerDelegateProxy.Callback(Object sender, EventArgs e) +33 System.Web.UI.Control.OnLoad(EventArgs e) +99 System.Web.UI.Control.LoadRecursive() +47 System.Web.UI.Page.ProcessRequestMain(Boolean includeStagesBeforeAsyncPoint, Boolean includeStagesAfterAsyncPoint) +1436
SQL Server :: Show State Of Query Execution In Webpage?
Oct 5, 2010 I have a big query that it execute in 4 minutes. (for example an important trigger)
I want to show situation of query or count of records that is affected in every 10 second in to a web page.
what should I do? (complete explain)
State Management :: Count Query Execution / Where To Store The Counted Value
Aug 25, 2010I have a class that being used to connect with the DB. Now I want to count how many times each web request executes the queries, but I've no idea where to store the counted value. I mean, Session wont, ViewState wont work as site also have webservices. What else I can use?
View 12 RepliesDataSource Controls :: Linq To Entities - Multilevel Projection Into Business Class And Not Breaking Deferred Execution?
Mar 18, 2010I have a problem. (this a simplfied example)
In Entity framework I have a class which is effectively
fooEntity
{
public Guid Id {get; set;}
and a collection of fooChildEntity
}
a fooChildEntity is again an entityframework class
fooChildEntity
{
public Guid kidId {get; set;}
}
Now I also have a pair of business layer classes foo and fooChild
foo
{
public Guid Id {get; set;}
ilist<fooChild> Children {get;set;}
}
fooChild
{
public Guid kidId {get; set;}
}
My aim is to write a linq to entites that will allow me to convert the entity foo and children into the business foo and children without breaking deferred execution ( I will be adding filters to reduce the recordset at a higher coding level in the business layer)
doing something like
this.context.fooEntity
.include(fooChildEntity)
.Select( fe => new foo { Id=fe.Id ,
fe.foreach(fec => Children.add( new fooChild { kidId = fec.kidId}))})
.AsIQueryable()
is plainly rubbish and would never compile - it is however an indication of the direction I was thinking .
Even if I got a foreach to work like that or similar it would break deferred execution
At this point there are around 300,000 foo entities which I will eventualy filter to 5 or 6 foo's - this is why deferred execution is needed.
SQL Reporting :: An Error Occurred During Local Report Processing Query Execution Failed
Mar 29, 2011i am new at reporting service things when i try to create a report i got this error and idea how to fix it
An error occured during local report processing.
An error has occured during report processing.
Qery execution failed for dataset 'ds_testtablosu'
Cannot initialize the data source object of OLE DB provider "MSDASQL" for linked server "MMDB"
DataSource Controls :: SqlDataSource And Parameters Query / Trying To Accomplish Is Building Dynamic Query
Aug 22, 20101. I have a GridView on my page and it uses sqldatasource with parameterized query. What I want to do is, on page load (where nothing has been selected so no parameter supplied), I want it to query everything (something like SELECT * FROM [this_table]) but since my SelectCommand is something like
SELECT * FROM [this_table] WHERE [this_column] = @someParameters AND [that_column] = @someParameters.
Can I play around with default value to achieve something like that but how ? Now, when the page loads, it doesn't show anything (No Gridview).
2. On my page, I made something like (username, gender, address, and more) and one single search button. That means, no single control enable auto postback. What I am trying to accomplish is building dynamic query
(if username specifed -> SELECT * FROM [this_table] WHERE [username] LIKE @username).
If both username and gender are specified (SELECT * FROM [this_table] WHERE [username] LIKE @username AND [gender] = @gender) and you know the rest. How can I do this using GridView and SqlDataSource ? To my knowledge, I can only specify one SELECT statement in a sqldatasource.
DataSource Controls :: Update Query Not Working When Using Query Builder To Configure Table Adapter
Jan 15, 2010[code]...
This query works perfectly on the query analyser.
But when configuring the Table adapter ,I try executing the query and i get 0 rows affected.
What could I be getting wrong in this case.
NB:Existing GalleryID has been supplied.
DataSource 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 RepliesDataSource Controls :: How To Convert Sql Query Into Linq Query
Mar 10, 2010select Groupid,GroupName,onorusername from palgroup where groupid in (select distinct Groupid
View 5 RepliesDataSource Controls :: Accessing FK From A Query Via Entity Query
Jan 21, 2010I've got a query such as
Dim MediaQuery =
From m
In dB.DOWNLOADS _Where m.ID = id _Select
which returns a record from the database. One of the fields in the record is a FK to another table. I need to read this value to be able to set a dropdown based on the ID but I can't work out how to access it. For a standard record I can just do the following txtTitle.Text = MediaQuery.FirstOrDefault().TITLE
However with the foreign key it doesn't work like that. I've tried drpGroup.SelectedIndex = MediaQuery.FirstOrDefault().DOWNLOAD_GROUPS.ID where DOWNLOAD_GROUPS is the FK field but it returns Object reference not set to an instance of an object. If you're simply wanting to read some values from a single db record in the entitiy framework and one is a foreign key how should I go about getting the value?
ADO.NET :: Query Execution / Last Suppose 1000 Mails Queued Then 1000 Times Get Mail Queued?
Feb 15, 2011i am using sql server inbuilt mail system for sending mail.and i made SP to call dbmail sp
now my problem is when i call sp it get executed fine but in last suppose 1000 mails queued then 1000 times i get mail queued.and that my connection time out .i extend connection time out limit but i get error msg like
"Timeout expired. The timeout period elapsed prior to completion of the operation or the server is not responding. Mail queued."
my mail get queued well proper but due to 1000 or 100000 mail queued its lost of msg make problem.
DataSource Controls :: Not Able To Run SQL Query Using If Else?
Apr 21, 2010I am using Querystring "ddl4" to pass on value of a drop down list to the next page where I am using that value in the WHERE clause of a SQL command. I also need to check whether ddl4 is blank or not which I do using If Else in SQL command. I am not able to run the query where the Querystring ddl4 IS NULL
This is the sample link with the Querystring ddl4 carrying a blank value:
[code]....
DataSource Controls :: How To Run Sql Query From Project
Apr 13, 2010I have one query in my project (saved in folder SQLQueryes, Query.sql) and i need to execute it. Also, i have one parameter in script and i need to include him also. How?
View 8 RepliesDataSource Controls :: SQL Query With IF And Select
Feb 18, 2010SQL Query with IF and Select
View 2 RepliesDataSource Controls :: Why We Need Union Query
Jun 10, 2010if there is no relation bettwenn two tables why do i need union for example like below Please
can u inform me
SELECT categoryId
FROM categories
UNION
SELECT shipperId
FROM shippers