Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations derfloh on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  • Users: whool
  • Order by date
  1. whool

    Inexplicably Long running update query

    Actually the Est. Execution plan says that the ContactID clustered index under the donations view is used...however I guess if the index is fragmented your argument would to some extent hold true as this would also result in additional page reads. In any event I'm going to stick with the 2...
  2. whool

    Inexplicably Long running update query

    That was actually what I tried first but you cannot use aggregetes in UPDATE statments, viz. Server: Msg 157, Level 15, State 1, Line 2 An aggregate may not appear in the set list of an UPDATE statement. There are indexes the contactid fields of both tables. Thanks anyway SemperFi, Yael :-)
  3. whool

    Inexplicably Long running update query

    The following update query is taking a long time to complete - (the longest it has run is 20 minutes before being stopped.) UPDATE SelectedContactsTbl SET SumDonations2 = (SELECT sum(DonationValue) FROM MailManNonProf.dbo.donations d WHERE SelectedContactsTbl.ContactID =...
  4. whool

    Temp DB locking prob

    Thanks Iker, I actually got round the prob by putting an index on INVSwitchTransvalidtbl.JobID. Not exactly sure why this was required, it still should have run without the index, albeit slowly. The JobID datatype is uniquidentifier, perhaps it was a quirk of that datatype. Re the the JOIN...
  5. whool

    Temp DB locking prob

    How's this for weird. The following query is times out. While it is running an exclusvie Extent lock is created in temp db which doesn't let go. SELECT jobid FROM INVSwitchTransvalidtbl WHERE JobID IN (SELECT JobID FROM INVJobsTbl WHERE periodid = 23) If i use a differnet periodid in...
  6. whool

    DTS Ouptut parameter prob

    SQL 2000, I am trying to pass an Output param from a Stored Proc (using Exec SQL Task) to a DTS global variable. This is the SQL task: declare @retval int execute @retval = dbo.usp_test select @retval as rv I am able to map the parameter to a Global variable and the SQL task works OK but...
  7. whool

    DTS package data import fails when converted to VB

    SQL 2000, VB 6 I have a DTS package that imports a text file and inserts rows into a DB table; two separate tasks on the same database. I can run it fine from Enterprise manager. However when I convert it to VB (and add the DTS reference) I find that the Insert task is successful but the...
  8. whool

    Major perfomance difference when batch inside Transaction

    The following batch aggregates records in one (INVSwitchTransValidTbl)and inserts the aggregates in table INVJobsTbl. It then gets the GUID created for the Jobs records and updates the records in INVSwitchTransValidTbl which formed the aggregates. The script takes about 30 seconds to process...
  9. whool

    <b>Prob setting up linked Server for a Jet DB on a remote server</b>

    Using SQL2000 on a Win 2000 network environment, I am trying to connect to an Access DB located on a different machine by adding it as a linked server. The linked server appears to be created but when I try to access the linked server's tables folder (using Enterprise Manager) I get an...
  10. whool

    Field Defaults not used on DTS import

    No problems with Bulk Insert - works fine. But I cant do data transformations with Bulk Insert. Thanks anyway. Yael
  11. whool

    Field Defaults not used on DTS import

    I am importing a CSV file to a DB table using DTS.(SQL 2000) The destination table has defaults set for all NOT NULL fields. Eg Create Table TableName ( field1 ... , field2 ... , CustomerExists bit NOT NULL DEFAULT 0 ) I find that when a NULL is encountered in the import file, rather than...
  12. whool

    Queries accross multiple DBs on the same server

    many thanks Terry. Yael
  13. whool

    Queries accross multiple DBs on the same server

    I want to create a select query that joins two tables from two differnent Databases residing on the same instance of instance of SQL Server 2000. Is there any way of doing this other than setting up one of the Dbs as a linked server? Yael
  14. whool

    Problem querying Linked Server on Access DB

    Im running SQL 2K. Have created a Linked Server for an Access database. This seems ok in that i can see the tables listed under the linked server in Enterprise mangager. However when I go to run a select query for the Linked DB I get Server: Msg 7357, Level 16, State 2, Line 1 Could not...
  15. whool

    This newbie is still confused!

    Easiest way to start is by opening Enterprise Manager. Once you have registered the the server in a Server Group you can easily create a new DB by going to the Databases branch on the tree and right clicking. Once done you can right click on the Database you've created to add tables etc. Its...
  16. whool

    Determining Cache-hit ratio

    I am trying to determine the cache hit ratio a server running SQL2000 on Windows 2000. When I use DBCC Perfmon command in Query analyser I get a ratio of 99.999. However, when using the Cache-Hit counter through NT's Performance monitor the ratio is around 65.00. Which am I to believe? The...
  17. whool

    Weirdness when Geting property value on a form object

    Understood. Thanks CCLINT.
  18. whool

    Weirdness when Geting property value on a form object

    In this small test app there are two forms. The first from creates an instance of the second form then opens it: Private Sub Command1_Click() Dim f as New Form2 f.show End Sub The second form (Form2) has the following code: Private m_Regionid As Integer ______________________...
  19. whool

    No Key propery for Combo box -Help required with an alternative

    Thanks JohnYingLing, The paralell array sounds a good solution...quite obvious really. Cheers, Yael
  20. whool

    No Key propery for Combo box -Help required with an alternative

    Thanks Rob but this solution only works for integers. The keys I need to store are GUIDs (38 character strings)

Part and Inventory Search

Back
Top