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 Rhinorhino 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: jepatte
  • Content: Threads
  • Order by date
  1. jepatte

    Adding a new column

    I have a table with 2.5 million records and I want to add a new column to it in a certain place. I would normally do this in design view in Enterprise Manager, but with my table of this many records, it takes literally 30 minutes to save a 1 byte column. When I do this with "ALTER TABLE"...
  2. jepatte

    necessary index

    What is the rule of thumb for creating an index on a Y/N column. I have a table with 15 char(1) fields with the possible value of Y or N. My table has 2.5 million records. I need the ability to filter by any of these columns either by Y or N and sometimes other criteria regarding other...
  3. jepatte

    temp tables in sproc problem

    I need to create a temp table in a sproc but I an getting a strange error. --------------------------------------- CREATE PROCEDURE [dbo].[sp_UpdateTotalsAgePrecinct] ( @fromAge as Integer, @toAge as Integer ) AS IF @toAge > 0 SELECT NCOACounty, NCOAPrecinct INTO #tmpPrecinctAge FROM...
  4. jepatte

    very fast queries

    I have a site that has voter information for a state. There are over 2.5 million records in the main table with 50 fields. This site allows users to choose many different filters to get counts. ie. Race, Age, Gender, Vote history, etc. No matter what my indexes are, it still takes anywhere...
  5. jepatte

    update sql and can't view record

    I sometimes do a mass update in Query Analyzer. ie. Update t1 Set f1 = 'Y' WHERE f1 = 'Yes' If this is a very large dataset and can take 3 or 4 minutes, my web application that reads this same table can't view a single record while this update is going on. It will timeout if I just want to...
  6. jepatte

    SQL - ASP Timeout

    I have a site where users can search voter records and then download results into a csv file. If the search is very large, ie. 150,000 records, obviously it takes a while to process (20-30 seconds or more). If someone else comes to the site at the same time and does a download, sometimes they...
  7. jepatte

    sites with download from sql

    I have a site where users can search voter records and then download results into a csv file. If the search is very large, ie. 150,000 records, obviously it takes a while to process (20-30 seconds or more). If someone else comes to the site at the same time and does a download, sometimes they...
  8. jepatte

    get age function

    I have a table with 2.5 mil records and one field is their birthdate. I want to run queries based on their age. I have a GetAge function I am using that accepts their birthdate and another "as of" date parameter (the current date most of the time). I have an index on this birthdate field and...
  9. jepatte

    updates affecting indexes

    I have puzzled by this for a week now. I have one SQL database that has been doing great. I have a table that has 4 indexes on it and the speed is top notch. In a completely separate database on this server, I have been doing mass updates. ie. UPDATE t1 SET f2 = 'Y' WHERE f2 = 'X' etc. These...
  10. jepatte

    SQL Server speed and index

    I have to run an update on 2.5 mil records and it takes forever even when I have an index built. We have a server with 4GB memory and we allocate SQL Server to use 1-2 GB. When I run an update like this, its bizarre, it actually slows down the other databases. ie. I have another completely...
  11. jepatte

    SQL indexes

    I have a table with 2.5 mil records and one field is a varchar 50 which I have an index on. Although, I need to run a query to append some text on the values in this field. But this takes over an hour to run. Is this normal?
  12. jepatte

    Too many indexes

    I have a large data table with about 2.5 mil records with 60 fields. I have a web application reading this table so users can fiter, query on many fields, maybe 20 to 30 different fields. Two fields are Race and Gender, since they will be querying on these two fields, I assume I need to create...
  13. jepatte

    SQL Index question

    I have a table with 2.5 million records. One field either has Y or N in it. Do I need to create an index on this field if I want to query on it. If I don't, it usually take 20 or 30 seconds to return results. The thing is that I have a lot of fields like this. If I do this for all these...
  14. jepatte

    SQL DTS encrypted ?

    If I have a DTS package that transfers data from one server to another using the Import/Export transfer, is this encrytped or is it a clear text transfer?
  15. jepatte

    SQL DTS Import

    I need to create a package that imports a text file into a table. Here's the trick...I need it to be dynamic so that one day, I can read 001.txt and the next day, 002.txt, so on. I will do this by reading a table. I'm just not sure if I can create a package that does this.
  16. jepatte

    ADsDSOOBJECT ldap using 636

    I have been using ADsDSOOBJECT adsi to authenticate a user with ASP. It works great. Now I want to connect to using LDAPS or port 636 (anyway that's secure). I currently use.... <LDAP://myserver.com/o=myroot>;(cn=" & vUsername & ");adspath,cn;subtree...
  17. jepatte

    IIS 5 subweb domains

    We have an website with quite a few directories. We would like to turn one of these dirs into a subweb so that we can create a domain name that points to this directory. How can this be done in IIS?
  18. jepatte

    RequiredFieldValidator display

    I want to use the ValidationSummary object, but I want the "asterisk" to appear when the page first loads. I have the validate function called, but it doesnt show the "asterisks". Is there something special when using ValidationSummary?
  19. jepatte

    SQL 2005 job connecting to remote

    I have a SQL Job running in SQL 2005. This job has 6 steps. In one of the steps, I SELECT from a View. This View is pulling data from a different server. When we login as sa and run queries manually, we can pull the data just fine. When we try to do this in a job, it fails, because of the...
  20. jepatte

    Compare table1 to table2

    I have a Table1 with 3 fields, lastname, firstname, zipcode Table2 has the same. I want to insert records into Table1 if they are in Table2 but not already in Table1. So is the best way to see if they exist is do a concatenation.... INSERT INTO T1 (LName, FName, Zip) SELECT LName, FName, Zip...

Part and Inventory Search

Back
Top