User Profile

Collapse

Profile Sidebar

Collapse
ashurack
ashurack
Last Activity: Apr 27 '11, 12:23 AM
Joined: Jan 27 '08
Location:
  •  
  • Time
  • Show
  • Source
Clear All
new posts
  • ashurack
    started a topic Table Design Question - Expecting ~1 Million Records
    in SQL Server

    Table Design Question - Expecting ~1 Million Records

    I'm writing survey software and wanted the data to be vertical. What keys/indexes should I have so queries against the table run as quickly as possible? The fields "SurveyID" and "SurveyGUID " are used for reference. The field "SurveyFiel d" is the name of the question (ex. "Q1", "Q2", etc...) and the field "SurveyData " is the answered value of the question.

    Thanks in advance...
    See more | Go to post
    • ashurack
      started a topic C# Service on client to log in user
      in C Sharp

      C# Service on client to log in user

      Without touching gina.dll, how can I log a user into the console session?

      My environment is a Windows 2003 server and XP workstations.

      I was thinking of creating a service to run on the workstation and listen for a command from a "server" application running on the 2003 machine. My problem is I can't seem to figure out how to programatically log on a user.

      Thanks,
      Alan
      See more | Go to post
      • ashurack
        replied to C# USER Objects Leak (10,000 Limit)
        in C Sharp
        Thanks,

        My problem turned out to be buttons being added to an ArrayList and never being disposed of. It's kiosk based survey software that I didn't write, lots of code to dig through.
        See more | Go to post

          Leave a comment:

        • ashurack
          started a topic C# USER Objects Leak (10,000 Limit)
          in C Sharp

          C# USER Objects Leak (10,000 Limit)

          I'm working on an application that eventually crashes when the "USER Objects" reaches 10,000. I've gone through all the code and replaced:

          Code:
          object = null;
          with
          Code:
          if(object != null)
    object.dispose();

object = null;
          Is there a way to track the objects that aren't being disposed within a class?

          Is there a way to loop through all objects within...
          See more | Go to post
          • ashurack
            started a topic Generic List pass by value?
            in C Sharp

            Generic List pass by value?

            I'm looping throug a DataTable and want to pass a temp List<T> to a class, then clear the temp List<T>, then repeat... Is there a way to do this without passing by reference?

            Thanks,
            Alan
            See more | Go to post
            Last edited by ashurack; Dec 28 '08, 01:42 AM. Reason: More specific
            • ashurack
              started a topic HttpWebRequest and Authentication
              in .NET

              HttpWebRequest and Authentication

              I can't seem to get this to work. The URL I want to access is protected with windows authentication. I thought that was NTLM but the following isn't working:

              Code:
              string url = "http://apps.pgalinks.com/professionals/apps/directories/searchresults.cfm?entity_id=" + Convert.ToString(i);
            HttpWebRequest request = (HttpWebRequest)WebRequest.Create(url);
            request.Method = "GET";
              ...
              See more | Go to post
              • ashurack
                replied to SP Generate Random String - Check if String Already Exists
                in SQL Server
                I appologize... By selecting just the field, it stopps working. I thought it would be a drag on the database by selecting * (all).
                See more | Go to post

                  Leave a comment:

                • ashurack
                  replied to SP Generate Random String - Check if String Already Exists
                  in SQL Server
                  Oops. The SELECT statement to find a record should've been

                  Code:
                  IF EXISTS (select OID --Can't select *...
from datakno_harrisgolf.PurchaseHist
where OrderNum = @password)
set @unique = 0
ELSE
set @unique = 1
                  See more | Go to post

                    Leave a comment:

                  • ashurack
                    replied to SP Generate Random String - Check if String Already Exists
                    in SQL Server
                    Thanks, I'm pretty sure I got it rocking!

                    Code:
                    SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
ALTER procedure [dbo].[GenerateRandomString] (
 @useNumbers bit,
 @useLowerCase bit,
 @useUpperCase bit,
 @charactersToUse as varchar(100),
 @passwordLength as smallint,
 @password varchar(100) OUT
)
As
Begin

declare @unique int
set
                    ...
                    See more | Go to post

                      Leave a comment:

                    • ashurack
                      started a topic SP Generate Random String - Check if String Already Exists
                      in SQL Server

                      SP Generate Random String - Check if String Already Exists

                      I found a stored procedure online a while back and want to inplement it. The only problem is that it doesn't check to see if the number generated is currently in use in the DB.

                      I know it's really unlikely for the same number to be generated twice (with a 10 digit number) but it's for a shopping cart so I need it to be 100% reliable.

                      I thought about opening a cursor then looping through each distinct record in the...
                      See more | Go to post
                      Last edited by ashurack; Jan 27 '08, 05:31 PM. Reason: Bad Title
                      No activity results to display
                      Show More
                      Working...