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!

Search results for query: *

  1. scotward

    Processor Use

    Our server has 4 processors. Long running queries will use all of them until they finish, effectively preventing other users from retrieving data during that time. Is there any way to configure SQL Server 2000 to restrict processor usage?
  2. scotward

    Composite Indexes

    I have read that "every table should have at least one unique clustered index". I have also been told that if a column is a member of a comopsite index, queries that group or have 'where' clause on that column will not perform as well as if that column were indexed independently. So...
  3. scotward

    Can't Insert Data

    I run a monthly DTS job that loads the contents of a text file into a temp table, then an insert query does some simple manipulation of the data and passes it to a cumulative table. Each of the tables resides in a different filegroup on a different drive share. During my last update, the insert...
  4. scotward

    Backups and the Transaction Log

    Thanks for your help. Sorry for using the wrong thread.
  5. scotward

    Backups and the Transaction Log

    We currently run a weekly full backup and daily differential backups using Veritas. The problem we are having is that the transaction log will only truncate following a full backup. We are going through a rapid growth phase where the log grows by as much as 50GB per day. Disk space on our server...
  6. scotward

    Moving Database

    Thanks for you help. It seems that the only way to do it is the individual save as, changing the server designation. We had about 50 DTS to move, so I was hoping to do it with one copy.
  7. scotward

    Moving Database

    I have moved our SQL Server 2000 databases to a new server. Is there a way to move the DTS packages as well or will I have to re-create them?
  8. scotward

    qag7a.tmp

    Thanks so much. I really feel stupid. I must have hit the show as text tab earlier and never put it back.
  9. scotward

    qag7a.tmp

    I was running a long query (in SQL Query Analyzer) today and after about 40 minutes, a temp file (qag7a.tmp) appeared on my pc. It seemed as though SQL server was using my local processor (processor was at 100% in the task manager). The temp file quickly used up all available disk space and did...
  10. scotward

    Disable tempdb?

    Thanks, Terry. I agree completely. The queries are just selects, but not all of the joined fields are indexed. I'm sure that has a significant impact. Considering that the purpose of the queries is to validate data in a new table (they won't likely be used again), I didn't want to invest the...
  11. scotward

    Disable tempdb?

    That's what I asked. There are some long running queries that are using all of the available disk space (yeilding an error: log file for temdb is full). I wanted to point temmplog.ldf to a larger disk (it only has 5GB available on the current disk), but our dba insists that it would be better...
  12. scotward

    Disable tempdb?

    I was told that it may be possible to run a query without using tempdb. Is this true? If so how is it done.
  13. scotward

    composite indexes

    If I have tables joined on two columns in each table, what is the advantage of using a compostite index as opposed to indexing each column individually?
  14. scotward

    Redundant Index?

    Table 1 (1.3 million rows): Primary key is comprised of three colums (customer, date, item) and I have set this up as a clustered index. There is also a salesperson field that is not indexed (yet). Table 2 (50,000 rows): Primary key is comprised of two columns (salesperson, customer). These...
  15. scotward

    SAS -> ODBC????

    Did you ever figure this out? I am having the same problem.
  16. scotward

    Updating SQL Server Table Using Access

    I want to allow some of my users to update fields in an SQL Server 2000 Table using an ODBC link through MS-Access 2000. I have assigned the appropriate permissions in SQL server, but when I try to edit the table in access, it still says "Record Set Not Updateable". Have I forgotten...
  17. scotward

    Can only log on once a day

    I can only log onto my network once a day. Once I log off, the server will not recognize me until it has been rebooted. This only happens with one workstation that is running win 2000 server. All other workstations run win 2000 pro and have no trouble. Has anyone seen anything like this? My...
  18. scotward

    Error: Snap-In failed to Initialize

    I am getting the following error when I try to open Enterprise Manager. Snap-In failed to Initialize. Name: SQL Server Enterprise Manager CLSID: {00100100-1816-8EFS-00AA0062C58F} Is anyone familiar with this?
  19. scotward

    SQL Server 2000 Performance

    Thanks. I think you answered my question. We haven't decided on hardware yet. The prototype currently recides on a desktop and runs quite well. It sounds like you are saying that performance issues can be managed through hardware considerations and database configuration. Basically, SQL server...
  20. scotward

    Buying an External Hard Drive

    I am buying an external hard drive for my laptop. What is the best type for perfomance (USB, PCMCIA, ???)?

Part and Inventory Search

Back
Top