Search results for query: *

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"...

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...

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...

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...

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...

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...

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...

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...

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...

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...

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?

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...

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...

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?

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.

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...

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?

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?

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...

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...