I can create a table and its columns in Java by using the statement: CREATE TABLE table_name(column1 int, column2 double, etc...) What I would like to do is to add descriptions to each of these columns with an appropriate statement, I found a stored procedure sp_addextendedproperty that looks like it can be used to accomplish this I j...
HI I want to find a particular field, which exist in tables of a Access database. Is there is any utility to find this? ...
In a financial system I am currently maintaining, we are relying on the rollback mechanism of our database to simulate the results of running some large batch jobs - rolling back the transaction or committing it at the end, depending on whether we were doing a test run. I really cannot decide what my opinion is. In a way I think this is...
I'm looking to copy a production postgres database to a development server. What's the quickest, easiest way to go about doing this? ...
Hi folks, I'm trying to implement persistent database connection pool with django. One of the options is to use built in psycopg2.pool code which provide different types of pools (PersistentConnectionPool, ThreadedConnectionPool etc ), but there is no psycopg2 documentation on that topic. So, do anyone done any work in this direction ...
Well, I know its a bit stupid. If I want to store a large amount of data. Should I use xml or database(mysql)? Why do you choose (that) one? What are the pros and cons using xml? What are the pros and cons using mysql? Clubpenguin, habbo hotel, those virtual worlds are using xml or mysql?? ...
The table is present in oracle database, I am updating that table with one record. It's executing and when I type select * from that table it's showing that record. But the problem is when I commit the changes. The table is showing nothing - I am not seeing anythng inside table, it's showing 0 records. Can you please help me? insert i...
I have setup 4 separate tables that have fk relationships between all of them. The main problem I am having is between a table called EmployeeQuestions and Questions tables. I am using Entity to model the objects. When I get my EmployeeQuestions object I check it to make sure that the relationship between the EmployeeQuestions and Emp...
My local newspaper's website recently rolled out a "DataMine" section of their website that has lots of great information I want to tap in to, but the results of a search are not too friendly to an inexperienced programmer myself. Does anyone out there have any experience with Caspio? Do you know if there are APIs I can hit? Does anyo...
I'm working on a .NET application using Silverlight on the client side. Now I've come to the point where I want to throw out my static dummy data on the server side and add a database instead. For the database I'd love to use one of them ORM's where I can simply tag my model classes and the database tables are built for me. I did some ...
Does aliasing tables names in large queries have noticeable impact on performance? Aliasing: ... ... FROM table_1 T1 ... ... ... Is it significantly different for the various DB systems out there? ...
Possible Duplicate: Stack Overflow / reddit voting system in php How do voting systems, like the one here at SO, work? I would like to implement a voting system on my web page (coded in php), but dont want to have to force the user to post a form to vote and update the database. I would like it so when a user clicks a thumbs up,...
Hello, I have an existing table that I'd like to use for a Rails application. It's a simple table with only 4 columns. However it does not yet have id column. And also new data will be added periodically. I am trying to find a way to add the id column and populate it. I guess I have two options, but being a noob I am sure there are b...
I've been to on a few interviews for middle tier roles. I've gotten a lot of questions about TSQL, indexing, database fundamentals, but not a single question on ADO. Is this a normal experience or is there a reason for this? ...
Hey everyone, I have written a web application that interacts with Google calendar (adds/edits/updates events). You may have seen one of my many posts about it. I had been struggling with the fact that sometimes I find my application to be slow on performing calendar operations. I have since come to the conclusion that it is not slow d...
SQLite is a great little database, but I am having an issue with it on Windows. It can take up to 50 seconds to perform a query on a 100MB database the first time the application is launched. Subsequent loads take 10% of that time. After some discussions on the SQLite mailing list, I am told "The bug is in Windows. It aggressively pre-...
Is there any way, either natively or through an addon, that I can filter the files shown in my database project in Visual Studio 2008 Database Edition? We have an older database that was worked on by lots of contractors, and so things aren't organized very well, and we have hundreds upon hundreds of stored procs and tables. So, not being...
I'm developing an app that handle sets of financial series data (input as csv or open document), one set could be say 10's x 1000's up to double precision numbers (Simplifying, but thats what matters). I plan to do operations on that data (eg. sum, difference, averages etc.) as well including generation of say another column based on co...
I want to programatically create a SQLDataSet in Delphi and use it to execute a Stored Procedure and get the value of an output parameter. Looks easy but I can't make it work. Here is a dumb stored procedure in SQL Server: CREATE PROCEDURE [dbo].getValue @x INT OUTPUT AS BEGIN SET @x = 10; END Now here is one of the variations tha...
I have a dataset which contains a string key field and up to 50 keywords associated with that information. Once the data has been inserted into the database there will be very few writes (INSERTS) but mostly queries for one or more keywords. I have read "Tagsystems: performance tests" which is MySQL based and it seems 2NF appears to be ...