I used SQLMetal to generate a code file representing my database, and i can't figure out how to add entries to the database from the SQLMetal generated classes. How do i do this? do i just add to the various properties or something? ...
I imported the Stack Overflow data dump into SQL Server 2008. Some queries, especially on the Posts table, are taking more than a minute to return. Example query: SELECT Id, PostTypeId, AcceptedAnswerId, CreationDate, Score, ViewCount, Body, OwnerUserId, OwnerDisplayName, LastEditorUserId, LastEditDate, LastActivityDate, Tit...
Hello, I'm developing an application which needs to store large amounts of data. I cannot use SQL Server Express edition since it requires separate installation and our target customers have already loaded us with complaints about our previous release with SQL Server express. Now my choices are between SQL Server compact and Access. ...
Every single book that teaches programming (or almost anything else) starts off with a whole bunch of spiel on why what it's about (C++, mysql, waterskiing, skydiving, dentistry, whatever) is the greatest thing in the world. So I open the MySQL O'Reilly book, and read the intro, and get the traditional sermon. The main points that the bo...
Hello, I've spent hours trying to find a fix to this problem, but since I'm unable to find I've decided to ask here. I'm doing a procedure to retrieve information from a table based on the row's ROWID and with the results I'm doing some custom query using execute immediate. I've reduced the problem to the following lines, which I'm exec...
I'm looking to develop a small application on Mac OSX and it will need to use a database. Can anyone recommend one for the Mac? This will be my first Mac development so this is very much a newbie question. To help you I am interested in the following aspects: Is it suitable for small applications? (Important) Is it suitable for larger...
My DBA told me to use a user-defined SQL datatype to represent addresses, and then use a single column of that new type in our users table instead of multiple address columns. I've never done this before and am wondering if this is a common approach. Also, what's the best place to get information about this - is it product-specific? ...
When developing an application which mostly interacts with a database, what is a good way to start? The application requires a lot of filtering based on user input, sorting and structuring. ...
I am looking for an efficient sql backed collections library, for the Java programming language. I need to do database manipulations that fit very well the Collections API, is there something that can be a good bridge for that, or must I roll my own thing. ...
Where is the best place to place your Id Generator? Using Database Generators? Using Custom Generator? What are the advantages/disadvantages? ...
Using MS SQL Server 2005. On one of our servers we're running out of room, so I'm going through the databases, shrinking, removing, backuping etc. The largest file in the Data directory (an .mdf no less, not a .ldf) is not named according to our common naming-convention (it should reflect the database's name). I cannot move the file, s...
Hi, How can I store a video (either in database or file system) so that instead of starting streaming from starting I can start this streaming from any fix index. Main aim is like I have a large video of roads of New York from one end to other and corresponding map of New York save on a central server. Now a user opens up the website ...
Hi Folks, i want to create an Menu with Zend Navigation, with this markup : 1. Food 1.1 Drinks 1.2 Fruits 2. Cloths 2.1 Shirts 2.2 Shoes Filled from two DB tables : main_category / sub_category. But i can understand the documentation, possible to complex for me litte brain. If someone has an example for Zend Navgation feel free to ...
Hi Guys, I want to know when and where we use PDO's other than simple mysql_connect methods? Is this PDO is faster ? what are the advantages over other methods? ...
Hi everybody, I'm working partime for an company and my boss ask me to make an module for prestashop to read/write news ( only Text ) into a XML file. But i think load text form XML will be slowly. Anybody can tell me save text in XML file or Database, which better and why?? Thanks. :) ...
I have 2 files that I'd like to import into MS SQL. The first file is 2.2 GB and the second file is 24 GB worth of data. (if you are curious: this is a poker related look up table) Importing them into MS SQL is not a problem. Thanks to SqlBulkCopy I was able to import the first file in just 10 minutes. My problem is, I don't know how th...
ORIGINAL (see UPDATED QUESTION below) I am designing a new laboratory database that tests a wide variety of tests on a wide variety of sample types. The following list is my current candidate for the list of main entities to best model the laboratory work. For each entity, a 1-to-many relationship exists from that entity to the entit...
This should be painfully simple, but I cannot come up with a working connection string for a local copy of SQL Server 2008 using Windows Authentication. I've tried using the Data Link Properties tool to create a connection string and it has no problems connecting, but when I copy paste the generated string into my ADODB.Connection object...
Hello, I have been pulling my hair out about this since Friday and I am going nuts. I want to have the ability for a user to submit a form with an image, and have that image stored into a database. Then I want that image displayed on my index view. I have tried all of the other stackoverflow help topics on here already and none of th...
I´m using Delphi 7 with devart dbExpress to connect to SQLServer. The problem is that when I add a bigInt field to a ClientQuery it comes as TFMTBCDField. And the TFMTBCDField don´t have a method to get the 64 bit value. I can use the Field.AsVariant or the StrToInt64(Field.AsString) to pick this 64 bits value. Is there a better way t...