Search results for query: *

Hi, I've been reading a bit about the using statement. ie using (TextWriter w = File.CreateText("log.txt")) { w.WriteLine("This is line one"); } My understanding is that this code will call the Dispose() method of w at the end of the using block. None of my previous code has ever...

I have a database that is storing historical data. It actually consists of two databases. There is a transactional database that contains all the current records, and then a historical database that contains all records over all periods of time. It is set up as follows Transaction DB table...

Hi, I have been working as a contractor for an engineering company and now they want to hirer me into the software department where I will become the department head. Of course, the 'department' currently only consists of me, and one other programmer. The problem is the company I work for is...

I have a web app that is running from a SQL Server 2005 database. Periodically, the app generates a timeout error, but if I run the command from management studio, it takes less than a second. Furthermore, the timeout error appears to happen randomly and does not occur with only a specific...

I have to build a program that does two things. First, it must have interaction from users to save the current state or roads and road conditions. This involves linking to weather conditions tables, predefined deficiencies, etc. Data can not be deleted from the database and it must allow...

While this may not sound like a very good design practice, I am just curious on how this would affect performance. Suppose I have 10 - 30 columns in a data table. Almost always, data in some of the columns will be null. Alternatively, I could have just one XML column, and only fill it with...

Suppose I have the following situation table 1 col1: Table1ID INT Primary key col2: FK_Table2ID INT table 2 col1: Table2ID INT Primary key col1 in tables 1 and 2 are the primary keys so they are already indexed. If I want to join table 1 to table 2 (on FK_Table2ID = Table2ID), will having...

This post is an extension of my post http://www.tek-tips.com/threadminder.cfm?pid=183&page=2 I want to pivot data but I don't think I want to pivot it in a method that follows SQL's PIVOT/UNPIVOT transformation. Basically, suppose I have a view that looks like View: StockRetreivedData col1...

Hi, I'm trying to store stock data in a data base. All stocks will store the date, open, high, low, close. Some stocks may also have additional information stored such as P/E ratios and Debt/Equity ratios. When I first thought of this, I figured I would store the data in a few tables and...

I'm thinking of a way to solve a problem with a treeview. One way I can solve it is by adding a hiddenfield for each node. I could end up with many hidden fields on the page (the tree could have thousands of nodes but it is safe to assume that they will not all be visible or even loaded at the...

Hi, I am thinking about making some useful DB packages out of code that I have worked on over the years and possibly sell them to other developers. I want to hide some code (mainly just stored procedures and some triggers). I can do this using encyption but I hear that the encryption in SQL...

Hi, I have a couple questions about what happens when people insert at the same time Case 1 Suppose that I have a table and two different users. User 1 does a bulk insert in the table. While this bulk insert is being performed, User 2 inserts a record. Will User 2's record appear at the...

Hi, I'm having difficulty finding out how to do the following in sql server 2005. I want to take two xml variables @a and @b, and combine them such that @c = @a + @b (so that @b would just appear after @a). I would also like to be able to say something like @a = '<xx>' + @a + '</xx><yy>' + @b...

I'm doing a project where we want to store the changes users make to a database so that they can be reverted. At first, this seemed like a good idea but the more and more I think about it, the more I realize that each update/delete/insert is going to have a lot of overhead. So here is our...

Hi, I created a trigger on a database once called EN_OT_NodeStructure_InsertTrigger. I have since dropped the trigger and it appears to be gone since IF OBJECT_ID ('EN_OT_NodeStructure_InsertTrigger', 'TR') IS NOT NULL SELECT 1 else SELECT 0 returns 0. However, when I go into the table...

Hi, I need to store lots of binary files. I'm considering storing them in a table in SQL server and I'm also considering storing them in a windows file folder (and just storing the path in SQL server). My main worry is access time. Will accessing the file from SQL server be way slower than...

Hi, I've been using a .NET tree view control and AJAX to show heirarchical data from my DB. However, it is slow. Each time I click a node or expand a branch I have to wait for the tree to do its post back. So, what I would like to do is create some sort of activeX control that maintains a...

I am trying to load a report dynamically into an ASP.net page. The problem si that the report just keeps loading forever. No errors or anything are generated. This is my code. I really appreciate an input Database crDatabase; Tables crTables...

I have an HP 8120 laptop with 512mb of DDR333 PC2700 ram in it. I want to add an additional gig but futureshop only sells DDR400 PC3200. I emailed HP and they said that only DDR333 was tested on my machine and that installing this other ram may cause a conflict. Is this true? Do I have to...

I have created a tab control that causes a postback. Only one tab is visible at a time but all the tabs contain datagrids and man other controls. All the controls within the invisible tabs are processed even though it is not necessary....is there a way to prevent this from happening (eg, when...