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 Chriss Miller on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Recent content by TomSark

  1. TomSark

    How do you use stored procs to filter data?

    Why don't you simply create one proc that builds the sql statement you are executing into a varchar variable, then use the EXECUTE statement to run it? You would dynamically build the where clause based on the parameters you pass into the proc. Ex: CREATE PROCEDURE new_proc (@ReportType...
  2. TomSark

    Adding Commands in DSO eats up memory

    Have you looked at the hotfix for this: Hotfix build 8.00.0601 ftp://ftp.microsoft.com/bussys/sql/transfer/sql80/olap/s80601i.exe Password: 8.00.0601 Please follow the setup instructions in readme.txt Tom Davis tdavis@sark.com www.sarkdallas.com
  3. TomSark

    ASP->COM->OLAP

    Ok fine, I'll answer my own post. We have worked with Microsoft and have made a few determinations. Do NOT issue VBA function calls in MDX queries. The Analysis Services parser serializes the sections of the queries (with then select then from then where). This serialization in itself is a...
  4. TomSark

    ASP->COM->OLAP

    Hi, SQL 2000, SP2, etc. We are issuing MDX queries via a COM+ object in an ASP application using ADO (not ADOMD). We are noticing major CPU spikes when the component issues MDX queries to the cube. Analysis services reports that queries aren't consuming any time. NICs are OK. We are the only...
  5. TomSark

    Getting rid of Eager Spool

    BTW... the stats have been computed with full_rescan... Tom Davis tdavis@sark.com www.sarkdallas.com
  6. TomSark

    Getting rid of Eager Spool

    Hi All, Does anyone know how to get rid of an Eager spool in a query plan? I've got an INSERT SELECT and SQL Server has determined to spool the clustered index on the inserted table to tempdb (using the eager spool step). This is slowing the query way down. I don't want to drop the index...
  7. TomSark

    Coinitialize has not been called ?!@$%^?!

    Looks like a problem with the COM interface (SQL Namespace, SQL DMO, something else?). Coinitialize is a COM method. You may need to reinstall EM. Tom Davis tdavis@sark.com www.sarkdallas.com
  8. TomSark

    Conditionally include a WHERE clause

    I'm missing something here, but I'm guessing that you want to join the ID in a real table to the ID in a temp table, you could try: IF EXISTS ( SELECT R.ID FROM RealTable R INNER JOIN #tblIDs T ON R.ID = T.ID AND R.Amount > 0 ) BEGIN...
  9. TomSark

    select

    Try using brackets arounf the column name as in: SELECT [propnumber] FROM tablename Tom Davis tdavis@sark.com www.sarkdallas.com
  10. TomSark

    Problem with Application Role

    What is the owner of the proc and the table? Tom Davis tdavis@sark.com www.sarkdallas.com
  11. TomSark

    DTS import problems access 97 to SQL 7

    If you are having trouble with a date format, you could easily write an active-x transformation in vbscript that deals with this in your DTS package. You could also set up a linked server to your access database and do something like this: INSERT MYNEWTABLE ( GoodDate ) SELECT...
  12. TomSark

    Request for Advice on SQL Server + Incoming Email

    Check out the capabilities of SQL Mail. SQL Server can respond to queries via e-mail and send the results in e-mail as well.. Tom Davis tdavis@sark.com www.sarkdallas.com
  13. TomSark

    Truncating Transaction Logs.

    BACKUP LOG DBNAME WITH TRUNCATE_ONLY will only remove the inactive portion of the log. The active portion cannot be truncated. And, if you are using an earlier version of SQL Server like 7.0, you may have to fill up a virtual log segment before you can truncate that virtual log. Tom Davis...
  14. TomSark

    ACTUAL SQL TRACING

    SQL 6.5 has a SQL Trace utility... Tom Davis tdavis@sark.com www.sarkdallas.com
  15. TomSark

    deleted and inserted tables

    And... @@rowcount WILL contain the count of the rows that were deleted when your trigger code begins. I usually set a variable to it in the beginning of the trigger before I have any other code so I don't have to query for the rowcount as stated above... If at all possible, avoid coding...
See more

Part and Inventory Search

Back
Top