Query takes more time from user interface or in a network

SQL Server Database Engine

Index ‹ SQL Server

- Previous
  - 1
    - Does file connection manager not work offline? Yes Rafael, You are right when working offline we donot expect connections to work,even i do not. But any other connection manager does not give you this error when we run the package. Let me explain with a scenario: Suppose we have a oledb connection ( for our source and destination DB) and a file connection for our log file and all the connection string is being provided by package configuration file.Given work offline as true and delayValidation is also true. Now if we run the package, all other connection managers pick connection string from the package config file but the file connection gives error as " it cannot acquire connection while working offline ." Now this sounds little wired to me as all the connection manager can acquire connection while working offline and file connection cannot. Tag: Query takes more time from user interface or in a network
  - 2
    - run MDX query in SQL Server Agent issue Thanks for the response. Following are the job step set up. We created a new job and new step. step name:testcube Type: SQL Server Analysis Services Query Run as: SQL Agent Service Account server: my_server_name database: mycube commond: CREATE GLOBAL CUBE mycube Storage 'C:\DW\cube\monthly\mycube.cub' FROM [mycube] ( MEASURE [mycube].[Count Orders], DIMENSION [mycube].[All Languages], DIMENSION [mycube].[All Order Methods], DIMENSION [mycube].[All Periods], DIMENSION [mycube].[All Products], DIMENSION [mycube].[All Reasons] ) The message is entire error message which I can see, but seems already truncated. Am I missing something Thanks. Tag: Query takes more time from user interface or in a network
  - 3
    - Connection path OK on device, not on desktop Thanks for the help. I'm very new to .Net so I don't know about the PocketPC constant. Is it used by compiler directives I haven't found anything in the help about compiler directives. Because my library is for the compact edition, and Assembly.Location is not available to the compact edition, I get the compiler error: 'System.Reflection.Assembly' does not contain a definition for 'Location'. I presume this expected until I use the PockedPC constant properly. But I did find something called a conditional compilation symbol (value is "Smartphone"). Compiling without it didn't seem to make a difference though. Could you give a more complete example, or point me to something to read Sorry, but I'm a bit lost. Tag: Query takes more time from user interface or in a network
  - 4
    - Problems With OLE DB Command Transformer Thanks. One more question - Do you have to use (i.e. scope = ) for the parameters in the SQL statement or can you use something that is more meaningful Tag: Query takes more time from user interface or in a network
  - 5
    - Print each tables in new page Options Thanks for the reply. I forgot to mention one point. I have set visibility property on tables. Will this visibilty property affects how pages are printed Regards, Tag: Query takes more time from user interface or in a network
  - 6
    - All my money in dollars please?? Everything is United Kingdom (except SQL Server Properties (installed language is English US but i have set login def language to British English (as fas as i was concerned that should be that) but still dollar signs and american date formats Tag: Query takes more time from user interface or in a network
  - 7
    - Using Xcopy to get the .mdf file of pubs database to the App_Data folder of a website of VWD Express project Hi Arnie, Thanks for your valuable response. (1) I tried to do the "Using SSMSE, right-click on the database and select [Tasks], then [Detach]. " as you instructed. First I saw the following: Detach Database Select a Page Script Help General Database to detach: Database Name Drop Connection Update Statistics Keep Full Text Catalog Status pubs | | | | |V| Failure |OK| |Cancel| After I clicked the |OK| button, I saw the following message: Microsoft SQL Server Management Studio Express X Detach database failed for Server 'myComputer\SQLEXPRESS'. (Microsoft.SqlServer.Express.Smo) Additional Information: -> An exception occurred while executing a Transact-SQL statement or batch. (Microsoft.SqlServer.Express.Connection) -> EXECUTE permission denied on object 'sp_detach_db', database 'mssqlsystemresource', schma 'sys'. (Microsoft SQL Server, Error:29) I do not know how to handle this problem. Please help and tell me what I should do to get the "Detach" thing works. (2) I have 2 more questions to ask you about the instructions you gave me in your last response: (i) If I detach the pubs in SSMSE suscessfully, I can do ".... You can now copy or XCopy the mdf file (and the ldf file) to whereever you desire. Again, using SSMSE, right-click on [Databases] and select [Attach]. Follow the prompts to locate the mdf file in its new location." Do I understand your above instructions correctly (ii) I think that "....You can now copy or XCopy the mdf file (and the ldf file) to whereever you desire...." in the (2) (i) step is "XCopy" not the regular copy. Am I right on this matter Sorry to ask you the above damn questions. Please kindly respond again. Many Thanks, Scott Chang Tag: Query takes more time from user interface or in a network
  - 8
    - error column Hi, There is an error output from one oledb destination which causes error to another which populated a table called tblFailedRows. I have mapped the errorcolumn to the errorcolumn in tblFailedRows. When looking at the errorcolumn in tblFailedRows I see just numbers not the column name. How do I get the column name that causes the error Thanks Tag: Query takes more time from user interface or in a network
  - 9
    - job failed om the sql server Hi everyone, If more info is need i'll be happy to give... Thanks. Tag: Query takes more time from user interface or in a network
  - 10
    - Cannot shut down VS after using report designer Myself and a number of colleagues are having the same error come up. We are only able to shutdown the visual studio by going to task manager. Still trying to find the cause, but if anyone else knows anything more Tag: Query takes more time from user interface or in a network
  - 11
    - Report Header woes I am pretty confident there is still no solution to this. I actually faked a multi column report by manipulating the dataset I was pulling across, but this was a failry specific situation where I knew approximately how many rows were always being returned. Tag: Query takes more time from user interface or in a network
  - 12
    - Dynamic SQL and sp_executesql So i can't pass OR LIKE AND in the @searchWord parameter Tag: Query takes more time from user interface or in a network
  - 13
    - Service Broker "TO service could not be found" Message origin: "Transport" OK, I thought you might be onto something that I missed. While that may have been a problem - it didn't fix the issue. I still get the same message in Profiler on the target machine and no reasons in the transmission_status (empty). Any other ideas...anyone Tag: Query takes more time from user interface or in a network
  - 14
    - Where clause in a SET I have a dimSalesType with a measure [Sales Type] which holds the type of sales transaction. I want to limit my data set for ranking to different sales types. I'll write a different report for each sales type (there are only 3 or 4 sales types). SET [Ordered Customers] as ORDER ( NONEMPTY ([Dim Customer].[Name].[Name]. members ,[Measures].[Sales] * [Dim SalesType].[SalesTYpe].&[Sales}), [Measures].[Sales], BDESC ) Would that work Tag: Query takes more time from user interface or in a network
  - 15
    - Can i set somehow the package to have the components automaticaly updated? Help ... i'm lost I have one custom dataflow component in assembly A with version 1.1.0.0 used in many packages. The component is now in assembly A with version 1.2.0.0 but not changed. There is aniway to have those packaged configured in order to automaticaly be upgrated to use the new version of the component I tried (in this order): - set the property "UpdateObjects" to true on package (while version 1.1.0.0 was available in GAC) and saved package. - unistalled the version 1.1.0.0 from GAC. - tried to reopen package with "Reload and Upgrade" option. NO SUCCESS I know that can be an brute way to do it, meaning replace as text in xml ... but i try to find a solution not this stupid "workaround" Many thanx for any suggestions! Catalin PS: Excuse my english. Tag: Query takes more time from user interface or in a network
  - 16
    - Table transfer errors Hello Jamie, Unfortunately I cannot share my companies data, however I did discover that none of the primary keys were carried over to the tables that were successful. I am transfering over 300 tables and all are successful accept 1 table. As is said the primary keys are not being carried over, so maybe this is a clue as to why this is happening... Tag: Query takes more time from user interface or in a network
- Next
  - 1
    - Packege success, despite task failure Where do I find 'Maximum Error Count' and 'Force Execution Result' Tag: Query takes more time from user interface or in a network
  - 2
    - Can i host a SQL2005 EE DB on SQL2000 engine ? The SQL team just released a Database Publishing Wizard that might meet your needs. The wizard makes it easy to script out your development database, even directly from VS. You can then run the script on your hosted site to recreate the database and the data. You should be able to run the script on both 2005 and 2000 systems. You can find a tutorial on using the wizard in this blog post along with a link to where you can download the wizard. Mike Tag: Query takes more time from user interface or in a network
  - 3
    - Incorrect processing order for views While this is not a fix for your problem it might help you out for a while. You can schedule a script to run before the snapshot is extracted onto the subscriber. In the script you could create your troublesome view. That way it will automatically create the view everytime someone is added. Not the solution but maybe a workaround. Martin Tag: Query takes more time from user interface or in a network
  - 4
    - Unable to read local eventlog (the parameter is incorrect) We have a tracking bug for this and is planned to get fixed in the next public release. Thanks, Gops Dwarak This posting is provided "AS IS" with no warranties, and confers no rights Tag: Query takes more time from user interface or in a network
  - 5
    - Database Blobs & Performance if you don’t select the image / binary column there should be no performance issue. Jens K. Suessmeyer. --- http://www.sqlserver2005.de --- Tag: Query takes more time from user interface or in a network
  - 6
    - How to extract domain name from an email address?? Close, but that still includes .com Code Snippet declare @email varchar(50), @domain varchar(50) set @email = 'johndoe@whatever.com' set @domain = substring(@email, charindex('@', @email)+1, charindex('.', @email) - (charindex('@', @email) + 1)) print @domain Chris Tag: Query takes more time from user interface or in a network
  - 7
    - problem connecting Remote Analysis service 2005 from vb.net 2005 Specifying server name in the connect method throws error "A connection cannot be made. Ensure that the server is running." i verfied surface area configuration for Allowing remote connection everything is ok, but still i am not able to connect to server. is there any other way to process the server cube from the client machine Tag: Query takes more time from user interface or in a network
  - 8
    - select inside update query? Is it possible for me to do something like update table1 SET var1=something,var2=something2 from table1 (SELECT * from table2) as newtable where newtable.field1=acondition Tag: Query takes more time from user interface or in a network
  - 9
    - SSAS processing Just a guess... if you have multiple databases, changing the connection manager won't cause the Analysis Services Processing Task to target a different database because the database ID is hardcoded in the XMLA that's saved when you configure that task. https://connect.microsoft.com/SQLServer/feedback/ViewFeedback.aspx FeedbackID=251934 As for troubleshooting, I would echo Darren's suggestions. Tag: Query takes more time from user interface or in a network
  - 10
    - Schema (owner) Names Not Visible In Shapes On Diagram Moved to SQL Server Forums. Tag: Query takes more time from user interface or in a network
  - 11
    - Select Statement Problem? You have a table that has not been 'normalized', and as you can easily determine, it will often be difficult to work with. You would be far better off to have only one Telephone number column -adding as many rows per individual as needed. For the purposes of your 'exam', here is one suggested solution: SET NOCOUNT ON DECLARE @MyTable table ( RowID int IDENTITY, [Name] varchar(20), Telephone1 varchar(20), Telephone2 varchar(20) ) INSERT INTO @MyTable VALUES ( 'ian', '1234567', '7654321' ) INSERT INTO @MyTable VALUES ( 'Sean', '1111111', '2222222' ) SELECT [Name], Telephone = Telephone1 FROM @MyTable UNION SELECT [Name], Telephone2 FROM @MyTable Name Telephone -------------------- -------------------- ian 1234567 ian 7654321 Sean 1111111 Sean 2222222 Tag: Query takes more time from user interface or in a network
  - 12
    - MS SQL2005 express ed + SSIS installation problem I have tried to find any of these severs in msdn2 and nothing found. Where I can download developer or enterprise edition from strange.. Tag: Query takes more time from user interface or in a network
  - 13
    - Problem in MDX query for calculating total sales. thanku very much Irina .It wrked exactly the way i wanted !! Tag: Query takes more time from user interface or in a network
  - 14
    - help enabling FTS in multiple database Also, Could you please tell us: 1. how much RAM does the box have 2. Are there other SQL instances active on the box 3. Under the Memory Performance Object under PerfMon what is the Available Mbytes that you see during the problem period 4. Does the following command on th database also fail: USE <db name> EXEC sp_fulltext_database 'enable' Thanks. Tag: Query takes more time from user interface or in a network
  - 15
    - Dervied Column - Expression? Is there a way to put SQL queries in a user variable I am just trying to figure out, whats the best way to do this Can someone please advise. Thanks. Tag: Query takes more time from user interface or in a network
  - 16
    - How Do I Hide Internet Explorer Menu and Tool Bar I have a report generated by SQL Reporting service from another program, I just want the Internet Explorer Menu and tool to be hidden so that the user could not navigate to another site. Tag: Query takes more time from user interface or in a network

aashirwad

I execute a pretty big sql query which joins multiple tables and I reviewed indexes on all these tables. I am happy with the result when I run the query using SSMS in the server locally i.e., where my SQL Server database is installed. It takes 4 seconds to get around 17000 records. If I run the same query in a network or from my desktop using SSMS i.e., i connect to the above mentioned SQL Server using SSMS, it takes more than 60 seconds. Not sure how to solve this. If someone could help me, it will be of great help.

Thanks.

Top

Re: Query takes more time from user interface or in a network

mrdenny

Is the server local to you or installed in another office

When you run the query on your machine enable the Client Statistics (second row of buttons at the top, next to the Actual Execution Plan button). What is the output from this

Top