User Profile

Collapse

Profile Sidebar

Collapse
trd79
trd79
Last Activity: Nov 30 '09, 05:22 PM
Joined: Apr 9 '08
Location:
  •  
  • Time
  • Show
  • Source
Clear All
new posts
  • trd79
    started a topic Best way to index a mostly static database
    in SQL Server

    Best way to index a mostly static database

    Hi,

    I am extracting data from an operational system in order to maintain a mirror that can be used for reporting.

    I have two means of filling this database:

    1) A stored procedure which truncates all tables and rebuilds everything from scratch. This takes about an hour and will be run periodically.

    2) A stored procedure that updates my database with the previous days activity which will be...
    See more | Go to post
    • trd79
      started a topic binary data in char field
      in SQL Server

      binary data in char field

      Hi,

      I am trying to extract data from a legacy system. For reasons best known to themselves, the developers have stored what looks like binary data in a char(6) field. Within SQL Management Studio the field looks like a line of small squares.

      How can I go about displaying this as a hexadecimal string?

      (I have attached a screenshot)

      Many thanks....
      See more | Go to post
      • trd79
        started a topic Ignore exceptions when parsing XML
        in .NET

        Ignore exceptions when parsing XML

        Hi,

        I am using C# to parse some XML which has been generated by another system.

        Have loaded data into an XmlDocument and am then using GetElementsByTa gName and SelectSingleNod e to get the XmlNodes I need.

        My problem comes when I try to access an empty xml node like this <Field /> (instead of <Field>Some Data Here</Field>).

        When getting the data using xmlnode.SelectS ingleNode("Fiel d").FirstChild. Value...
        See more | Go to post
        • trd79
          replied to Counting instances in c# (keeping a tally)
          in .NET
          Hi,

          Have tried using a hashtable as suggested.

          Currently looks like this (and seems to work)

          Code:
          Hashtable sessions = new Hashtable();
while (dReader.Read())
        {
            DateTime date = DateTime.Parse(dReader[0].ToString());
            sessions[date] = (sessions.ContainsKey(date)) ? (int)sessions[date] + 1 : 1;
        }
          Is this the best way of doing...
          See more | Go to post

            Leave a comment:

          • trd79
            replied to Counting instances in c# (keeping a tally)
            in .NET
            Many thanks,

            will try that....
            See more | Go to post

              Leave a comment:

            • trd79
              started a topic Counting instances in c# (keeping a tally)
              in .NET

              Counting instances in c# (keeping a tally)

              Hi,

              I am reading a database which is returning a list of dates. I need to count the instances of each date and store in an array or similar.
              I don't know how many dates I will be getting, or how many different ones.

              In Perl I would so something like this
              for(`getdata`){
              $array{$1}++;
              }

              need something that looks like this:

              while (dReader.Read() )
              ...
              See more | Go to post
              No activity results to display
              Show More
              Working...